PHP - Php Word Search Generator

Hello,

Does anyone know a tutorial I can follow to create my own search engine over the items I have in my SQL database?
I find a lot of tutorials but they are all 'one word searches' which means if you type two words you will get all results that contain either word (too many hits).

If the search engine tutorial displays result with AJAX even better.

Thanks for help.
df

I am trying to find the last word before a search pattern.  I tried preg_match without any luck.  I found something close online but it does a match for the first match for the pattern.

I know that I will always see , some # pressure.  I want that # right before the word pressure but there are a lot of , in the page.

Thanks in advance.

Code: [Select]
function get_string_between($string, $start, $end){
$string = " ".$string;
$ini = strpos($string,$start);
if ($ini == 0) return "";
$ini += strlen($start);
$len = strpos($string,$end,$ini) - $ini;
return substr($string,$ini,$len);
}

$fullstring = "today, Sat, 750 pressure";
$parsed = get_string_between($fullstring, ", ", "pressure");

Hey All,
 I'm trying to add multiple word search to my site and I'm getting the following error: "mysql_num_rows(): supplied argument is not a valid MySQL result resource " I know, my search is posting because I'm getting my search terms back with the "nothing found" message I have set up. Here's what I have:
Code: [Select]
  $search = $_POST["search"]; 
  $arraySearch = explode(" ", $search);
  $arrayFields = array(0 => "title", 1 => "content");
  $countSearch = count($arraySearch);
  $a = 0;
  $b = 0;
  $query = "SELECT * FROM table1 WHERE desc LIKE '$arraySearch'";
  $countFields = count($arrayFields);
  while ($a < $countFields)
  {
    while ($b < $countSearch)
    {
      $query = $query."$arrayFields[$a] LIKE '%$arraySearch[$b]%'";
      $b++;
      if ($b < $countSearch)
      {
        $query = $query." AND ";
      }
    }
    $b = 0;
    $a++;
    if ($a < $countFields)
    {
      $query = $query.") OR (";
    }
  }
  $query = $query.")";
  $query_result = mysql_query($query);

 
  if(mysql_num_rows($query_result) < 1)
   {
    echo '<p>No matches found for "'.$search.'"</p>';
  }
  else
  {
   Print "<table border cellpadding=3>";
    while($row = mysql_fetch_assoc($query_result))
    {
      Print "<th>Description:</th> <td>".$row['desc'].  "</td> ";
    }
 Print "</table> ";   
}

You guys are the best, thanks so much.

hi all,
in mysql, how can i extract 100 words before and 100 words after my search key?
example:

"Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nulla est nibh, mattis eu mattis id, pulvinar eu augue. Duis ut sem nisi. Sed id ante sed orci vestibulum lacinia ac id nibh. Donec cursus, elit eget auctor semper, ipsum eros laoreet quam, nec ullamcorper"

vestibulum is my search key

i am having the database consists of morethan one lac rows. we have a search option
in our website to search the database for required information. the present code is
like this:

form.php

`<input type="radio" name="tag" value="city" /> CITY <br/>`
`<input type="radio" name="tag" value="name" /> NAME OF CUSTOMER <br/>`
`<input type="radio" name="tag" value="amount" /> CHEQUE AMOUNT <br/>`
`<input type="radio" name="tag" value="somethingelse" /> some thing else
`
`Enter the part of any of the above Here :<input type="text" name="value" />`


search.php

`$tag = $_POST['tag'];`
`$value = $_POST['value'];`

`$query = "SELECT * FROM database WHERE $tag LIKE '%$value%' "`

note: we always input the part field only.


with this some times the output comes in thousands of rows. with which we are facing
problems.


we want to search the two or more fields for getting more precise results.

hence i tried this form:

`<h3 align="center">ENTER ALL OR DESIRED ITEMS YOU WANT TO SEARCH</h3>`
`<div width="80%" align="center">`
`<input type="text" name="city" /> CITY <br/>`
`<input type="text" name="name" /> NAME OF THE CUSTOMER <br/>`
`<input type="text" name="amount" /> AMOUNT <br/>`
`<input type="text" name="somethingelse" /> SOME OTHER SEARCH FIELD </div> `

`$query = "SELECT * FROM database WHERE city LIKE %$city%' || name LIKE %$name%' ||
amount LIKE %$amount%' || somethingelse LIKE %$somethingelse%';`

it worked in the mysql console, and even in our website when we give all the
variables. but it displaying the entire database when we dont give even one field in
the search box. i tried to assign NULL to the variable which was not given. it is
also not worked. it works if any variable is replaced with NULL in the query. i
don't know how to do that.


i tried a lot of queries after searching in lot of code provider websites. but none
of them gave the desired results.hence i request you to provide me a sql query code
for search the database using all of the above fields or any two or even with one.
the code must work independent of number of fields we entered.