分类导航
PHPJavaPythonC#C&C++RubyVBasp.NetGoPerlDjangoDelphiJspSpringLuaLaravelMybatisAspGroovyThinkPHP

PHP以mysqli方式连接类完整代码实例

PHP   发布时间：2022-04-09  发布网站：大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了PHP以mysqli方式连接类完整代码实例，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

本文所述的是一个在PHP中以MysqLi方式连接数据库的一个数据库类实例，该数据库类是从一个PHP的CMS中整理出来的，可实现PHP连接数据库类，MysqLi版，兼容PHP4，对于有针对性需要的朋友可根据此代码进行优化和修改。

PHP;">
host = $config['host'] ? $config['host'] : 'localhost';
 $this->port = $config['port'] ? $config['port'] : '3306';
 $this->user = $config['user'] ? $config['user'] : 'root';
 $this->pass = $config['pass'] ? $config['pass'] : '';
 $this->data = $config['data'] ? $config['data'] : '';
 $this->debug = $config["debug"] ? $config["debug"] : false;
 $this->prefix = $config['prefix'] ? $config['prefix'] : 'qinggan_';
 if($this->data)
 {
  $ifconnect = $this->connect($this->data);
  if(!$ifconnect)
  {
  $this->conn = false;
  return false;
  }
 }
 return true;
 }
 #[兼容PHP4]
 function db_MysqLi($config=array())
 {
 return $this->__construct($config);
 }
 #[连接数据库]
 function connect($database="")
 {
 $start_time = $this->time_used();
 if(!$this->port) $this->port = "3306";
 $this->conn = @MysqLi_connect($this->host,$this->user,$this->pass,"",$this->port) or false;
 if(!$this->conn)
 {
  return false;
 }
 $version = $this->get_version();
 if($version>"4.1")
 {
  MysqLi_query($this->conn,"SET NAMES 'utf8'");
  if($version>"5.0.1")
  {
  MysqLi_query($this->conn,"SET @R_419_1191@=''");
  }
 }
 $end_time = $this->time_used();
 $this->conn_times += round($end_time - $start_time,5);#[连接数据库的时间]
 $ifok = $this->SELEct_db($databasE);
 return $ifok ? true : false;
 }
 function SELEct_db($data="")
 {
 $database = $data ? $data : $this->data;
 if(!$databasE)
 {
  return false;
 }
 $this->data = $database;
 $start_time = $this->time_used();
 $ifok = MysqLi_SELEct_db($this->conn,$databasE);
 if(!$ifok)
 {
  return false;
 }
 $end_time = $this->time_used();
 $this->conn_times += round($end_time - $start_time,5);#[连接数据库的时间]
 return true;
 }
 #[关闭数据库连接，当您使用持续连接时该功能失效]
 function close()
 {
 if(is_resource($this->conn))
 {
  return MysqLi_close($this->conn);
 }
 else
 {
  return true;
 }
 }
 function __destruct()
 {
 return $this->close();
 }
 function set($name,$value)
 {
 if($name == "rs_type")
 {
  $value = strtolower($value) == "num" ? MysqLI_NUM : MysqLI_ASSOc;
 }
 $this->$name = $value;
 }
 function query($sql)
 {
 if(!is_resource($this->conn))
 {
  $this->connect();
 }
 else
 {
  if(!MysqL_ping($this->conn))
  {
   $this->close();
   $this->connect();
  }
 }
 if($this->debug)
 {
  $sqlkey = md5($sql);
  if($this->querylist)
  {
  $qlist = array_keys($this->querylist);
  if(in_array($sqlkey,$qlist))
  {
   $count = $this->querylist[$sqlkey]["count"] + 1;
   $this->querylist[$sqlkey] = array("sql"=>$sql,"count"=>$count);
  }else{
   $this->querylist[$sqlkey] = array("sql"=>$sql,"count"=>1);
  }
  }
  else{
  $this->querylist[$sqlkey] = array("sql"=>$sql,"count"=>1);
  }
 }
 $start_time = $this->time_used();
 $func = $this->unbuffered && function_exists("MysqLi_multi_query") ? "MysqLi_multi_query" : "MysqLi_query";
 $this->result = @$func($this->conn,$sql);
 $this->query_count++;
 $end_time = $this->time_used();
 $this->query_times += round($end_time - $start_time,5);#[查询时间]
 if(!$this->result)
 {
  return false;
 }
 return $this->result;
 }
 function get_all($sql="",$priMary="")
 {
 $result = $sql ? $this->query($sql) : $this->result;
 if(!$result)
 {
  return false;
 }
 $start_time = $this->time_used();
 $rs = array();
 $is_rs = false;
 while($rows = MysqLi_fetch_array($result,$this->rs_typE))
 {
  if($priMary && $rows[$priMary])
  {
  $rs[$rows[$priMary]] = $rows;
  }
  else
  {
  $rs[] = $rows;
  }
  $is_rs = true;
 }
 $end_time = $this->time_used();
 $this->query_times += round($end_time - $start_time,5);#[查询时间]
 return ($is_rs ? $rs : falsE);
 }
 function get_one($sql="")
 {
 $start_time = $this->time_used();
 $result = $sql ? $this->query($sql) : $this->result;
 if(!$result)
 {
  return false;
 }
 $rows = MysqLi_fetch_array($result,$this->rs_typE);
 $end_time = $this->time_used();
 $this->query_times += round($end_time - $start_time,5);#[查询时间]
 return $rows;
 }
 function insert_id($sql="")
 {
 if($sql)
 {
  $rs = $this->get_one($sql);
  return $rs;
 }
 else
 {
  return MysqLi_insert_id($this->conn);
 }
 }
 function insert($sql)
 {
 $this->result = $this->query($sql);
 $id = $this->insert_id();
 return $id;
 }
 function all_array($table,$condition="",$orderby="")
 {
 if(!$tablE)
 {
  return false;
 }
 $table = $this->prefix.$table;
 $sql = "SELECT * FROM ".$table;
 if($condition && is_array($condition) && count($condition)>0)
 {
  $sql_fields = array();
  foreach($condition AS $key=>$value)
  {
  $sql_fields[] = "`".$key."`='".$value."' ";
  }
  $sql .= " WHERE ".implode(" AND ",$sql_fields);
 }
 if($orderby)
 {
  $sql .= " ORDER BY ".$orderby;
 }
 $rslist = $this->get_all($sql);
 return $rslist;
 }
 function one_array($table,$condition="")
 {
 if(!$tablE)
 {
  return false;
 }
 $table = $this->prefix.$table;
 $sql = "SELECT * FROM ".$table;
 if($condition && is_array($condition) && count($condition)>0)
 {
  $sql_fields = array();
  foreach($condition AS $key=>$value)
  {
  $sql_fields[] = "`".$key."`='".$value."' ";
  }
  $sql .= " WHERE ".implode(" AND ",$sql_fields);
 }
 $rslist = $this->get_one($sql);
 return $rslist;
 }
 //将数组写入数据中
 function insert_array($data,$table,$insert_type="insert")
 {
 if(!$table || !is_array($data) || !$data)
 {
  return false;
 }
 $table = $this->prefix.$table;//自动增加表前缀
 if($insert_type == "insert")
 {
  $sql = "INSERT INTO ".$table;
 }
 else
 {
  $sql = "replaCE intO ".$table;
 }
 $sql_fields = array();
 $sql_val = array();
 foreach($data AS $key=>$value)
 {
  $sql_fields[] = "`".$key."`";
  $sql_val[] = "'".$value."'";
 }
 $sql.= "(".(implode(",",$sql_fields)).") VALUES(".(implode(",$sql_val)).")";
 return $this->insert($sql);
 }
 //更新数据
 function update_array($data,$condition)
 {
 if(!$data || !$table || !$condition || !is_array($data) || !is_array($condition))
 {
  return false;
 }
 $table = $this->prefix.$table;//自动增加表前缀
 $sql = "updatE ".$table." SET ";
 $sql_fields = array();
 foreach($data AS $key=>$value)
 {
  $sql_fields[] = "`".$key."`='".$value."'";
 }
 $sql.= implode(",$sql_fields);
 $sql_fields = array();
 foreach($condition AS $key=>$value)
 {
  $sql_fields[] = "`".$key."`='".$value."' ";
 }
 $sql .= " WHERE ".implode(" AND ",$sql_fields);
 return $this->query($sql);
 }
 function count($sql="")
 {
 if($sql)
 {
  $this->rs_type = MysqLI_NUM;
  $this->query($sql);
  $rs = $this->get_one();
  $this->rs_type = MysqLI_ASSOc;
  return $rs[0];
 }
 else
 {
  return MysqLi_num_rows($this->result);
 }
 }
 function num_fields($sql="")
 {
 if($sql)
 {
  $this->query($sql);
 }
 return MysqLi_num_fields($this->result);
 }
 function list_fields($tablE)
 {
 $rs = $this->get_all("SHOW columNS FROM ".$tablE);
 if(!$rs)
 {
  return false;
 }
 foreach($rs AS $key=>$value)
 {
  $rslist[] = $value["Field"];
 }
 return $rslist;
 }
 #[显示表名]
 function list_tables()
 {
 $rs = $this->get_all("SHOW TABLES");
 return $rs;
 }
 function table_name($table_list,$i)
 {
 return $table_list[$i];
 }
 function escape_String($char)
 {
 if(!$char)
 {
  return false;
 }
 return MysqLi_escape_String($this->conn,$char);
 }
 function get_version()
 {
 return MysqLi_get_server_info($this->conn);
 }
 function time_used()
 {
 $time = explode(" ",microtime());
 $used_time = $time[0] + $time[1];
 return $used_time;
 }
 //MysqL的查询时间
 function conn_times()
 {
 return $this->conn_times + $this->query_times;
 }
 //MySQL查询资料
 function conn_count()
 {
 return $this->query_count;
 }
 # 高效sql生成查询，仅适合单表查询
 function PHPok_one($tbl,$fields="*")
 {
 $sql = "SELECT ".$fields." FROM ".$this->db->prefix.$tbl;
 if($condition)
 {
  $sql .= " WHERE ".$condition;
 }
 return $this->get_one($sql);
 }
 function debug()
 {
 if(!$this->querylist || !is_array($this->querylist) || count($this->querylist) < 1)="" {="" return="" false;="" }="" $html='LPADding="0" cellspacing="0" width="100%" bgcolor="#CECECE">l.='
LPADding="1" cellspacing="1" width="100%">' ;="" $html.='sqlquerylist AS $key=>$value){
  $html .= '<>
sql'].'
大佬总结
以上是大佬教程为你收集整理的PHP以mysqli方式连接类完整代码实例全部内容，希望文章能够帮你解决PHP以mysqli方式连接类完整代码实例所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。
标签：mysqli连接

		 
	

       
	

		
猜你在找的PHP相关文章

		 
	

			
其他相关热搜词更多

			
phpJavaPython程序员load中如何string使用参数jquery开发安装listlinuxiosandroid工具javascriptcap

    
   
		
		

			

			
			
			
		


		
		
		 
		  

	
查询