books

<html>
<body>
<?php
$username="root";
$password="";
$database="bookdb";
$con = mysql_connect("localhost",$username,$password);
$db=mysql_select_db("bookdb",$con);
$query = "select bname from book";
$result=mysql_query($query);
?>
<form method="post" action="bookdisp.php">
search:<select name=sel>
<?php
 while ($row = mysql_fetch_array($result))
 {
?>
<option><?php echo $row['bname'];?>
</option>
<?php }?>
</select>
<input type="submit" value="search">
</form>
<?php
mysql_close();
?>
</body></html>


<?php
$username="root";
$password="";
$database="bookdb";

$selval=$_POST["sel"];

$con = mysql_connect("localhost",$username,$password);
mysql_select_db("bookdb",$con);

$query = "select * from book where bname='$selval'";
$result=mysql_query($query);
echo "<table border=1><tr><th>BOOKID</th>

<th>BOOKNAME</th><th>BOOKpublisher</th><th>BOOKNumber</th></tr>";

$row = mysql_fetch_array($result);


echo "<tr><td>",$row['bookid'] ,"</td><td> ", $row['bname']," </td><td>", $row['bpublisher']," </td><td>", $row['bnumber'],"</td><tr></table><br>";


mysql_close();
?>