Home  >  Article  >  Backend Development  >  Example of user query class implemented in php_PHP tutorial

Example of user query class implemented in php_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 09:50:09842browse

Example of user query class implemented by php

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:

 ?

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;

}

}

?>

1

2

3 4

56 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"); //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; } } ?>
I hope this article will be helpful to everyone’s PHP programming design. http://www.bkjia.com/PHPjc/1018373.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1018373.htmlTechArticleExample of user query class implemented by php. This article describes the user query class implemented by php. Share it with everyone for your reference. The specific implementation method is as follows: ? 1 2 3 4 5 6 7 8 9 10 11 12 13 14...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn