Example of user query class implemented in php_PHP tutorial-PHP Tutorial-php.cn

Example of user query class implemented in php_PHP tutorial

WBOY

Release： 2016-07-13 09:50:09

Original

848 people have browsed it

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:

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;

}

3 4

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...