PHP SqlHelper::execute_dql2 Examples

execute_dql2() public method

执行dql语句，但是返回的是一个数组

public execute_dql2 ( $sql )

Example #1

File: messageModel.class.php Project: JimChenAnother/notebook

 public function showMessageByPage($fenyePage, $loginname)
 {
     $sql = "select *from message where getter = '" . $loginname . "'" . "limit " . $fenyePage->pageSize * ($fenyePage->page - 1) . "," . $fenyePage->pageSize;
     $sqlHelper = new SqlHelper();
     $res = $sqlHelper->execute_dql2($sql);
     return $res;
 }

Example #2

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

 function getEmpListByPage($pageNow, $pageSize)
 {
     $sql = "select * from emp limit " . ($pageNow - 1) * $pageSize . ",{$pageSize}";
     $sqlHelper = new SqlHelper();
     $res = $sqlHelper->execute_dql2($sql);
     $sqlHelper->close_connect();
     return $res;
 }

Example #3

File: StuService.class.php Project: EricWenyi/Member-Management-System

 public function getStuListByPage($pageNow, $pageSize)
 {
     $sql = "select * from student limit " . ($pageNow - 1) * $pageSize . ",{$pageSize}";
     $sqlHelper = new SqlHelper();
     $res2 = $sqlHelper->execute_dql2($sql);
     //free
     return $res2;
 }

Example #4

File: empService.class.php Project: jimmyZRone/test-ssh-key

 public function updateEmp($id)
 {
     $sql = "select * from emp where id={$id}";
     $sqlHelper = new SqlHelper();
     $arr = $sqlHelper->execute_dql2($sql);
     $sqlHelper->close_connect();
     $emp = new Emp();
     $emp->setId($arr['0']['id']);
     $emp->setName($arr['0']['name']);
     $emp->setGrade($arr['0']['grade']);
     $emp->setEmail($arr['0']['email']);
     //return $arr;
     return $emp;
 }

Example #5

File: MessageService.class.php Project: hnqing/xiahn

 function getMessage($getter, $sender)
 {
     $sql = "select * from mes where getter='{$getter}' and sender='{$sender}' and state=0";
     $mesXML = "<meses>";
     $sqlHelper = new SqlHelper();
     $mesList = $sqlHelper->execute_dql2($sql);
     if (count($mesList) != 0) {
         for ($i = 0; $i < count($mesList); $i++) {
             $row = $mesList[$i];
             $mesXML .= "<id>{$row['id']}</id><sender>{$row['sender']}</sender><getter>{$row['getter']}</getter><con>{$row['content']}</con><sendTime>{$row['sendTime']}</sendTime>";
         }
         $sql = "update mes set state=1 where getter='{$getter}' and sender='{$sender}'";
         $res = $sqlHelper->execute_dml($sql);
     }
     $mesXML .= "</meses>";
     $sqlHelper->close_connect();
     return $mesXML;
 }

Example #6

File: NationService.class.php Project: otkinlife/MyPhalcon

 function QueryAllNation()
 {
     $sql = "select nationId,nationName from t_Nation";
     $sqlHelper = new SqlHelper();
     $res = $sqlHelper->execute_dql2($sql);
     // 关闭连接
     $sqlHelper->close_connect();
     return $res;
 }

Example #7

File: StudentInfoService.class.php Project: otkinlife/MyPhalcon

 function QueryAllStudentInfo()
 {
     $sql = "select zkzh,name from t_StudentInfo";
     $sqlHelper = new SqlHelper();
     $res = $sqlHelper->execute_dql2($sql);
     // 关闭连接
     $sqlHelper->close_connect();
     return $res;
 }

Example #8

File: cometbyiframe.php Project: hnqing/xiahn

<?php

require_once 'SqlHelper.class.php';
$kefu = $_COOKIE["KEFU"];
set_time_limit(0);
$i = 0;
$sqlHelper = new SqlHelper();
while (true) {
    echo $i++ . "</br>";
    $sql = "select * from mes where getter='{$kefu}' and state=0 limit 1";
    $res = $sqlHelper->execute_dql2($sql);
    if (!empty($res)) {
        $sql = "update mes set state=1 where id=" . $res[0]['id'];
        $sqlHelper->execute_dql($sql);
        $msg = json_encode($res[0]);
        echo "<script type='text/javascript'>";
        echo "parent.window.comet({$msg});";
        echo "</script>";
    }
    ob_flush();
    flush();
    sleep(1);
}

Example #9

File: test.php Project: uhgy/phppractice

<?php

	require_once 'SqlHelper.class.php';

	$sqlHelper=new SqlHelper();
	$arr=$sqlHelper->execute_dql2("select * from empmanage limit 20");
	print_r($arr);

?>