📄 qsearch.php
字号:
<style type="text/css">
<!--
.style1 {color: #ffffff}
-->
</style>
<?php
include('dbconnect.php');
?>
<?php
$search=$_POST['search1'];
$sql_search="select *from products where id like '%$search%' or product_id like '%$search%' or product_name like '%$search%'";
$sql_search=$sql_search."or price like '%$search%' or class_name like '%$search%' or origin like '%$search%' or info like '%$search%'";
//echo $sql_search;
?>
<link href="css/style.css" rel="stylesheet" type="text/css">
<p class="label">符合条件的产如下</p>
<table width="800" border="1" cellpadding="1" cellspacing="1" bordercolor="#999999">
<tr bgcolor="#6B5973" class="location">
<td width="59" nowrap class="style1">种类</td>
<td width="109" class="style1">编号</td>
<td width="110" class="style1">名称</td>
<td width="221" class="style1">价格</td>
<td width="221" class="style1">产地</td>
<td width="221" class="style1">产品介绍</td>
<td width="157" class="style1">操作</td>
</tr>
<?php
$count=0;
$result_product=mysql_query($sql_search,$conn);
while ($row_product=mysql_fetch_array($result_product)){
?>
<tr>
<td nowrap><?php echo $row_product['class_name'];?></td>
<td nowrap><?php echo $row_product['product_id'];?></td>
<td nowrap><?php echo $row_product['product_name'];?></td>
<td nowrap><?php echo $row_product['price'];?></td>
<td nowrap><?php echo $row_product['origin'];?></td>
<td nowrap><a href="product_view.php?id=<?php echo $row_product['id'];?>" title=<?php echo $row_product['info'];?> ><?php echo substr($row_product['info'],0,20);?></a></td>
<td nowrap> [<a href="product_edit.php?id=<?php echo $row_product['id'];?>">修改</a>] [<a href="upload/uploadimage.php?id=<?php echo $row_product['id'];?>">修改图片</a>] [<a href="process.php?id=<?php echo $row_product['id'];?>&action=delete">删除</a>]</td>
</tr>
<?php
$count++;
}
?>
</table>
<p><?php echo "<p>总共找到<font color=red> ".$count." </font>相关种产品</p>"; ?></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -