/*Mysql.class.php*/
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<?php
$conn;
class Mysql{
public function connect($localhost,$name,$password,$database){
$this->conn=@mysql_connect($localhost,$name,$password) or die("數據庫連接失敗!");
@mysql_select_db($database) or die("選擇數據庫失敗!");
mysql_query("set names utf8");
}
public function close(){
mysql_close($this->conn)
}
}
?>
</body>
</html>
/*AdminDb.class.php*/
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<?php
class AdminDb{
public function executeSQL($sql){
$sqlType=strtolower(substr(trim($sql),0,6));
//截取SQL語句前六個字母判斷操作類型
$result=mysql_query($sql);
if($sqlType=="select") {
$row=mysql_fetch_array($result);
if(count($row)==0||count($row)==false){
echo "select wrong"."<br>";
}
else {
//自行添加相關操作
//echo "select successully!"."<br>";
return $row; //返回結果集
}
}
elseif($sql=="update"||$sql=="delete"||$sql=="insert"){
return $rusult;//返回結果
}
else {
return false; //既不是select，也不是update，delete，insert，返回錯誤
}
}
}
?>
</body>
</html>
/*test.php*/
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<?php
include("Mysql.class.php");
include("AdminDb.class.php");
$mysql=new Mysql();
$mysql->connect("localhost","root","root","test");
$admin=new AdminDb();
$sql="select * from user";
$result=$admin->executeSQL($sql);
print_r($result);
$mysql->close();
?>
</body>
</html>
