function getFenyePage($fenyePage){ $sqlHelper=new SqlHelper(); $sql1="select * from empmanage limit " .($fenyePage->pageNow-1)*$fenyePage->pageSize.",".$fenyePage->pageSize; $sql2="select count(id) from empmanage"; $sqlHelper->execute_dql_fenye($sql1,$sql2,$fenyePage); $sqlHelper->close_connect(); }
function getFenyePage($fenyePage) { // 创建一个SqlHelper对象实例 $sqlHelper = new SqlHelper(); //根据查询条件构造sql语句 $sql1 = "select * from t_Nation where 1=1"; $sql2 = "select count(nationId) from t_Nation where 1=1"; $condition = ""; $sql1 = $sql1 . $condition . " limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize; $sql2 = $sql2 . $condition; //调用数据层执行查询操作 $sqlHelper->execute_dql_fenye($sql1, $sql2, $fenyePage); $sqlHelper->close_connect(); }
function getFenyePage($fenyePage, $zkzh, $name, $kslb, $nation, $byxx, $hkszd, $address, $telephone, $cardNumber, $xjh) { // 创建一个SqlHelper对象实例 $sqlHelper = new SqlHelper(); //根据查询条件构造sql语句 $sql1 = "select * from t_StudentInfo where 1=1"; $sql2 = "select count(zkzh) from t_StudentInfo where 1=1"; $condition = ""; if ($zkzh != "") { $condition = $condition . " and zkzh like '%{$zkzh}%'"; } if ($name != "") { $condition = $condition . " and name like '%{$name}%'"; } if ($kslb != "") { $condition = $condition . " and kslb like '%{$kslb}%'"; } if ($nation != "") { $condition = $condition . " and nation={$nation}"; } if ($byxx != "") { $condition = $condition . " and byxx like '%{$byxx}%'"; } if ($hkszd != "") { $condition = $condition . " and hkszd like '%{$hkszd}%'"; } if ($address != "") { $condition = $condition . " and address like '%{$address}%'"; } if ($telephone != "") { $condition = $condition . " and telephone like '%{$telephone}%'"; } if ($cardNumber != "") { $condition = $condition . " and cardNumber like '%{$cardNumber}%'"; } if ($xjh != "") { $condition = $condition . " and xjh like '%{$xjh}%'"; } $sql1 = $sql1 . $condition . " limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize; $sql2 = $sql2 . $condition; //调用数据层执行查询操作 $sqlHelper->execute_dql_fenye($sql1, $sql2, $fenyePage); $sqlHelper->close_connect(); }