php7\u53d6\u6d88\u4e86mysql\u8fde\u63a5\u65b9\u5f0f\uff0c\u91c7\u7528mysqli\u8fde\u63a5\u3002<\/p>\n
mysql_query \u6539\u7528 mysqli_query
\nmysql_num_rows \u6539\u7528 mysqli_num_rows
\nmysql_fetch_array \u6539\u7528 mysqli_fetch_array<\/p>\n
php\u9875\u9762\u6587\u4ef6\u4e2d\u8c03\u7528\u4e3e\u4f8b\uff1a<\/p>\n
$sql=\"insert into **\";
\nmysqli_query($db->conn,$sql);<\/p><\/blockquote>\nglobal.php\u5168\u5c40\u914d\u7f6e\u5185\u5bb9\uff1a<\/p>\n
$config=array();
\n$config['host']=\"localhost\"; \/\/mysql\u670d\u52a1\u5668\u5730\u5740
\n$config['user']=\"root\"; \/\/mysql\u7528\u6237\u540d
\n$config['pass']=\"\"; \/\/mysql\u5bc6\u7801
\n$config['data']=\"test\"; \/\/\u6570\u636e\u5e93\u540d\u79f0
\n$config['port']=\"3306\";
\n$config['debug']=\"\";
\n$config['prefix']=\"\";
\n$db = new db_mysqli($config);<\/p><\/blockquote>\nmysqli.class.php\u5185\u5bb9\uff1a<\/p>\n
#[\u7c7b\u5e93sql]
\nclass db_mysqli
\n{
\nvar $query_count = 0;
\nvar $host;
\nvar $user;
\nvar $pass;
\nvar $data;
\nvar $conn;
\nvar $result;
\nvar $prefix = \"\";
\n\/\/\u8fd4\u56de\u7ed3\u679c\u96c6\u7c7b\u578b\uff0c\u9ed8\u8ba4\u662f\u6570\u5b57+\u5b57\u7b26
\nvar $rs_type = MYSQLI_ASSOC;
\nvar $query_times = 0;#[\u67e5\u8be2\u65f6\u95f4]
\nvar $conn_times = 0;#[\u8fde\u63a5\u6570\u636e\u5e93\u65f6\u95f4]
\nvar $unbuffered = false;
\n\/\/\u5b9a\u4e49\u67e5\u8be2\u5217\u8868
\nvar $querylist;
\nvar $debug = false;
\n#[\u6784\u9020\u51fd\u6570]
\nfunction __construct($config=array())
\n{
\n$this->host = $config['host'] ? $config['host'] : 'localhost';
\n$this->port = $config['port'] ? $config['port'] : '3306';
\n$this->user = $config['user'] ? $config['user'] : 'root';
\n$this->pass = $config['pass'] ? $config['pass'] : '';
\n$this->data = $config['data'] ? $config['data'] : '';
\n$this->debug = $config[\"debug\"] ? $config[\"debug\"] : false;
\n$this->prefix = $config['prefix'] ? $config['prefix'] : '';
\nif($this->data)
\n{
\n$ifconnect = $this->connect($this->data);
\nif(!$ifconnect)
\n{
\n$this->conn = false;
\nreturn false;
\n}
\n}
\nreturn true;
\n}
\n#[\u517c\u5bb9PHP4]
\nfunction db_mysqli($config=array())
\n{
\nreturn $this->__construct($config);
\n}
\n#[\u8fde\u63a5\u6570\u636e\u5e93]
\nfunction connect($database=\"\")
\n{
\n$start_time = $this->time_used();
\nif(!$this->port) $this->port = \"3306\";
\n$this->conn = @mysqli_connect($this->host,$this->user,$this->pass,\"\",$this->port) or false;
\nif(!$this->conn)
\n{
\nreturn false;
\n}
\n$version = $this->get_version();
\nif($version>\"4.1\")
\n{
\nmysqli_query($this->conn,\"SET NAMES 'gb2312'\");
\nif($version>\"5.0.1\")
\n{
\nmysqli_query($this->conn,\"SET sql_mode='gb2312'\");
\n}
\n}
\n$end_time = $this->time_used();
\n$this->conn_times += round($end_time - $start_time,5);#[\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65f6\u95f4]
\n$ifok = $this->select_db($database);
\nreturn $ifok ? true : false;
\n}
\nfunction select_db($data=\"\")
\n{
\n$database = $data ? $data : $this->data;
\nif(!$database)
\n{
\nreturn false;
\n}
\n$this->data = $database;
\n$start_time = $this->time_used();
\n$ifok = mysqli_select_db($this->conn,$database);
\nif(!$ifok)
\n{
\nreturn false;
\n}
\n$end_time = $this->time_used();
\n$this->conn_times += round($end_time - $start_time,5);#[\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65f6\u95f4]
\nreturn true;
\n}
\n#[\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\uff0c\u5f53\u60a8\u4f7f\u7528\u6301\u7eed\u8fde\u63a5\u65f6\u8be5\u529f\u80fd\u5931\u6548]
\nfunction close()
\n{
\nif(is_resource($this->conn))
\n{
\nreturn mysqli_close($this->conn);
\n}
\nelse
\n{
\nreturn true;
\n}
\n}
\nfunction __destruct()
\n{
\nreturn $this->close();
\n}
\nfunction set($name,$value)
\n{
\nif($name == \"rs_type\")
\n{
\n$value = strtolower($value) == \"num\" ? MYSQLI_NUM : MYSQLI_ASSOC;
\n}
\n$this->$name = $value;
\n}
\nfunction query($sql)
\n{
\nif(!is_resource($this->conn))
\n{
\n$this->connect();
\n}
\nelse
\n{
\nif(!mysql_ping($this->conn))
\n{
\n$this->close();
\n$this->connect();
\n}
\n}
\nif($this->debug)
\n{
\n$sqlkey = md5($sql);
\nif($this->querylist)
\n{
\n$qlist = array_keys($this->querylist);
\nif(in_array($sqlkey,$qlist))
\n{
\n$count = $this->querylist[$sqlkey][\"count\"] + 1;
\n$this->querylist[$sqlkey] = array(\"sql\"=>$sql,\"count\"=>$count);
\n}else{
\n$this->querylist[$sqlkey] = array(\"sql\"=>$sql,\"count\"=>1);
\n}
\n}
\nelse{
\n$this->querylist[$sqlkey] = array(\"sql\"=>$sql,\"count\"=>1);
\n}
\n}
\n$start_time = $this->time_used();
\n$func = $this->unbuffered && function_exists(\"mysqli_multi_query\") ? \"mysqli_multi_query\" : \"mysqli_query\";
\n$this->result = @$func($this->conn,$sql);
\n$this->query_count++;
\n$end_time = $this->time_used();
\n$this->query_times += round($end_time - $start_time,5);#[\u67e5\u8be2\u65f6\u95f4]
\nif(!$this->result)
\n{
\nreturn false;
\n}
\nreturn $this->result;
\n}
\nfunction get_all($sql=\"\",$primary=\"\")
\n{
\n$result = $sql ? $this->query($sql) : $this->result;
\nif(!$result)
\n{
\nreturn false;
\n}
\n$start_time = $this->time_used();
\n$rs = array();
\n$is_rs = false;
\nwhile($rows = mysqli_fetch_array($result,$this->rs_type))
\n{
\nif($primary && $rows[$primary])
\n{
\n$rs[$rows[$primary]] = $rows;
\n}
\nelse
\n{
\n$rs[] = $rows;
\n}
\n$is_rs = true;
\n}
\n$end_time = $this->time_used();
\n$this->query_times += round($end_time - $start_time,5);#[\u67e5\u8be2\u65f6\u95f4]
\nreturn ($is_rs ? $rs : false);
\n}
\nfunction get_one($sql=\"\")
\n{
\n$start_time = $this->time_used();
\n$result = $sql ? $this->query($sql) : $this->result;
\nif(!$result)
\n{
\nreturn false;
\n}
\n$rows = mysqli_fetch_array($result,$this->rs_type);
\n$end_time = $this->time_used();
\n$this->query_times += round($end_time - $start_time,5);#[\u67e5\u8be2\u65f6\u95f4]
\nreturn $rows;
\n}
\nfunction insert_id($sql=\"\")
\n{
\nif($sql)
\n{
\n$rs = $this->get_one($sql);
\nreturn $rs;
\n}
\nelse
\n{
\nreturn mysqli_insert_id($this->conn);
\n}
\n}
\nfunction insert($sql)
\n{
\n$this->result = $this->query($sql);
\n$id = $this->insert_id();
\nreturn $id;
\n}
\nfunction all_array($table,$condition=\"\",$orderby=\"\")
\n{
\nif(!$table)
\n{
\nreturn false;
\n}
\n$table = $this->prefix.$table;
\n$sql = \"SELECT * FROM \".$table;
\nif($condition && is_array($condition) && count($condition)>0)
\n{
\n$sql_fields = array();
\nforeach($condition AS $key=>$value)
\n{
\n$sql_fields[] = \"`\".$key.\"`='\".$value.\"' \";
\n}
\n$sql .= \" WHERE \".implode(\" AND \",$sql_fields);
\n}
\nif($orderby)
\n{
\n$sql .= \" ORDER BY \".$orderby;
\n}
\n$rslist = $this->get_all($sql);
\nreturn $rslist;
\n}
\nfunction one_array($table,$condition=\"\")
\n{
\nif(!$table)
\n{
\nreturn false;
\n}
\n$table = $this->prefix.$table;
\n$sql = \"SELECT * FROM \".$table;
\nif($condition && is_array($condition) && count($condition)>0)
\n{
\n$sql_fields = array();
\nforeach($condition AS $key=>$value)
\n{
\n$sql_fields[] = \"`\".$key.\"`='\".$value.\"' \";
\n}
\n$sql .= \" WHERE \".implode(\" AND \",$sql_fields);
\n}
\n$rslist = $this->get_one($sql);
\nreturn $rslist;
\n}
\n\/\/\u5c06\u6570\u7ec4\u5199\u5165\u6570\u636e\u4e2d
\nfunction insert_array($data,$table,$insert_type=\"insert\")
\n{
\nif(!$table || !is_array($data) || !$data)
\n{
\nreturn false;
\n}
\n$table = $this->prefix.$table;\/\/\u81ea\u52a8\u589e\u52a0\u8868\u524d\u7f00
\nif($insert_type == \"insert\")
\n{
\n$sql = \"INSERT INTO \".$table;
\n}
\nelse
\n{
\n$sql = \"REPLACE INTO \".$table;
\n}
\n$sql_fields = array();
\n$sql_val = array();
\nforeach($data AS $key=>$value)
\n{
\n$sql_fields[] = \"`\".$key.\"`\";
\n$sql_val[] = \"'\".$value.\"'\";
\n}
\n$sql.= \"(\".(implode(\",\",$sql_fields)).\") VALUES(\".(implode(\",\",$sql_val)).\")\";
\nreturn $this->insert($sql);
\n}
\n\/\/\u66f4\u65b0\u6570\u636e
\nfunction update_array($data,$table,$condition)
\n{
\nif(!$data || !$table || !$condition || !is_array($data) || !is_array($condition))
\n{
\nreturn false;
\n}
\n$table = $this->prefix.$table;\/\/\u81ea\u52a8\u589e\u52a0\u8868\u524d\u7f00
\n$sql = \"UPDATE \".$table.\" SET \";
\n$sql_fields = array();
\nforeach($data AS $key=>$value)
\n{
\n$sql_fields[] = \"`\".$key.\"`='\".$value.\"'\";
\n}
\n$sql.= implode(\",\",$sql_fields);
\n$sql_fields = array();
\nforeach($condition AS $key=>$value)
\n{
\n$sql_fields[] = \"`\".$key.\"`='\".$value.\"' \";
\n}
\n$sql .= \" WHERE \".implode(\" AND \",$sql_fields);
\nreturn $this->query($sql);
\n}
\nfunction count($sql=\"\")
\n{
\nif($sql)
\n{
\n$this->rs_type = MYSQLI_NUM;
\n$this->query($sql);
\n$rs = $this->get_one();
\n$this->rs_type = MYSQLI_ASSOC;
\nreturn $rs[0];
\n}
\nelse
\n{
\nreturn mysqli_num_rows($this->result);
\n}
\n}
\nfunction num_fields($sql=\"\")
\n{
\nif($sql)
\n{
\n$this->query($sql);
\n}
\nreturn mysqli_num_fields($this->result);
\n}
\nfunction list_fields($table)
\n{
\n$rs = $this->get_all(\"SHOW COLUMNS FROM \".$table);
\nif(!$rs)
\n{
\nreturn false;
\n}
\nforeach($rs AS $key=>$value)
\n{
\n$rslist[] = $value[\"Field\"];
\n}
\nreturn $rslist;
\n}
\n#[\u663e\u793a\u8868\u540d]
\nfunction list_tables()
\n{
\n$rs = $this->get_all(\"SHOW TABLES\");
\nreturn $rs;
\n}
\nfunction table_name($table_list,$i)
\n{
\nreturn $table_list[$i];
\n}
\nfunction escape_string($char)
\n{
\nif(!$char)
\n{
\nreturn false;
\n}
\nreturn mysqli_escape_string($this->conn,$char);
\n}
\nfunction get_version()
\n{
\nreturn mysqli_get_server_info($this->conn);
\n}
\nfunction time_used()
\n{
\n$time = explode(\" \",microtime());
\n$used_time = $time[0] + $time[1];
\nreturn $used_time;
\n}
\n\/\/Mysql\u7684\u67e5\u8be2\u65f6\u95f4
\nfunction conn_times()
\n{
\nreturn $this->conn_times + $this->query_times;
\n}
\n\/\/MySQL\u67e5\u8be2\u8d44\u6599
\nfunction conn_count()
\n{
\nreturn $this->query_count;
\n}
\n# \u9ad8\u6548SQL\u751f\u6210\u67e5\u8be2\uff0c\u4ec5\u9002\u5408\u5355\u8868\u67e5\u8be2
\nfunction phpok_one($tbl,$condition=\"\",$fields=\"*\")
\n{
\n$sql = \"SELECT \".$fields.\" FROM \".$this->db->prefix.$tbl;
\nif($condition)
\n{
\n$sql .= \" WHERE \".$condition;
\n}
\nreturn $this->get_one($sql);
\n}
\nfunction debug()
\n{
\nif(!$this->querylist || !is_array($this->querylist) || count($this->querylist) < 1)
\n{
\nreturn false;
\n}
\n$html = '<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" bgcolor=\"#CECECE\"><tr><td>';
\n$html.= '<table cellpadding=\"1\" cellspacing=\"1\" width=\"100%\">';
\n$html.= '<tr><th bgcolor=\"#EFEFEF\" height=\"30px\">SQL<\/th><th bgcolor=\"#EFEFEF\" width=\"80px\">\u67e5\u8be2<\/th><\/tr>';
\nforeach($this->querylist AS $key=>$value)
\n{
\n$html .= '<tr><td bgcolor=\"#FFFFFF\"><div style=\"padding:3px;color:#6E6E6E;\">'.$value['sql'].'<\/div><\/td>';
\n$html .= '<td align=\"center\" bgcolor=\"#FFFFFF\"><div style=\"padding:3px;color:#000000;\">'.$value[\"count\"].'<\/div><\/td><\/tr>';
\n}
\n$html.= \"<\/table>\";
\n$html.= \"<\/td><\/tr><\/table>\";
\nreturn $html;
\n}
\nfunction conn_status()
\n{
\nif(!$this->conn) return false;
\nreturn true;
\n}
\n}
\n?><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"php7\u53d6\u6d88\u4e86mysql\u8fde\u63a5\u65b9\u5f0f\uff0c\u91c7\u7528mysqli\u8fde\u63a5\u3002 mysql_query \u6539\u7528 mysqli...<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15330,15331],"tags":[],"class_list":["post-234","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"_links":{"self":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=234"}],"version-history":[{"count":0,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=\/wp\/v2\/posts\/234\/revisions"}],"wp:attachment":[{"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lnmp.ivan.xin\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}