本文共 966 字,大约阅读时间需要 3 分钟。
比如查询的条件有:开始时间,结束时间,操作人,商品名称
而且,操作人和商品名称需要模糊查询以下是sql拼接的方法:
$StartData = $_POST['StartData'] ;$EndData = $_POST['EndData'] ;$user_name = $_POST['user_name'] ;$product_name = $_POST['product_name'] ;$where = '';if(!empty($StartData)){ $where .= " and StartData >= ' " . $StartData ."'";//where语句拼接 } if(!empty($EndData)){ $where .= " and EndData < ' " . $EndData."'";//where语句拼接 } if(!empty($user_name )){ $where .= " and user_name like '% " . $user_name ."%'";//where语句拼接 } if(!empty($product_name )){ $where .= " and product_name like '% " . $product_name ."%'";//where语句拼接 }$sql = "select * from orders where 1 ". $where . " order_by time asc";
转载地址:http://bsyen.baihongyu.com/