PHP SqlHelper::res_array Examples

Example #1

File: student.class.php Project: justfu/Microclass1.0

 public function get_user_info($sno)
 {
     $sqlHelper = new SqlHelper();
     $sql = "select sno,usernc,truename,email,tel,major,img from student where sno='{$sno}'";
     $res = $sqlHelper->res_array($sql);
     $sqlHelper->close();
     return $res;
 }

Example #2

File: bbs.class.php Project: justfu/Microclass1.0

 public function get_counts()
 {
     $sqlHelper = new SqlHelper();
     $sql = "select count(*) from bbs";
     $res = $sqlHelper->res_array($sql);
     $rowcounts = $res[0];
     //获得总行数
     $pagecount = ceil($rowcounts / 6);
     //获得总页面数
     return $pagecount;
 }

Example #3

File: AdminSevice.class.php Project: justfu/Microclass1.0

 public function CheckAdmin($id, $password)
 {
     $sqlHelper = new SqlHelper();
     $sql = "select password,name from admin where id={$id}";
     $res = $sqlHelper->res_array($sql);
     if (md5($password) == $res[0]) {
         return $res[1];
         exit;
     }
     $sqlHelper->close();
     return "";
 }

Example #4

File: studentService.class.php Project: justfu/Microclass1.0

 public function checkStudent($sno, $pwd)
 {
     $arr_sno = array();
     $sqlHelper = new SqlHelper();
     $sql = "select usernc,pwd,sno from student where sno='{$sno}'";
     $arr = $sqlHelper->res_array($sql);
     if ($arr[1] == md5($pwd)) {
         $arr_sno[0] = $arr[0];
         $arr_sno[1] = $arr[2];
         return $arr_sno;
         //返回用户名
         exit;
     }
     $sqlHelper->close();
     return "";
 }

Example #5

File: test.php Project: justfu/Microclass1.0

<?php

/**
 * Created by PhpStorm.
 * User: хоП
 * Date: 2015/11/29
 * Time: 10:24
 */
require_once 'SqlHelper.class.php';
$sqlHelper = new SqlHelper();
$sql = "select * from student";
$res = $sqlHelper->res_array($sql);
foreach ($res as $key => $value) {
    echo $key . "--" . $value;
}