QuestionAsk Questions?
sibymarysam
SEARCHING THE DATA FROM DATABASE AND DISPLAY THE SEARCHED DATA IN HTML PAGE
1 Answer(s) a year and 9 months ago
Posted in : PHP
1 Answer(s) a year and 9 months ago
Posted in : PHP
pls help me....in this i want to search books from the database...but it shows some errors. Error is Notice: Undefined variable: searching in C:\xampp\htdocs\project\opac1.php on line 10
HERE IS MY CODE
my html page is
<html>
<body>
<form name="search" method="post" action="opac1.php">
<div align="center"></div>
<div align="center"></div>
<div align="center">
<table width="300" border="0">
<tr>
<td width="81">Author</td>
<td width="209">
<label for="textfield2"></label>
<input type="text" name="find" id="textfield2" />
</td>
</tr>
<tr>
<td>Title</td>
<td>
<label for="textfield3"></label>
<input type="text" name="find" id="textfield3" />
</td>
</tr>
<tr>
<td>Accession no</td>
<td>
<label for="textfield4"></label>
<input type="number" name="find" id="textfield4" />
</td>
</tr>
<tr>
<td>Edition</td>
<td>
<label for="textfield5"></label>
<input type="number" name="find" id="textfield5" />
</td>
</tr>
<tr>
<td>Publisher</td>
<td>
<label for="textfield6"></label>
<input type="text" name="find" id="textfield6" />
</td>
</tr>
</table>
<table width="300" border="0">
<tr>
<td width="81">Year</td>
<td width="209">
<label for="textfield7"></label>
<input type="number" name="find" id="textfield7" />
</td>
</tr>
</table>
<p> </p>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
<input type="submit" name="button2" value="Clear" />
<img src="images/images (9).jpg" width="104" height="104" longdesc="images/images (9).jpg" />
</form>
</body>
</html>
php page is:
<?php
if ($searching =="yes"){
echo "<h3>Search Results</h3><p>";
if ($find == ""){
echo "<p>Please Enter a search term";
exit;
}
// Otherwise we connect to our Database
$con = mysql_connect("localhost");
if (!$con)
{
mysql_select_db("test") or die('Could not connect: ' . mysql_error());
}
// We preform a bit of filtering
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM book WHERE upper($field) LIKE'%$find%'");
//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['book id'];
echo " ";
echo $result['access no'];
echo "<br>";
echo $result['author'];
echo "<br>";
echo $result['title'];
echo " ";
echo $result['publisher'];
echo "<br>";
echo $result['year'];
echo "<br>";
echo "<br>";
}
//This counts the number or results - and if there wasn't any it gives them a little message explaining that
$anymatches=mysql_num_rows($data);
if ($anymatches == 0)
{
echo "Sorry, but we can not find an entry to match your query<br><br>";
}
}
?>
thank you for helping me out.
View Answers
August 20, 2011 at 10:29 PM
you just write a code look like this.
if ($ _POST['searching'] =="yes"){
echo "<h3>Search Results</h3><p>";
if ($ _POST['find'] == ""){
echo "<p>Please Enter a search term";
and
you have written each input type as number which is incorrect u just write input type
as text or whatever u want..
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
