第九节 - 部门管理模块（模糊查询）

<div id="toolbar" style="padding:10px 12px;">

    请输入部门名称：<input type="text" name="deptname" id="deptname" />

</div>

<button id="submit" style="float:right;">查询</button>

$deptname = "";


    if(isset($_POST['deptname']) && $_POST['deptname'] != null){
        $deptname = $_POST['deptname'];

    }

    $resultset = mysql_query("select * from tm_dept where 1=1 and deptname like '%$deptname%' limit $start,$rows") or die(mysql_error());

$resultset = mysql_query("select count(*) as total from tm_dept where 1=1  and deptname like '%$deptname%'") or die(mysql_error());