Advertisement
Guest User

Untitled

a guest
Apr 21st, 2015
250
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. <?php
  2. //dumps to search bar
  3. if (isset($_GET['search']) && $_GET['search']!=''){
  4. $search=$_GET['search'];
  5. } else {
  6. $search='';
  7. }
  8.  
  9. echo"output:";
  10. $sql = "SELECT * FROM shows_criteria WHERE title like '%:search%' OR description like '%:search%' LIMIT 10";
  11. $q = $conn->prepare($sql);
  12. $q->execute(array(':search'=>$search));
  13.  
  14. while ($row = $q->fetch()){
  15. print_r($row);
  16. echo "<br>";
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement