Advertisement
Guest User

Untitled

a guest
May 2nd, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. // Search from MySQL database table
  2. $search=$_POST['search'];
  3. $stat=$_POST['stat'];
  4.  
  5. $split = explode(" ", $search);
  6.  
  7. $query = $pdo->prepare("SELECT itemname, itemprice, itemupdate, itemstat, itemmarket, itemdiff FROM premium WHERE itemname LIKE ? AND itemname LIKE ? AND itemname LIKE ? AND itemname LIKE ? AND itemname LIKE ? AND itemname LIKE ? AND itemstat=? ORDER BY itemprice DESC LIMIT 15");
  8. $query->bindValue(1, "%$split[0]%", PDO::PARAM_STR);
  9. $query->bindValue(2, "%$split[1]", PDO::PARAM_STR);
  10. $query->bindValue(3, "%$split[2]", PDO::PARAM_STR);
  11. $query->bindValue(4, "%$split[3]", PDO::PARAM_STR);
  12. $query->bindValue(5, "%$split[4]", PDO::PARAM_STR);
  13. $query->bindValue(6, "%$split[5]", PDO::PARAM_STR);
  14. $query->bindValue(7, $stat);
  15. $query->execute();
  16.  
  17. SELECT * FROM premium WHERE itemname LIKE $split[0] and itemname LIKE $split[1] and itemname Like $split[2] ... and so on ...
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement