abstract：<?phpheader("Content-type: text/html; charset=utf-8");date_default_timezone_set("PRC");$con = @mysqli_connect('127.0.0.1','root','root','hediwangluo&
<?php
header("Content-type: text/html; charset=utf-8");
date_default_timezone_set("PRC");
$con = @mysqli_connect('127.0.0.1','root','root','hediwangluo','3306');
if (!$con)
{
exit( "連接 MySQL 失敗: " . mysqli_connect_error());
}
//設(shè)置數(shù)據(jù)庫字符集編碼
mysqli_query($con,"set character set 'utf8'");//讀庫
mysqli_query($con,"set names 'utf8'");//寫庫
/**
* 獲取多條記錄
*/
function getAll($sql,$result_type=MYSQLI_ASSOC)
{
global $con;
$result=mysqli_query($con,$sql);
if($result)
{
while(@$row=mysqli_fetch_array($result, $result_type)){
$data[]=$row;//查詢返回 $data;
}
mysqli_free_result($result);//釋放內(nèi)存
}
return $data;
}
/**
* 返回滿足條件的第一條記錄
*/
function getOne($sql,$result_type=MYSQLI_ASSOC)
{
global $con;
$result=mysqli_query($con,$sql);
$row = mysqli_fetch_array($result,$result_type);
return $row;
}
/**
* 返回獲取查詢結(jié)果集的數(shù)量
*/
function getResultNum($sql){
global $con;
$res=mysqli_query($con,$sql);
return mysqli_num_rows($res);
}
/**
* @param {Object} $sql 刪除一條數(shù)據(jù),
* 返回bool值
*/
function delete_sql($sql){
global $con;
$res=mysqli_query($con,$sql);
if($res){
return true;
}else{
return false;
}
}
/**
* @param {Object} $sql增加數(shù)據(jù)
* 返回增加數(shù)據(jù)的id
*/
function add_sql($sql){
global $con;
$res= mysqli_query($con,$sql);
if($res){
return mysqli_insert_id($con);
}else{
return false;
}
}
Correcting teacher：查無此人Correction time：2019-06-26 14:54:59
Teacher's summary：完成的不錯。pdo操作速度比之前的mysqli快很多，之后學(xué)習(xí)pdo。繼續(xù)加油