应用mysql_fetch_object()函数从数组结果集中获取信息

来源：互联网发布：晶晶改车软件官网编辑：程序博客网时间：2024/05/22 14:33
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link  href="style.css" rel="stylesheet"><title>应用mysql_fetch_object()函数从数组结果集中获取信息</title></head><body><table width="609" height="134"  border="1" cellpadding="0" cellspacing="0" bgcolor="#9E7DB4" align="center"> <form name="myform" method="post" action="">    <tr>   <td width="605" height="51" bgcolor="#CC99FF"><div align="center">请输入图书名称      <input name="txt_book" type="text" id="txt_book" size="25" >                  <input type="submit" name="Submit" value="查询"></div>  </td>  </tr></form>  <tr valign="top" bgcolor="#FFFFFF">     <td height="81">      <table width="100%" border="0" cellpadding="0" cellspacing="0">        <tr>          <td height="79" align="center" valign="top"> <br>             <table width="572"  border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#625D59">                <tr align="center" bgcolor="#CC99FF">                  <td width="46" height="20">编号</td>                  <td width="167">图书名称</td>                  <td width="90">出版时间</td>                  <td width="70">图书定价</td>                  <td width="78">作者</td>                  <td width="114">出版社</td>               </tr>                <?php$link=mysql_connect("localhost","root","root") or die("数据库连接失败".mysql_error());mysql_select_db("db_database18",$link);mysql_query("set names gb2312");$sql=mysql_query("select * from tb_book");$info=mysql_fetch_object($sql);if ($_POST[Submit]=="查询"){$txt_book=$_POST[txt_book];$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'"); //如果选择的条件为"like",则进行模糊查询$info=mysql_fetch_object($sql);}if($info==false){          //如果检索的信息不存在，则输出相应的提示信息    echo "<div align='center' style='color:#FF0000; font-size:12px'>对不起，您检索的图书信息不存在!</div>";}do{  ?>                <tr align="left" bgcolor="#FFFFFF">                  <td height="20" align="center"><?php echo $info->id; ?></td>                  <td > <?php echo $info->bookname; ?></td>                  <td align="center"><?php echo $info->issuDate; ?></td>                  <td align="center"><?php echo $info->first_name ; ?></td>                  <td align="center"> <?php echo $info->maker; ?></td>                  <td> <?php echo $info->publisher; ?></td>                </tr>                <?php}while($info=mysql_fetch_object($sql));?>            </table></td>        </tr>      </table>    <br></td>   </tr> </table></body></html>
0 0