Advertisement
Guest User

Untitled

a guest
Jun 30th, 2014
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. $q_tags = '';
  2. $q_tags_arr = array();
  3. foreach($tags as $tag) {
  4. if(empty($q_tags)) $q_tags .= "tag LIKE ?";
  5. else $q_tags .= " OR tag LIKE ?";
  6. $q_tags_arr[] = '%'.$tag.'%';
  7. }
  8.  
  9. $q_tags_arr[] = $yourValidatedUserInput;
  10. $relatedStmt = $db->prepare(
  11. 'SELECT * FROM items WHERE ('.$q_tags.') AND id <> ? ORDER BY id DESC LIMIT 20'
  12. );
  13.  
  14. $relatedStmt->execute(
  15. $q_tags_arr
  16. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement