PHP中MySQL的连接封装

来源:互联网 发布:python宝典 编辑:程序博客网 时间:2024/06/06 01:38

config.php配置文件:

<?phpdefine("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();}


原创粉丝点击