Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.31 KB | None | 0 0
  1. // NEW COMMENT IN DATABASE
  2. $sql = "INSERT INTO comments (text, date) VALUES ('" . $text . "', NOW());";
  3.  
  4.  
  5. // SEARCH COMMENT IN DATABASE
  6. $stripsearchquery = stripaccents($searchquery);
  7. $sql = "SELECT id, text, date FROM comments WHERE MATCH (text) AGAINST ('" . $stripsearchquery . "' IN NATURAL LANGUAGE MODE)";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement