Untitled

<!--
  - maak een dropdown van dvd's
  - maak een dropdown van klant
  - datum is vrij invoerveld

  https://www.phpro.org/tutorials/Dropdown-Select-With-PHP-and-MySQL.html

  http://thisinterestsme.com/populate-dropdown-list-mysql/

-->

<!doctype html>
<head>
  <meta charset="utf-8">
  <link href="css/bootstrap.min.css"rel="stylesheet">
  <script src="js/bootstrap.min.js"></script>
  <title>Add an order</title>

</head>

<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');


require 'database.php';

if( !empty($_POST)){
  $clientError = null;
  //$dvdError = null;
  //$dateError = null;


  $client = $_POST['client'];
  //$dvd = $_POST['dvd'];
  //$date = $_POST['date'];


  $valid = true;
  if(empty($client)){
    $titleError = "Please select a client";
    $valid = false;
  }

//  if(empty($dvd)){
//    $descriptionError = "Please select a dvd";
//    $valid = false;
//  }
//
//  if(empty($date)){
//    $dateError = "Please enter a date";
//    $valid = false;
//


  if($valid){
    $pdo = Database::connect();
    $pdo -> setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO tl_order(client_id, dvd_id, start_date) values(?,?,?)";
    $q = $pdo->prepare($sql);
    $q->execute(array($client));
    Database::disconnect();
    header("Location: order.php");
  }

}


?>


<body>

<div class="container">
  <div class="span10 offset1">
    <div class="row">
      <h3>Add a new order</h3>
    </div>


<!-- selecteer de klant -->
<form class="form-horizontal" action="createorder.php" method="post">
  <div class="control-group <?php echo !empty($clientError)?'error': '';?>">
  <label class="control-label">Client</label>
  <div class="controls">
  <select name="client" class="form-control"value="<?php echo !empty($client)?$client:'';?>" >
    <option selected disabled>Select a client</option>
    <?php
      include 'database.php';
      $pdo = Database::connect();
      $sql = 'SELECT id, CONCAT(tl_client.first_name," ", tl_client.last_name) AS "full_name" FROM tl_client';
      ?>
    <?php foreach($pdo -> query($sql) as $row){
      echo '<option value="'. $row['id'] .'">' . $row['full_name'] . '</option>'
      }

        ?>
  </select>
  <?php if (!empty($clientError)): ?>
  <span class="help-inline"><?php echo $clientError;?></span>
  <?php endif; ?>

</div>
</div>


  <div class="form-actions">
      <button type="submit" class="btn btn-success">Create</button>
      <a class="btn" href="order.php">Back</a>
      </div>

  </form>

  </div>

  </div>


  </body>

  </html>