Jump to content

Search Engine Problem


shoyle
 Share

Recommended Posts

I'm begewiner in php, im trying to make a search engine and i got this from a tutorial but it says parse error unespected $ end in line 116.. I dont get why.. thats the last line and its empty :S heres my code: <?php // Get the search variable from URL $var = @$_GET['q'] ; $trimmed = trim($var); //trim whitespace from the stored variable// filas para el resultado$limit=10; // check for an empty string and display a message.if ($trimmed == "") { echo "<p>Ingrese una palabra...</p>"; exit; }// check for a search parameterif (!isset($var)) { echo "<p>We dont seem to have a search parameter!</p>"; exit; }//connect to your database ** EDIT REQUIRED HERE **mysql_connect("host","userr","pass"); //(host, username, password)//specify database ** EDIT REQUIRED HERE **mysql_select_db("database") or die("Unable to select database"); //select which database we're using// Build SQL Query $query = "select * from searchengine where keywords like \"%$trimmed%\" order by id"; // 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 alternativeif ($numrows == 0) { echo "<h4>Results</h4>"; echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>";// 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 forecho "<p>You searched for: "" . $var . ""</p>";// begin to show results set echo "Results<br>"; // now you can display the results returned $count=1; while ($row= mysql_fetch_array($result)) { $title = $row["url"]; echo "$count.)<a href=\"$title\">Click here to go to $title</a><br>" ; $count++ ; } // begin to show results set echo "Results<br>"; // now you can display the results returned $count=1; while ($row= mysql_fetch_array($result)) { $title = $row["url"]; echo "$count.)<a href=\"$title\">Haga click aqui para ir a: $title</a><br>" ; $count++ ; }$currPage = (($s/$limit) + 1);//break before paging echo "<br />"; // next we need to do the links to other results if ($s>=1) { // bypass PREV link if s is 0 $prevs=($s-$limit); print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><< Prev 10</a>  "; }// calculate 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 " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>"; }$a = $s + ($limit) ; if ($a > $numrows) { $a = $numrows ; } $b = $s + 1 ; echo "<p>Showing results $b to $a of $numrows</p>"; ?> thanks! :)

Edited by shoyle
Link to comment
Share on other sites

use code tags next time you post a bunch of code... anyway you're missing the end bracket here

if ($numrows == 0){echo "<h4>Results</h4>";echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>";// next determine if s has been passed to script, if not use 0

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...