PHP Search

Manat

Hello All

I have a question regarding a search box.
If I put a search box, php search box, onto my site, how would that work?

Our catalog is dynamic, so will the search query the catalog system, if not, then how? Or does it only search html text.

Also, in the search result pages, html links will be outputed based upon the search criteria, is there a way for me to append a query string into those links?

How exactly is this architectured?

DigitalExpl0it

if I was you id, search thru a database post the results on the page then the links should go off to another page for what ever that link needs to go.

adding varibles to links is very simple

<a href='test.php?var1=test&var2=test2'>Link</a>

above is a link with varibles in the link, var and var2

var = test
var2 = test2

so lets say you have a page called test.php

in test.php we have this

<? echo "$var<br>$var2"; ?>

this will print

test
test2

now for a search id recomend using a mysql database as the back end and just make a nice sql statement

now make a form and call a tesbox searchtxt

then have the form goto a page or the same page

here is an example on how to split the string and keep searching until all the strings are used

$split_search = explode(" ",$searchtxt);
for($i = 0; $i < count($split_search); $i++)
{

$sql = "SELECT * FROM table WHERE tableform LIKE '%$split_search[$i]%' ORDER BY tableform2 ASC";

finished example

<?
$split_search = explode(" ",$searchtxt);
for($i = 0; $i < count($split_search); $i++)
{

$db_connetion = "localhost";
$db_username = "";
$db_password = "";
$db_databse = "";

$connect = mysql_connect($db_connetion, $db_username, $db_password) or die ("Couldnt connect"); 
$db = mysql_select_db($db_databse, $connect) or die ("Couldnt open Database"); 
$sql = "SELECT * FROM table WHERE tableform LIKE '%$split_search[$i]%' ORDER BY tableform2 ASC";
$result = mysql_query($sql, $connect) or die("Could not execute query.<br>"); 

while ($row = mysql_fetch_array($result)){
$title = $row["fieldname"];
}

echo "$title";

mysql_close($connect);
?>

Manat

Our backend is a mySQL database.
We have a table called products.
Do I have to alter this table to fulltext?

And echo "$title"; is what outputs the search results?

Thanks

Also, will this search HTML text as well?

DigitalExpl0it

Originally posted by Manat
Our backend is a mySQL database.
We have a table called products.
Do I have to alter this table to fulltext?

And echo "$title"; is what outputs the search results?

Thanks

Also, will this search HTML text as well?

echo "$title"; is the output, this can be anything you want out from the database

this search will only search words, keywords sentences in the database only