当前位置: 首页>>代码示例>>PHP>>正文


PHP SqlHelper::execute_dql_fenye方法代码示例

本文整理汇总了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();
		}
开发者ID:uhgy,项目名称:phppractice,代码行数:8,代码来源:EmpService.class.php

示例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();
 }
开发者ID:otkinlife,项目名称:MyPhalcon,代码行数:14,代码来源:NationService.class.php

示例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();
 }
开发者ID:otkinlife,项目名称:MyPhalcon,代码行数:44,代码来源:StudentInfoService.class.php


注:本文中的SqlHelper::execute_dql_fenye方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。