建立一個資料庫操作類的PHP檔案，檔案内容：
//MySQL、MySQLi、SQLite 三合一資料庫操作類
if(!defined('IN_CRONLITE'))exit();
$nomysqli=false;
if(defined('SQLITE')==true){
class DB {
var $link = null;
function __construct($db_file){
global $siteurl;
$this->link = new PDO('sqlite:'.ROOT.'includes/sqlite/'.$db_file.'.db');
if (!$this->link) die('Connection Sqlite failed.\n');
return true;
}
function fetch($q){
return $q->fetch();
}
function get_row($q){
$sth = $this->link->query($q);
return $sth->fetch();
}
function count($q){
$sth = $this->link->query($q);
return $sth->fetchColumn();
}
function query($q){
return $this->result=$this->link->query($q);
}
function affected(){
return $this->result->rowCount();
}
function error(){
$error = $this->link->errorInfo();
return '['.$error[1].'] '.$error[2];
}
}
}
elseif(extension_loaded('mysqli') && $nomysqli==false) {
class DB {
var $link = null;
function __construct($db_host,$db_user,$db_pass,$db_name,$db_port){
$this->link = mysqli_connect($db_host, $db_user, $db_pass, $db_name, $db_port);
if (!$this->link) die('Connect Error (' . mysqli_connect_errno() . ') '.mysqli_connect_error());
//mysqli_select_db($this->link, $db_name) or die(mysqli_error($this->link));
mysqli_query($this->link,"set sql_mode = ''");
//字元轉換，讀庫
mysqli_query($this->link,"set character set 'utf8'");
//寫庫
mysqli_query($this->link,"set names 'utf8'");
return true;
}
function fetch($q){
return mysqli_fetch_assoc($q);
}
function get_row($q){
$result = mysqli_query($this->link,$q);
return mysqli_fetch_assoc($result);
}
function count($q){
$result = mysqli_query($this->link,$q);
$count = mysqli_fetch_array($result);
return $count[0];
}
function query($q){
return mysqli_query($this->link,$q);
}
function escape($str){
return mysqli_real_escape_string($this->link,$str);
}
function insert($q){
if(mysqli_query($this->link,$q))
return mysqli_insert_id($this->link);
return false;
}
function affected(){
return mysqli_affected_rows($this->link);
}
function insert_array($table,$array){
$q = "INSERT INTO `$table`";
$q .=" (`".implode("`,`",array_keys($array))."`) ";
$q .=" VALUES ('".implode("','",array_values($array))."') ";
if(mysqli_query($this->link,$q))
return mysqli_insert_id($this->link);
return false;
}
function error(){
$error = mysqli_error($this->link);
$errno = mysqli_errno($this->link);
return '['.$errno.'] '.$error;
}
function close(){
$q = mysqli_close($this->link);
return $q;
}
}
} else { // we use the old mysql
class DB {
var $link = null;
function __construct($db_host,$db_user,$db_pass,$db_name,$db_port){
$this->link = @mysql_connect($db_host.':'.$db_port, $db_user, $db_pass);
if (!$this->link) die('Connect Error (' . mysql_errno() . ') '.mysql_error());
mysql_select_db($db_name, $this->link) or die(mysql_error($this->link));
mysql_query("set sql_mode = ''");
//字元轉換，讀庫
mysql_query("set character set 'utf8'");
//寫庫
mysql_query("set names 'utf8'");
return true;
}
function fetch($q){
return mysql_fetch_assoc($q);
}
function get_row($q){
$result = mysql_query($q, $this->link);
return mysql_fetch_assoc($result);
}
function count($q){
$result = mysql_query($q, $this->link);
$count = mysql_fetch_array($result);
return $count[0];
}
function query($q){
return mysql_query($q, $this->link);
}
function escape($str){
return mysql_real_escape_string($str, $this->link);
}
function affected(){
return mysql_affected_rows($this->link);
}
function insert($q){
if(mysql_query($q, $this->link))
return mysql_insert_id($this->link);
return false;
}
function insert_array($table,$array){
$q = "INSERT INTO `$table`";
$q .=" (`".implode("`,`",array_keys($array))."`) ";
$q .=" VALUES ('".implode("','",array_values($array))."') ";
if(mysql_query($q, $this->link))
return mysql_insert_id($this->link);
return false;
}
function error(){
$error = mysql_error($this->link);
$errno = mysql_errno($this->link);
return '['.$errno.'] '.$error;
}
function close(){
$q = mysql_close($this->link);
return $q;
}
}
}
?>
導入後即可執行以下操作：
define('IN_CRONLITE', true);
define('SYSTEM_ROOT', dirname(__FILE__).'/');
include_once(SYSTEM_ROOT."mysql.php");
$dbconfig=array(
'host' => 'localhost', //資料庫伺服器
'port' => '3306', //資料庫端口
'user' => '', //資料庫使用者名
'pwd' => '', //資料庫密碼
'dbname' => '', //資料庫名
);
$rs=$DB->query("select * from 表 where id = ".$_POST['id']." limit 1");
$conf = $DB->fetch($rs);
echo $conf['表單'];
if($DB->query("DELETE FROM `表` WHERE `apis`.`id` = ".$id)){
echo '删除成功！';
}else{
echo '删除失敗！';
}
if($DB->query("TRUNCATE TABLE `表`")==true){
echo '清空成功';
}else{
echo'清空失敗';
}
$sql = $DB->query("INSERT INTO `表` (`id`) VALUES ($id)");
if($sql){
echo '添加成功';
}else{
echo '添加失敗';
}
if($DB -> query("UPDATE `表` SET `索引` = '修改内容' WHERE `表`.`主鍵` = ".$id) == true){
echo '修改成功！！！';
}else{
echo '修改失敗！！！';
}
?>