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; }
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; }
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 ""; }
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 ""; }
<?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; }