PHP SqlHelper::exectue_dql_fenye Examples

exectue_dql_fenye() public method

$sql2="select count(id) from 表名"

public exectue_dql_fenye ( $sql1, $sql2, $fenyePage )

Example #1

File: EmpService.class.php Project: enmeen/git_empManage

 function getFenyePage($fenyePage)
 {
     //创建一个sqlHelper对象实例
     $sqlHelper = new SqlHelper();
     $sql1 = "select * from emp  limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize . "";
     //如何排错
     $sql2 = "select count(id) from emp";
     $sqlHelper->exectue_dql_fenye($sql1, $sql2, $fenyePage);
     $sqlHelper->close_connect();
 }

Example #2

File: EmpService.class.php Project: blackjack0922/empManage

 /**
  * @param $fenyePage
  */
 function getFenyePage($fenyePage)
 {
     $sqlhelper = new SqlHelper();
     $sql1 = "select * from emp limit " . ($fenyePage->pageNow - 1) * $fenyePage->pageSize . "," . $fenyePage->pageSize;
     echo "当前页:" . $fenyePage->pageNow . "<br/>";
     echo $sql1;
     $sql2 = "select count(id) from emp";
     $sqlhelper->exectue_dql_fenye($sql1, $sql2, $fenyePage);
     $sqlhelper->close_conn();
 }