Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //dumps to search bar
- if (isset($_GET['search']) && $_GET['search']!=''){
- $search=$_GET['search'];
- } else {
- $search='';
- }
- echo"output:";
- $sql = "SELECT * FROM shows_criteria WHERE title like '%:search%' OR description like '%:search%' LIMIT 10";
- $q = $conn->prepare($sql);
- $q->execute(array(':search'=>$search));
- while ($row = $q->fetch()){
- print_r($row);
- echo "<br>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement