Example of user query class implemented in php_PHP tutorial

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

37

38

39

40

41

42

43

44

45

class user

{

var $usertable;

function get_oneuser($field,$value)

{

$field_array=array("id","name"); //查询方式

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 "查询方式不对";

}

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;

}

}

?>