阅读背景:

通过传递许多关键字从前端搜索搜索框

来源:互联网 

Code:

if(isset($_POST['submit'])){
    if(isset($_GET['go'])){
        $key1 = trim($_POST['key']);
        $key2 = preg_replace("#[\s]+#", " ", $key1);
        $key = explode(" ", $key2);
        $con = mysql_connect("localhost","root","1234");

        if (!$con) {
            die('Could not connect: ' . mysql_error());
        }

        mysql_select_db("productdetails", $con);

        for($i = 0; $i < count($key); $i++){     
            $result = mysql_query("select * from proddetail where pname like '%".$key[$i]."%' or pcolor like '%".$key[$i]."%' or  psize LIKE '%".$key[$i]."%' or  mrp LIKE '%".$key[$i]."%' or  saleprize LIKE '%".$key[$i]."%' OR  pType LIKE '%".$key[$i]."%' or warranty LIKE '%".$key[$i]."%' or imagename LIKE '%".$key[$i]."%' or pKey LIKE '%".$key[$i]."%' GROUP by pname");
if(isset($_POST['submit'])){
    if(iss



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: