9.1 PHP的mysqli扩展 实例254

new mysqli(string hostname, string username, 
string userpwd [,string databasename] );  

<?php
$conn=new mysqli("localhost","root","root","db_database09");
$conn->query("set names gb2312");
?> 

<?php
if($_POST[submit]!="")
{
include_once("conn.php");
$name=$_POST[name];
$sql=$conn->query("select * from tb_goods where name  like '%".$name."%'");
$info=$sql->fetch_array(MYSQLI_ASSOC);
if($info==NULL)
{
echo "<div align=center>没有查找到该商品!</div>";
}
else
{
?>
<table width="600" height="15" border="0" align="center" 
cellpadding="0" cellspacing="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="600" height="50" border="0" align="center" 
cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#0033FF"><table width="600" height="50" 
border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="156" height="25" bgcolor="#A2D4F4">
<div align="center">商品名称</div></td>
<td width="134" bgcolor="#A2D4F4"><div align="center">商品价格</div></td>
<td width="141" bgcolor="#A2D4F4"><div align="center">商品数量</div></td>
<td width="164" bgcolor="#A2D4F4"><div align="center">进货日期 </div></td>
</tr>
<?php
do
{
?>
<tr>
<td height="25" bgcolor="#FFFFFF">
<div align="center"><?php echo $info[name];?></div></td>
<td height="25" bgcolor="#FFFFFF">
<div align="center"><?php echo $info[price];?></div></td>
<td height="25" bgcolor="#FFFFFF">
<div align="center"><?php echo $info[shuliang];?></div></td>
<td height="25" bgcolor="#FFFFFF">
<div align="center"><?php echo $info[addtime];?></div></td>
</tr>
<?php
}
while($info=$sql->fetch_array(MYSQLI_ASSOC));
?>
</table></td>
</tr>
</table>
<?php
}
}
?>