php mysql模板_整理 原生PHP连接MySQL的模板

原生PHP连接MySQL的模板：

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();

测试代码：

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();

效果图：