abstrait：<?php # 組裝查詢語(yǔ)句 $add_time = time(); $ret = select($db,'user','country="日本"','uid DESC','0,5'); # 組裝插入語(yǔ)句 $add_time = time(); $sql = "INSERT INTO `direct

<?php

# 組裝查詢語(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'];

}

# 查詢單個(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;

}

# 查詢單條數(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;

}

# 查詢方法

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;

}

?>

Professeur correcteur：查無此人Temps de correction：2019-05-05 09:11:13
Résumé du professeur：完成的不錯(cuò)。以后都用pdo進(jìn)行查詢了，但是也要了解下mysqli。繼續(xù)加油。