I'm doing a search application for my project. My code can prompt
alert popup window when the user doesn't key in any keywords. However,
if the user keys in any keywords, it juz return "Please enter
keywords!" whatever it is. I had set proper looping for suitable
condition checking, but it is still generate the same problem.
<html>
<head>
<title>Searchin g Results</title>
</head>
<body background="abs tract.gif">
<link rel="STYLESHEET " type="text/css" href="styleshee t.css">
<?php
echo "<h1>Search ing Results</h1>";
//perform search
if($_POST['submit'] == "")
{
echo "post";
//if(isset($_POST['submit']))
//{
$db = mysql_connect(" localhost", "root", "") or die(mysql_error ());
mysql_select_db ("bulletin", $db) or die(mysql_error ());
$searchWords = explode(" ", $_POST['textfield']);
foreach ($searchWords as $word)
{
if ($word)
{
$whereParts[] = "`TITLE` LIKE '%{$word}%' OR `DEPARTMENT` LIKE '%
{$word}%'" ;
}
}
$whereClause = implode(" OR ", $whereParts);
$query = "SELECT * FROM `bul_data` WHERE {$whereClause} ORDER by
`DATE`";
$res = mysql_query($qu ery) or die(mysql_error ());
echo "query=".$query ;
if(mysql_num_ro ws($res)>0)
{
echo "<table width=\"100%\" border=\"1\">";
echo "<tr>";
echo "<th class=\"normal\ ">Date</th>";
echo "<th class=\"normal\ ">Title</th>";
echo "<th class=\"normal\ ">Departmen t</th>";
echo "<th class=\"normal\ ">Link</th>";
echo "</tr>";
while($row=mysq l_fetch_assoc($ res))
{
$date = $row['DATE'];
$date = decode($date);
$title = $row['TITLE'];
$title = decode($title);
$department = $row['DEPARTMENT'];
$department = decode($departm ent);
$link = $row['LINK'];
$link = decode($link);
echo "<tr>";
echo "<td><strong>$d ate</strong></td>";
echo "<td><strong>$t itle</strong></td>";
echo "<td>$departmen t</td>";
echo "<td><a href = \"$link\">$link </a></td>";
echo "</tr>";
}
echo "</table>";
}
//}
}
else
{
echo "38292930";
echo "Please enter keywords!";
//echo "<script language=\"Java Script\">
//<!--
//alert('Please enter keywords!');
//-->
//</script>";
}
//function decode($string)
//{
// $string = str_replace("&a mp;", "&", $string);
// $string = str_replace("&l t;", "<", $string);
// $string = str_replace("&g t;", ">", $string);
// $string = str_replace("'" , "'", $string);
// $string = str_replace("&q uot;", "\", $string);
//
// return $string;
//}
function decode($text)
{
$text = html_entity_dec ode($text,ENT_Q UOTES);
return $text;
}
?>
<br>
<table width ="100%" border ="0" cellspacing ="1" cellpadding ="2">
<tr>
<td class="normal" width ="10%" align ="center"><a href =
"homepg.php">Ho me | </a><a href =
"search.php">Se arch Again?</a></td>
</tr>
</table>
</body>
</html>
