Home > Article > Backend Development > Example of user query class implemented in php_PHP tutorial
This article describes the example of user query class implemented by php. Share it with everyone for your reference. The specific implementation method is as follows:
?
2 3 4 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
37
38
39
40
41
42
43
44
45
|
<🎜>class user<🎜> <🎜>{<🎜> <🎜>var $usertable;<🎜> <🎜>function get_oneuser($field,$value)<🎜> <🎜>{<🎜> <🎜>$field_array=array("id","name"); //Query method<🎜> <🎜>if(in_array($field,$field_array))<🎜> <🎜>{<🎜> <🎜>$sql="SELECT * FROM `$this->usertable` WHERE $field='$value'"; $db=new database; $res=$db->execute($sql); $obj_user=mysql_fetch_object($res); return $obj_user; } else echo "The query method is wrong"; } function get_moreusers() { global $db; $argnums=func_num_args(); $argarr=func_get_args(); switch($argnums) { case 0: $sql="SELECT * FROM `$this->usertable`"; break; case 2: $sql="SELECT * FROM `$this->usertable` WHERE $argarr[0]='$argarr[1]'"; break; case 4: $sql="SELECT * FROM `$this->usertable` WHERE $argarr[0]='$argarr[1]' AND $argarr[2]='$argarr[3]'"; break; } //$db=new database; $res=$this->execute($sql); $obj_arr=array(); while($obj=mysql_fetch_object($res)) { $obj_arr[]=$obj; } return $obj_arr; } } ?> |