PHP DBUtils::query Examples

Example #1

File: mod_teacher.php Project: zcmyworld/nothing

 public static function getList($teacherId)
 {
     $pdo = new DBUtils();
     $sql = "select * from teacherDes where teacherId = '{$teacherId}'";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #2

File: mod_article.php Project: zcmyworld/nothing

 public static function getList($snavId)
 {
     $pdo = new DBUtils();
     $sql = "select * from article where snavId = {$snavId}";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #3

File: mod_buy.php Project: zcmyworld/nothing

 public static function getBuyList()
 {
     $pdo = new DBUtils();
     $sql = "select * from buy";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #4

File: mod_index.php Project: zcmyworld/nothing

 public static function getIndex()
 {
     $pdo = new DBUtils();
     $sql = "select * from homepage";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #5

File: index.php Project: zcmyworld/nothing

function getNav()
{
    $pdo = new DBUtils();
    $sql = "select * from nav";
    $nav = $pdo->query($sql);
    $header = array();
    foreach ($nav as $key => $val) {
        $header[$val['navId']] = array("navName" => $val['navName'], "navId" => $val['navId'], "second" => array());
    }
    $sql = "select * from second_nav";
    $second = $pdo->query($sql);
    foreach ($second as $key => $val) {
        $header[$val['navId']]['second'][$val['snavId']] = array("snavName" => $val['snavName'], "snavId" => $val['snavId'], "link" => $val['snavName']);
    }
    return $header;
}

Example #6

File: mod_advice.php Project: zcmyworld/nothing

 public static function getAdviceList()
 {
     $pdo = new DBUtils();
     $sql = "select * from advice";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #7

File: mod_joinus.php Project: zcmyworld/nothing

 public static function getJoinusList()
 {
     $pdo = new DBUtils();
     $sql = "select * from joinus";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #8

File: mod_thanks.php Project: zcmyworld/nothing

 public static function getStudentReportList($type)
 {
     $pdo = new DBUtils();
     $sql = "select * from student_report where type = '{$type}'";
     $rs = $pdo->query($sql);
     return $rs;
 }

Example #9

File: mod_course.php Project: zcmyworld/nothing

 public static function getOne($courseId)
 {
     $pdo = new DBUtils();
     $sql = "select * from course where courseId = {$courseId}";
     $course = $pdo->getOne($sql);
     $sql = "select * from courseType where courseId = {$courseId}";
     $courseType = $pdo->query($sql);
     return array("course" => $course, "courseType" => $courseType);
 }

Example #10

File: queryArticles.php Project: overkazaf/ncg

<?php

header("Content-Type:text/html;charset=utf-8");
include_once "config/dbconfig.php";
include_once "utils/dbutils.php";
$mysql = new DBUtils();
$sql = "SELECT * from articles";
$mysql->query($sql);
$qInfo = array();
if ($mysql->getResultSize() == 0) {
    $qInfo['isSuccess'] = false;
} else {
    $qInfo['isSuccess'] = true;
    $qInfo['responseText'] = $mysql->getResultSet();
}
echo json_encode($qInfo);