Example of user query class implemented in php

The example in this article describes the user query class implemented in PHP. Share it with everyone for your reference. The specific implementation method is as follows:

<?php
 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=&#39;$value&#39;";
    $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]=&#39;$argarr[1]&#39;";
     break;
    case 4:
     $sql="SELECT * FROM `$this->usertable` WHERE $argarr[0]=&#39;$argarr[1]&#39; AND $argarr[2]=&#39;$argarr[3]&#39;";
     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.

For more articles related to user query class examples implemented in PHP, please pay attention to the PHP Chinese website!