[SOLVED] Critiquing Search

[jakebur01]

Please help me to better this search. It is searching columns in my database. If $mysearch is a phrase of three or four words the search does not work well at all. Only one word searches will pull data.

 

Is their some way to bust up $mysearch to where it will search a phrase. Ex. "Universal Gas Cap"

function get_search_books($mysearch)
{
   // query database for the books in a category
  $mysearch =$_POST['searchlike'];
  $mysearch= trim($mysearch);
   if (!$mysearch || $mysearch=='')
     return false;
   
   $conn = db_connect();
  $sql = "SELECT No, description, title, author, isbn, price FROM books ";
$sql .= "WHERE `No` LIKE '%$mysearch%' ";
$sql .= "OR `description` LIKE '%$mysearch%' ";
$sql .= "OR `title` LIKE '%$mysearch%' ";
$sql .= "OR `author` LIKE '%$mysearch%' ";
$sql .= "OR `isbn` LIKE '%$mysearch%' ";

   $result = @$conn->query($sql);
   if (!$result)
     return false;
   $num_books = @$result->num_rows;
   if ($num_books ==0)
      return false;
   $result = db_result_to_array($result);
   return $result;
}

[darkfreaks]

try using the MATCH function in SQL look it up

[jakebur01]

I found some stuff on preg_match, is this what I need. I need a little boost on how to empliment something like that into the current code that I have.

[darkfreaks]

no in your SQL statement use MATCH like

 

WHERE MATCH (variable,variable2) AGAINST ("$keyword")

[jakebur01]

Like this?

 $sql = "SELECT No, description, title, author, isbn, price FROM books WHERE MATCH No, description, title, author, isbn, price AGAINST '$mysearch'";

[darkfreaks]

looks good

[jakebur01]

It's not pulling anything now. What am I doing wrong?

 

function get_search_books($mysearch)
{
   // query database for the books in a category
  $mysearch =$_POST['searchlike'];
  $mysearch= trim($mysearch);
   if (!$mysearch || $mysearch=='')
     return false;
   
   $conn = db_connect();
   
    $sql = "SELECT No, description, title, author, isbn, price FROM books WHERE MATCH No, description, title, author, isbn, price AGAINST '$mysearch'";
/* $sql = "SELECT No, description, title, author, isbn, price FROM books ";
$sql .= "WHERE `No` LIKE '%$mysearch%' ";
$sql .= "OR `description` LIKE '%$mysearch%' ";
$sql .= "OR `title` LIKE '%$mysearch%' ";
$sql .= "OR `author` LIKE '%$mysearch%' ";
$sql .= "OR `isbn` LIKE '%$mysearch%' "; */

   $result = @$conn->query($sql);
   if (!$result)
     return false;
   $num_books = @$result->num_rows;
   if ($num_books ==0)
      return false;
   $result = db_result_to_array($result);
   return $result;
}

[darkfreaks]

<?php

$sql = "SELECT No, description, title, author, isbn, price
FROM books WHERE MATCH (No, description ,title, author, isbn, price) AGAINST
('%$mysearch%')";?>

[jakebur01]

Still no dice. I don't know what's going on, i've been playing with it. I don't want to drive you crazy with this thing man.

[darkfreaks]

should look up MYSQL MATCH function it tells ya how to go about doing a search that way

 

 

http://devzone.zend.com/node/view/id/1304