资源描述:
《浅谈PHP值mysql操作类_》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、浅谈PHP值mysql操作类_下面我就为大家带来一篇浅谈PHP值mysql操作类。我觉得挺不错的,现在就分享给大家,也给大家做个参考。浅谈PHP值mysql操作类?php/***CreatedbyPhpStorm.*User:Administrator*Date:2021/6/27*Time:18:55*/ClassMysqls{private$table;//表private$opt;publicfunction__construct($host,$user,$pwd,$name,$table_names){$this-db=newmysqli($host,$user,$
2、pwd,$name);//数据库连接if(mysqli_connect_errno()){echo"数据库连接错误".mysqli_connect_errno();exit();}$this-db-query("setnamesutf8");$this-table=$table_names;$this-opt['field']="*";$this-opt['where']=$this-opt['Order']=$this-opt['Limit']=$this-opt['Group']='';//var_dump($this-opt['where']);//$this-M($
3、table_names);}//数据库连接//protectedfunctionM($table_name){//$this-db=newmysqli(DBHOST,DBUSER,DBPWD,DBNAME);////if(mysqli_connect_errno()){//echo"数据库连接错误".mysqli_connect_errno();//exit();//}//$this-db-query("setnamesutf8");//$this-table=$table_name;//}//表中的字段publicfunctiontbField(){$desc=$this
4、-db-query("DESC{$this-table}");$fieldArr=array();while(($row=$desc-fetch_assoc())!=false){$fieldArr[]=$row['Field'];}//var_dump($fieldArr);return$fieldArr;}//查询字段publicfunctionfield($filed){//拆分字段$filedArr=is_string($filed)?explode(",",$filed):$filed;if(is_array($filedArr)){$filed='';forea
5、ch($filedArras$v){$filed.="'".$v."'".",";}}//var_dump($filed);returnrtrim($filed,",");}//推断字段是否存在publicfunctionisfield($fileds){$filedArr=is_string($fileds)?explode(",",$fileds):$fileds;$tbFiled=$this-tbField();//var_dump($tbFiled);foreach($filedArras$v){if(!in_array($v,$tbFiled)){echo"字段输
6、入发错";}}}//条件语句publicfunctionwhere($where){$this-opt['where']=is_string($where)?"WHERE{$where}":"不是字符串";return$this;}//LimitpublicfunctionLimit($limit){$this-opt['Limit']=is_string($limit)?"Limit{$limit}":"不是字符串";return$this;}publicfunctionOrder($order){$this-opt['Order']=is_string($order)?
7、"OrderBy{$order}":"不是字符串";return$this;}publicfunctionGroup($group){$this-opt['Group']=is_string($group)?"GroupBY{$group}":"不是字符串";return$this;}//查询字符串publicfunctionselect(){$sql="select*from{$this-table}{$this-opt['where']}{$this-opt['Group']}{$this-opt['Limit