Code: Select all
$term = $_POST['search'];
$query = "SELECT * FROM Posts WHERE title LIKE '%".$term."%'";
$result = $db->arrayQuery($query,SQLITE_ASSOC);Code: Select all
$searchquery = $_POST['search'];
$keywords = explode(' ',$searchquery);Moderator: General Moderators
Code: Select all
$term = $_POST['search'];
$query = "SELECT * FROM Posts WHERE title LIKE '%".$term."%'";
$result = $db->arrayQuery($query,SQLITE_ASSOC);Code: Select all
$searchquery = $_POST['search'];
$keywords = explode(' ',$searchquery);Code: Select all
$terms = sqlite_escape_string($_GET['searchquery']);
$terms = str_replace(',',' ',$terms);
$terms = explode(' ',$terms);
$search = "";
foreach($terms as $t){
if(strlen($t)<3) continue; // skip search terms of 3 chars or less
$search .= ($search==''?'':' OR ')."title LIKE '%".$t."%' OR body LIKE '%".$t."%'";
}
//echo $search;
$query = "SELECT * FROM Posts WHERE (".$search.")";Code: Select all
$query = "SELECT * FROM Posts WHERE title like %'.$term 1.'% or title like %'.$term 1.'%Code: Select all
$terms = sqlite_escape_string($_GET['searchquery']);