Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. <select name="titel" id="titel" value="">
  2. <option value="">Selecteer</option>
  3. <?php
  4. if($rowCount > 0){
  5. while($row = $query->fetch_assoc()){
  6. echo '<option value="'.$row['titel'].'">'.$row['titel'].'</option>';
  7. }
  8. }else{
  9. echo '<option value="">Language not available</option>';
  10. }
  11. ?>
  12. </select>
  13.  
  14. 2nd page (search.php):
  15.  
  16. <?php
  17. //load database connection
  18. $host = "localhost";
  19. $user = "...";
  20. $password = "...";
  21. $database_name = "...";
  22. $pdo = new PDO("mysql:host=$host;dbname=$database_name", $user, $password, array(
  23. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  24. ));
  25. // Search from MySQL database table
  26.  
  27. $titel=$_POST['titel'];
  28. $version=$_POST['version'];
  29.  
  30. $query = $pdo->prepare("SELECT DISTINCT * FROM Library where titel = ? AND version = ?");
  31.  
  32. $query->bindValue(1, $titel, PDO::PARAM_STR);
  33. $query->bindValue(2, $version, PDO::PARAM_STR);
  34. $query->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement