-
Notifications
You must be signed in to change notification settings - Fork 0
/
student.class.php
36 lines (31 loc) · 1.03 KB
/
student.class.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<?php
require_once './conn/SqlHelper.class.php';
class Student{
public function addstudent($sno,$usernc,$truename,$pwd,$email,$tel,$major){
$SqlHelper=new SqlHelper();
$img=rand(1,4).".png";
$sql="insert into student values ('$sno','$usernc','$truename','$pwd','$email','$tel','$major','$img')";
$res=$SqlHelper->dml($sql);
$SqlHelper->close();
return $res;
}
public function checksno($sno){
$sqlHelper=new SqlHelper();
$sql="select count(*) from student where sno=$sno";
$res=$sqlHelper->dql($sql);
$row=$res->fetch_array();
$sqlHelper->close();
if($row[0]==1){
return 0;//检查到数据库已经存在用户
}else{
return 1;//可以注册
}
}
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;
}
}