Untitled

<?php

include 'included.php';

if (!empty($_POST)) {

    $valid = true;

    $name = $_GET['name'];
    $price = $_GET['price'];
    $description = $_GET['description'];
    $sku = $_GET['sku'];
    $img = $_GET['img'];
    die($description);

    $query = $database_connection_pdo->prepare("INSERT INTO products(name,price,description,sku,img) VALUES(:name,:description,:sku,:img)");
    $query->bindParam(":name", $name);
    $query->bindParam(":price", $price);
    $query->bindParam(":description", $description);
    $query->bindParam(":sku", $sku);
    $query->bindParam(":img", $img);
    $query->execute();

}

?>

<body>
    <div class="container">
        <form method="post">

          <div class="form-group row">
            <label for="name" class="col-sm-2 col-form-label">Name</label>
            <div class="col-sm-10">
              <input name="name" class="form-control" id="name" placeholder="Name">
            </div>
          </div>

          <div class="form-group row">
            <label for="price" class="col-sm-2 col-form-label">Price</label>
            <div class="input-group col-sm-10">
                <div class="input-group-prepend">
                  <div class="input-group-text">$</div>
                </div>
              <input name="price" class="form-control" id="price" placeholder="Price">
            </div>
          </div>

         <div class="form-group row">
            <label for="description" class="col-sm-2 col-form-label">Description</label>
            <div class="col-sm-10">
              <input name="description" class="form-control" id="description" placeholder="Description" >
            </div>
          </div>

          <div class="form-group row">
            <label for="sku" class="col-sm-2 col-form-label">Sku</label>
            <div class="col-sm-10">
              <input name="sku" class="form-control" id="sku" placeholder="Sku">
            </div>
          </div>

          <div class="form-group row">
            <label for="image" class="col-sm-2 col-form-label">Images</label>
            <div class="col-sm-10">
            <select class="form-control" id="img" name="img">
              <?php

              $query = $database_connection_pdo->prepare("SELECT * from images");
              $result = $query->execute();

              if($result){

                  while($row = $query->fetch()){

                      echo '<option>'. $row['filename'] .'</option>';

                  }

              }

             ?>
            </select>
            </div>
          </div>

          <div class="form-group row">
            <div class="col-sm-10">
              <button type="submit" class="btn btn-primary">Add</button>
            </div>
          </div>
        </form>
    </div>
</body>

<?php

include 'footer.php';

?>