Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. <?php
  2. // Connecting, selecting database
  3. $dbconn = pg_connect("host=***** port=*****
  4. dbname=***** user=***** password=*****")
  5. or die('Could not connect: ' . pg_last_error());
  6.  
  7. //collect
  8. if(isset($_POST['search'])) {
  9. $searchq = $_POST['search'];
  10. // $searchq = preg_replace("#[^0-9a-z]#i"."".$searchq);
  11.  
  12. // Performing SQL query
  13. $query = "SELECT vegan FROM enumbers WHERE code LIKE '%$searchq%'";
  14. $ret = pg_query($dbconn, $query);
  15. if(!$ret){
  16. echo pg_last_error($dbconn);
  17. exit;
  18. }
  19. $output = '';
  20. while($row = pg_fetch_assoc($ret)){
  21. $code = $row['code'];
  22. print_r($row);
  23. $name = $row['name'];
  24. $type = $row['type'];
  25. $vegan = $row['vegan'];
  26.  
  27. $output .= '<div> '.vegan.' ';
  28. }
  29. }
  30. echo "Operation done successfullyn";
  31. pg_close($dbconn);
  32.  
  33. ?>
  34.  
  35. <div id="tablebox">
  36. <!-- Search bar -->
  37. <p>Is It Vegan?</p>
  38. <form name="form1" method="post" action="searchEnumbers.php">
  39. <input name="search" type="text" size="30" maxlength="5" />
  40. <input name="submit" type="submit" value="Search" />
  41. </form>
  42.  
  43. <?php
  44. print("$output");
  45. ?>
  46. </div>
  47.  
  48.  
  49. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement