<html>
<head>
<title>Search Questions</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$query = '';
$jenis = '';
$searchtype=$HTTP_POST_VARS['searchtype'];
$searchterm=$HTTP_POST_VARS['searchterm'];
$searchterm=trim($searchterm);
if (!$searchtype || !$searchterm)
{
echo 'You haven\'t entered search details. Please try again';
exit;
}
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
error_reporting(0);
@ $db = mysql_pconnect('localhost', 'root', '');
mysql_select_db('sistem bank soalan');
$jenis = $_GET["jenis"];
if (!$db)
{
echo 'Error: Xle connect pd db..hahaha padan muker!! ;p';
exit;
}
$query = "SELECT * FROM soalan WHERE ".$searchtype." LIKE '%".$searchterm."%'" ;
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
echo '<p>Number of question found: '.$num_results.'</p>';
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo '<p><strong>'.($i+1).'. No Soalan: ';
echo htmlspecialchars(stripslashes($row['id']));
echo'</strong><br />Soalan: ';
echo stripslashes($row['soalan']);
echo '<br />Jenis: ';
echo stripslashes($row['jenis']);
if ($jenis == "Objektif") {
echo '<br />A: ';
echo stripslashes($row['jwpA']);
echo '<br />B: ';
echo stripslashes($row['jwpB']);
echo '<br />C: ';
echo stripslashes($row['jwpC']);
echo '<br />D: ';
echo stripslashes($row['jwpD']);
echo '<br />Jawapan: ';
echo stripslashes($row['jwpObj']);
}
else {
echo '<br />Jawapan: ';
echo stripslashes($row['jwpSubj']);
}
echo '<br />Aras Kesukaran: ';
echo stripslashes($row['araskesukaran']);
echo '<br />Sesi Peperiksaan: ';
echo stripslashes($row['sesipeperiksaan']);
echo '<br />Bahagian: ';
echo stripslashes($row['bahagian']);
echo '<br />Add User: ';
echo stripslashes($row['adduser']);
echo '</p>';
}
?>
<p align="center"><font face="BatangChe"><strong> </strong></font></p>
</body>
</html>
NOTES: The above code is for the searching process. In my system there exists two types of question to be searched (means "objektif" and "subjektif" questions). The problem arises when I tried to display the search result. To explain my problem, u may refer the bold-codes. Those code (mainly in bold) do not flows well. Hopefully, anyone can help me to solve this problem.