qsearch.php

电子商务---产品发布系统 采用PHP+MYSQL+APACHE的环境,非常方便的一个小系统,可以嵌入其他系统内使用

<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>