整理 原生PHP连接MySQL的模板

原生PHP连接MySQL的模板：

<?php
header('Content-Type: text/html; charset=utf-8');

//安全设置
if (!defined ('CHAOYI')){
	exit ( 'Access Defined!' );
}

/*修改数据库链接 begin*/
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpwd = '123456';
$dbname = 'testDB';
/*修改数据库链接 end*/

/*下面的部分不可修改*/
function sqlConnect(){
	global $conn;
	if(!$conn = @mysql_connect(DBHost,DBUser,DBPwd)){exit('数据库连接失败');}
}
function sqlSetDB(){
	if(!mysql_select_db(DBName)){exit('找不到指定的数据库');}
}
function sqlSetName(){
	if(!mysql_query('SET NAMES UTF8')){exit('字符集错误');}
}
function sqlQuery($sql){
	if(!$result = mysql_query($sql)){exit('SQL执行失败');}
	return $result;
}
function sqlGetOne($sql){
	return mysql_fetch_array(sqlQuery($sql),MYSQL_ASSOC);
}
function sqlClose(){
	if(!mysql_close()){exit('关闭异常');}
}

define('DBHost',$dbhost);
define('DBUser',$dbuser);
define('DBPwd',$dbpwd);
define('DBName',$dbname);

sqlConnect();
sqlSetDB();
sqlSetName();

 

测试代码：

<?php
define('CHAOYI',true);
require "connect.inc.php";
$str = '<>阅谁问君诵，"水落清香浮';
$str2 = htmlspecialchars(trim($str), ENT_QUOTES);
echo $str2;
$sql = "SELECT id,keyword FROM tb_user WHERE telephone='' LIMIT 1";
$result = sqlGetOne($sql);
print_r($result);
sqlClose();

 

效果图：