Code: Select all
<?
if(!isset($submit) && $submit=='go')
{
echo "<form name='form1' action=$PHP_SELF method='post'>";
echo "Keywords: <input type='text' name='keyword'>";
echo "<input type='submit' name='submit' value='go'>";
}
else
{
echo <<<EOQ
<table cellpadding=0 cellspacing=0 border=0 width=950>
<tr><td><img src="images/logo.gif" alt="" border="0" align="left" hspace=0 width=100></td>
<td width=900><br><span style="color:#000000;font-family:arial;font-size:20pt">Boat Salvage</span><br><br></td>
</tr>
</table>
EOQ;
mysql_connect("localhost");
mysql_select_db("Ads");
$query = "select * from user_Ads where $searchMethod == '$keyword' limit $resultsStart,$rowsToShow";
$results=mysql_query($query);
$totalResults = mysql_num_rows($results);
$totalColumns = mysql_num_fields($results);
if($totalResults == 0)
{
echo "Your search for <b>$keyword</b> resturned <b>0</b> results. Please try other keyword(s).";
}
else
{
echo "Your search for <b>$keywords</b> returned <b>$totalResults</b> results.";
echo <<<EOQ
<form name=form1 action=$PHP_SELF method=post>
<input type='hidden' name='resultId' value=$pageNumber*5>
<input type='hidden' name='pageNumber' value=$page>
<input type='hidden' name='submit' value='go'>
<input type='hidden' name='searchMethod' value=$searchMethod>
<input type='hidden' name='rowsToShow' value=$rowsToShow>
<input type='hidden' name='keyword' value=$keyword>
<input type='hidden' name='resultsStart' value=$resultsStart>
</form>
<a href='index.html'>New Search</a><br><br>
EOQ;
if($totalResults > 0 && $totalResults - ($pageNumber * 5) > 0 && $pageNumber != 1)
{
echo "<a href='search2.php?resultId=";
echo $pageNumber*5;
echo "&pageNumber=";
echo $pageNumber-1;
echo "&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
echo $resultsStart-5;
echo "'><--Prev</a> ";
for($i=0;$i<$totalResults/5;$i++)
{
echo "<a href='search2.php?resultId=";
echo $pageNumber*5;
echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
echo $i*5;
echo "'>$i</a> ";
}
echo "<a href='javascript:document.form1.submit()'>Next--></a><br>";
}
elseif($num_results>=1 && $num_results - ($page*5) <= 0)
{
echo "<a href='search2.php?resultId=";
echo $pageNumber*5;
echo "&pageNumber=";
echo $pageNumber-1;
echo "&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
echo $resultsStart-5;
echo "'><--Prev</a> ";
for($i=0;$i<$totalResults/5;$i++)
{
echo "<a href='search2.php?resultId=";
echo $pageNumber*5;
echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
echo $i*5;
echo "'>$i</a> ";
}
}
else
{
for($i=0;$i<$totalResults/5;$i++)
{
echo "<a href='search2.php?resultId=";
echo $pageNumber*5;
echo "&pageNumber=$i&submit=go&searchMethod=$searchMethod&rowsToShow=5&keyword=$keyword&resultsStart=";
echo $i*5;
echo "'>$i</a> ";
}
echo "<a href='javascript:document.form1.submit()'>Next--></a>\n</form>\n";
}
}
while ($row = mysql_fetch_row($result))
{
$resultCount += 1;
echo "<table border=0 width=900 cellpadding=0 cellspacing=0>\n";
echo "<tr><td bgcolor='#004080'><center><span style='color:#ffffff;width:100%'><b>Part:</b>$rowї7] $rowї9] $rowї8]--><b>Category:</b> $rowї6]</span></center></td></tr>";
echo "<tr bgcolor=#e1e1e1>\n";
echo "<td>";
echo "<b>$resultCount</b>. $rowї2], $rowї1]<blockquote>$rowї10]<br><b>E-mail:</b> <a href='mailto:$rowї3]'>$rowї3]</a><br><b>Phone:</b> $rowї4] <b>Fax:</b> $rowї5]<br>";
$i = 11;
echo "</td>\n";
echo "</tr>\n";
echo "</table>";
echo "<br><br>";
}
}
?>