Simple MySql Select Query with PHP Program
<?php
/*
* Author : Antony
* Created on 05-Feb-08
* Program Name : MySqlSelectFromDatabase.php
*/
//initilaize the mysql user name and oassword
$user=”root”;
$password=”123456″;
//database name
$database=”studentinfo”;
//get the information from bookdetails form
$isbn=$_POST['isbn'];
//connect the mysql database
$link=mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die(“Unable to Open Databse”);
//execute the query
$sql =”SELECT * FROM bookdetails WHERE isbn = $isbn”;
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if($num == 0)
{
echo “Record Not Found “;
}
else
{
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo “Book Name : $row[name] <br >”;
echo “Auhtor Name :$row[author] <br />”;
echo “Price : $row[price]<br />”;
}
}
mysql_free_result($result);
mysql_close($link);
?>