Posts tagged search

// rows to return
$ limit=10;

// check for an empty string and display a message.
if ($ trimmed == “”)
{
echo “Please enter a search query…”;
exit;
}

// check for a search parameter
if (!isset($ var))
{
echo “

We dont seem to have a search parameter!

“;
exit;
}

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect(“localhost”,”hampto24_forumu”,”reebok12″); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db(“hampto24_search”) or die(“Unable to choose database”); //select which database we are using

// Build SQL Query
$ query = “SELECT * FROM sitesearch WHERE title LIKE ‘%$ trimmed%’ OR url LIKE ‘%$ trimmed%’ OR description LIKE \”%$ trimmed%\”
“; // EDIT HERE and specify your table and field names for the SQL query

$ numresults=mysql_query($ query);
$ numrows=mysql_num_rows($ numresults);

// If we have no results, offer a google search as an alternative

if ($ numrows == 0)
{
echo “

Results

“;
echo “

Sorry, your search: “” . $ trimmed . “” returned zero results

“;

// google
echo “

Click here to try the
search on google

“;
}

// next determine if s has been passed to script, if not use 0
if (empty($ s)) {
$ s=0;
}

// get results
$ query .= ” limit $ s,$ limit”;
$ result = mysql_query($ query) or die(“Couldn’t execute query”);

// display what the person searched for
echo “

You searched for ” . $ var . “

“;

// start to show results set
echo “”;
$ count = 1 + $ s ;

// now you can display the results returned
while ($ row= mysql_fetch_array($ result)) {
$ title = $ row["title"];
$ desc = $ row["description"];
$ url = $ row['url'];
$ fav = $ row['favicon'];

echo “$ count. 
$ title

     $ desc

     $ url
” ;
$ count++ ;
}

$ currPage = (($ s/$ limit) + 1);

//break before paging
echo “
“;

// next we need to do the links to other results
if ($ s>=1) { // bypass PREV link if s is 0
$ prevs=($ s-$ limit);
print “ < <
Prev 10&nbsp ”;
}

// compute number of pages needing links
$ pages=intval($ numrows/$ limit);

// $ pages now contains int of pages needed unless there is a remainder from division

if ($ numrows%$ limit) {
// has remainder so add one page
$ pages++;
}

// check to see if last page
if (!((($ s+$ limit)/$ limit)==$ pages) && $ pages!=1) {

// not last page so give NEXT link
$ news=$ s+$ limit;

echo “ Next 10 >>“;
}

$ a = $ s + ($ limit) ;
if ($ a > $ numrows) { $ a = $ numrows ; }
$ b = $ s + 1 ;
echo “

Showing results $ b to $ a of $ numrows

“;

?>

I want it to be so that when some one enters a query in the search box, the it shows up in bold on the results page in the description, title, or url.
How do I do that?

Read More >>