收拾 原生PHP连接MySQL的模板_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();

效果图：