php->msql 多條件查詢

標籤：new   html   沒有   row   刪除   table   foreach   action   htm   

d多條件查詢

 

 

body><br /><form action="duotiaojian.php" method="post"><div>姓名:<input type="text" name="xm" /> 民族代號：<input type="text" name="mz" /><input type="submit" value="查詢" /></div></form><br /><table width="100%" border="1" cellpadding="0" cellspacing="0">    <tr>        <td>代號</td>        <td>姓名</td>        <td>性別</td>        <td>民族</td>        <td>生日</td>        <td>操作</td>    </tr>        <?php        //先判斷有沒有提交值    $xxm = "";    $tj = " 1=1 ";    $tj2 = " 1=1 ";    if(!empty($_POST["xm"]) && $_POST["xm"]!="")    {        $xxm = $_POST["xm"];        $tj = " name like ‘%{$xxm}%‘ ";    }        if(!empty($_POST["mz"]) && $_POST["mz"]!="")    {        $mz = $_POST["mz"];        $tj2 = " nation=‘{$mz}‘ ";    }                //造連線物件    $db = new  MySQLi("localhost","root","123","mydb");    //寫SQL語句    $sql = "select * from info where ".$tj." and ".$tj2;    echo $sql;    //執行SQL語句    $result = $db->query($sql);    //讀資料    $attr = $result->fetch_all();        foreach($attr as $v)    {        echo "<tr>";                $sex = $v[2]?"男":"女";                //根據名族代號查詢名族名稱        $name = NationName($v[3]);                //替換關鍵字        $newname = str_replace($xxm,"<mark>{$xxm}</mark>",$v[1]);                echo "<td>{$v[0]}</td><td>{$newname}</td><td>{$sex}</td><td>{$name}</td><td>{$v[4]}</td><td><a href=‘shanchu.php?c={$v[0]}‘ onclick=\"return confirm(‘確定刪除嗎？‘)\">刪除</a><a href=‘xiugai.php?c={$v[0]}‘>修改</a></td>";                /*foreach($v as $v1)        {            echo "<td>{$v1}</td>";        }*/                echo "</tr>";    }        //給一個民族代號，返回民族名稱    function NationName($code)    {        //造連線物件        $db = new  MySQLi("localhost","root","123","mydb");        //寫SQL語句        $sql = "select name from nation where code=‘{$code}‘";        //執行SQL語句        $result = $db->query($sql);                $attr = $result->fetch_row();                return $attr[0];    }        ?>        </table><a href="add.php"><input type="button" value="添加資料" /></a></body></html>

 

php->msql 多條件查詢