abstract：<?php # 組裝查詢(xún)語(yǔ)句 $add_time = time(); $ret = select($db,'user','country="日本"','uid DESC','0,5'); # 組裝插入語(yǔ)句 $add_time = time(); $sql = "INSERT INTO `direct
<?php
# 組裝查詢(xún)語(yǔ)句
$add_time = time();
$ret = select($db,'user','country="日本"','uid DESC','0,5');
# 組裝插入語(yǔ)句
$add_time = time();
$sql = "INSERT INTO `director` ( name,phone,country,add_time) VALUES ( '一本道','18844441111','日本','{$add_time}');";
$ret = insert($db,$sql);
# 組裝修改語(yǔ)句
$sql = "UPDATE `director` SET name='長(zhǎng)江',phone='15500001111' WHERE tid=3;";
$ret = save($db,$sql);
# 組裝刪除語(yǔ)句
$sql = "DELETE FROM `director` WHERE tid=5;";
$ret = delete($db,$sql);
# 連接方法
function connect($db){
# 連接數(shù)據(jù)庫(kù)
$conn = @mysqli_connect($db['host'],$db['user'],$db['pass'],$db['name'],'3306');
if(!$conn){
# 連接錯(cuò)誤，拋出異常
exit('數(shù)據(jù)庫(kù)報(bào)錯(cuò): '.mysqli_connect_error());
}
return $conn;
}
# 統(tǒng)計(jì)數(shù)量
function count_number($db,$table,$where){
$sql = "SELECT COUNT(*) AS count_number FROM ".$table." WHERE ".$where;
$return = mysqli_query($db,$sql);
$return = mysqli_fetch_assoc($return);
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return['count_number'];
}
# 查詢(xún)單個(gè)數(shù)據(jù)
function find_one($db,$table,$filed,$where){
$sql = "SELECT ".$filed." FROM ".$table.' WHERE '.$where.' LIMIT 1';
$return = mysqli_query($db,$sql);
$return = mysqli_fetch_assoc($return);
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return;
}
# 查詢(xún)單條數(shù)據(jù)
function find($db,$table,$where,$order){
$sql = "SELECT * FROM ".$table.' WHERE '.$where;
if($order){
$sql .= ' ORDER BY '.$order;
}
$sql .= 'LIMIT 1';
$return = mysqli_query($db,$sql);
$return = mysqli_fetch_assoc($return);
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return;
}
# 查詢(xún)方法
function select($db,$table,$where,$order,$limit){
$sql = "SELECT * FROM ".$table.' WHERE '.$where;
if($order){
$sql .= 'ORDER BY '.$order;
}
if($limit){
$sql .= ' LIMIT '.$limit;
}
$return = mysqli_query($db,$sql);
if($return){
while ( $row = mysqli_fetch_assoc($return)) {
$rows[] = $row;
}
mysqli_free_result($return);
}
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $rows;
}
# 插入方法
function insert($db,$sql){
# 執(zhí)行插入
$return = mysqli_query($db,$sql);
if($return){
$return = mysqli_insert_id($db);
}
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return;
}
# 修改方法
function save($db,$sql){
$return = mysqli_query($db,$sql);
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return;
}
# 刪除方法
function delete($db,$sql){
$return = mysqli_query($db.$sql);
# 關(guān)閉數(shù)據(jù)庫(kù)
mysqli_close($db);
return $return;
}
?>
Correcting teacher：查無(wú)此人Correction time：2019-05-05 09:11:13
Teacher's summary：完成的不錯(cuò)。以后都用pdo進(jìn)行查詢(xún)了，但是也要了解下mysqli。繼續(xù)加油。