欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

数据库操作的model类,用到了__call方法

程序员文章站 2022-03-13 21:09:37
...
跳至 [1] [2] [全屏预览]
	/*
		作者 : shyhero
		邮箱 : shyhero@outlook.com
		Q  Q : 1757424878
	 */
	define("HOSTNAME","127.0.0.1");
	define("USERNAME","root");
	define("PASSWORD","");
	define("DATANAME","class");

	class Model{
		private $link;
		private $tableName;
		private $zd;
		private $method = array(
			"where" => "",
			"order" => "",
			"limit" => "",
			"group" => "",
			"having" => ""
			);
		public function __construct($tableName){
			$this -> tableName = $tableName;
			try{
				$this -> link = mysqli_connect(HOSTNAME,USERNAME,PASSWORD,DATANAME);
				mysqli_set_charset($this -> link,"UTF8");
			}catch(Exception $e){
				echo "数据库连接失败";
			}
			$this -> desc();
		}
		public function __destruct(){
			mysqli_close($this -> link);
		}
		public function desc(){
			$sql = " desc {$this -> tableName}; ";
			$res = mysqli_query($this -> link,$sql);
			$arr = mysqli_fetch_all($res,MYSQLI_ASSOC);
			for($i = 0 ;$i  zd = $brr;
			return $brr;
		}
		public function __call($name,$value){
			$name = strtolower($name);
			if(array_key_exists($name,$this -> method)){
				if($name == 'order'){
					$this -> method['order']  = " order by ".$value[0];
				}elseif($name == 'group'){
				$this -> method['group']  = " group by ".$value[0];
				}else{
					$this -> method[$name]  = " {$name} ".$value[0];
				}
			}else{
				return "the method is not found!";
			}
			return $this;
		}
		public function method(){
			return " {$this -> method['where']} {$this -> method['order']} {$this -> method['limit']} {$this -> method['group']} {$this -> method['having']}; ";
		}
		public function find($a="*"){
			if(in_array("{$a}",$this -> zd) || $a == "*"){
				$sql = "select {$a} from {$this -> tableName} {$this -> method()} ";
			}else{
				$sql = "select * from {$this -> tableName}";
			}
			//return $sql;
			$res = mysqli_query($this -> link,$sql);
			$arr = mysqli_fetch_all($res,MYSQLI_ASSOC);
			return $arr;
		}
	}