config.php配置文件:
<?php
define("DB_HOST","localhost");
define("DB_USER","root");
define("DB_PASS","123");
define("DB_NAME","cms");
define("DB_CHARSET","utf8");
//表前缀
//define("DB_PREFIX","cms_");
//规定时区
date_default_timezone_set("Asia/ShangHai");
mysql.func.php连接文件:
<?php
/*
* 作用:连接数据库
*
*/
function connect($db_host,$db_user,$db_pass,$db_name,$db_charset){
@mysql_connect($db_host,$db_user,$db_pass);
mysql_select_db($db_name);
mysql_set_charset($db_charset);
}
/*
* 作用:遍历结果集返回一个数组
*
*/
function getAll($sql){
$res=mysql_query($sql);
$rows=[];
while($row=mysql_fetch_assoc($res)){
$rows[]=$row;
}
return $rows;
}
/*
*
* 作用:关闭数据库资源
*/
function close(){
mysql_close();
}