用my_fetch_array()从数组结果中提取信息。

<div align="center">
<form action="" method="post">
<input type="text" name="text">
<input type="submit" value="submit" name="submit">
</form>
</div>

<?php
$bookname=$_POST['text'];

$link=mysql_connect("localhost","root","111111") or die("Can't connect database!".mysql_error());
$selected=mysql_select_db("test",$link);
mysql_query("set names gb2312");
$result=mysql_query("select * from book",$link);
$info=mysql_fetch_array($result);
if($_POST['submit']=='submit')
{
 $result=mysql_query("select * from book where bookname like '%".trim($bookname)."%'",$link);
 $info=mysql_fetch_array($result);
}
echo "<div align=\"center\"><table cellpadding=0 border=1 bgcolor=\"#FFFCCC\">";
do
{
 echo "<tr>";
 echo "<td>".$info[bookname]."</td><td>".
   $info[bookid]."</td><td>".$info[date]."</td><td>".$info[author]."</td>";
 echo "</tr>";
}while($info=mysql_fetch_array($result));
echo "</table></div>";
?>

转载于:https://www.cnblogs.com/imelephant/archive/2013/03/17/2964437.html