本文整理汇总了PHP中SqlHelper::execute_dql_fenye方法的典型用法代码示例。如果您正苦于以下问题:PHP SqlHelper::execute_dql_fenye方法的具体用法?PHP SqlHelper::execute_dql_fenye怎么用?PHP SqlHelper::execute_dql_fenye使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlHelper
的用法示例。
在下文中一共展示了SqlHelper::execute_dql_fenye方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getFenyePage
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();
}
示例2: getFenyePage
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();
}
示例3: getFenyePage
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();
}