PHP+MySQL 利用mysql_fetch_row模糊查询图书信息

来源：互联网发布：淘宝上注册商标靠谱吗编辑：程序博客网时间：2024/06/02 02:21
一代码
td{  font-size:9pt;}.style2 {color: #FFFFFF}<!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_row()函数从数组结果集中获取信息</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" >       &nbsp;          <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_database13",$link);mysql_query("set names gb2312");$sql=mysql_query("select * from tb_book");$row=mysql_fetch_row($sql);if ($_POST[Submit]=="查询"){$txt_book=$_POST[txt_book];$sql=mysql_query("select * from tb_book where bookname like '%".trim($txt_book)."%'"); //如果选择的条件为"like",则进行模糊查询$row=mysql_fetch_row($sql);}if($row==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 $row[0]; ?></td>                  <td >&nbsp;<?php echo $row[1]; ?></td>                  <td align="center"><?php echo $row[2]; ?></td>                  <td align="center"><?php echo $row[3]; ?></td>                  <td align="center">&nbsp;<?php echo $row[4]; ?></td>                  <td>&nbsp;<?php echo $row[5]; ?></td>                </tr>                <?php}while($row=mysql_fetch_row($sql));?>            </table></td>        </tr>      </table>    <br></td>   </tr> </table></body></html>
二运行结果
查看图片附件
阅读全文
0 0