search_process.php

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

<?php 
 include('dbconnect.php');
 ?>
 <?php
  
   $product_id=$_POST['product_id'];
   $product_name=$_POST['product_name'];
   $price=$_POST['price'];
   $origin=$_POST['origin'];
   $classes=$_POST['classes'];
   $info=$_POST['info'];
   
   //echo $product_id,$product_name,$price,$origin,$classes,$info;

  //去除空格
  if ($product_id=="" && $product_name=="" && $price=="" && $origin=="" && $classes=="" && $info=="") {
  	echo "<div align=center>请输入查询条件<br>";
	echo "<a href='javascript:history.back(-1)'>后退</a></div>";
	exit();
	}
  //查询函数
  function Get_search_id() {
  	$args=func_get_args();
	$queryfield=$args[0];
	$queryvalue=$args[1];
	$conn=$args[2];
	
	$id_search=array();
	
	$sql_search="select id from products where ".$queryfield." like '%".$queryvalue."%'";
	 
	$re_search=mysql_query($sql_search,$conn);
	while ($row_search=mysql_fetch_array($re_search)) {
		array_push($id_search,$row_search[0]);
		}
	return $id_search;
	}
	//查询结果
	$resultid=array();
	$arr=array();
	// 是否有查询结果标记
	$flag=0;
	
	if($product_id!="") {
		$product_id_id=array();
		$result=mysql_query("select id from products where product_id like '%$product_id%'" , $conn);
		while ($row=mysql_fetch_array($result)) {
			array_push($product_id_id,$row[0]);
		}
		$flag=1;
		$resultid=$product_id_id;
	}
	if($product_name!="") {
	    $product_name_id=array();
		$product_name_id=Get_search_id("product_name",$product_name,$conn);
		 if($flag==0) {
		 	$resultid=$product_name_id;
			}
			else {
			$flag=1;
			$arr=array_intersect($resultid,$product_name_id);
			$resultid=$arr;
			}
		}
	if($price!="") {
	    $price_id=array();
		$price_id=Get_search_id("price",$price,$conn);
		 if($flag==0) {
		 	$resultid=$price_id;
			}
			else {
			$flag=1;
			$arr=array_intersect($resultid,price_id);
			$resultid=$arr;
			}
		}
	if($origin!="") {
	    $origin_id=array();
		$origin_id=Get_search_id("origin",$origin,$conn);
		 if($flag==0) {
		 	$resultid=$origin_id;
			}
			else {
			$flag=1;
			$arr=array_intersect($resultid,origin_id);
			$resultid=$arr;
			}
		}
	if($classes!="") {
	    $classes_id=array();
		$classes_id=Get_search_id("class_name",$classes,$conn);
		 if($flag==0) {
		 	$resultid=$classes_id;
			}
			else {
			$flag=1;
			$arr=array_intersect($resultid,$classes_id);
			$resultid=$arr;
			}
		}
	if($info!="") {
	    $info_id=array();
		$info_id=Get_search_id("info",$info,$conn);
		 if($flag==0) {
		 	$resultid=$info_id;
			}
			else {
			$flag=1;
			$arr=array_intersect($resultid,info_id);
			$resultid=$arr;
			}
		}
	
	$search_num=count($resultid);
	
	echo "<h2 align=center>查询结果</h2>";
	
	if($search_num==0) {
	echo "<div align=center><font color=red>没有找到符合查询条件的产品</font></div>";
	echo "<div align=center><font color=red><a href='javascript:history.back(-1)'>后退</a></div>";
	exit();
	}
	echo "<div align=center>找到符<font color=red>$search_num</font>合查询条件的产品</div>";
	echo "<br>";
?>
<link href="css/style.css" rel="stylesheet" type="text/css">
<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
  	for($i=0;$i<$search_num;$i++) {
  	$sql_search="select * from products where id='$resultid[$i]' order by class_name";
	$result_search=mysql_query($sql_search,$conn);
	$info_search=mysql_fetch_array($result_search)
	?>
  <tr>
    <td nowrap><?php echo $info_search['class_name'];?></td>
    <td nowrap><?php echo $info_search['product_id'];?></td>
    <td nowrap><?php echo $info_search['product_name'];?></td>
    <td nowrap><?php echo $info_search['price'];?></td>
    <td nowrap><?php echo $info_search['origin'];?></td>
    <td nowrap><a href="product_view.php?id=<?php echo $info_search['id'];?>" title=<?php echo $info_search['info'];?> ><?php echo substr($info_search['info'],0,20);?></a></td>
    <td nowrap> [<a href="product_edit.php?id=<?php echo $info_search['id'];?>">修改</a>] [<a href="upload/uploadimage.php?id=<?php echo $info_search['id'];?>">修改图片</a>] [<a href="process.php?id=<?php echo $info_search['id'];?>&action=delete">删除</a>]</td>
  </tr>
  <?php
	
	}
?>
</table>
<?php echo "<div align=center><font color=red><a href='javascript:history.back(-1)'>返回</a></div>"; ?>