<?php
$db["dbhost"] = "localhost";
$db["user"] = "root";
$db["pwd"] ="";
$db["dbName"]="";
<?php
require_once 'inc.php';//链接数据库
function conn($dbHost,$user,$pwd,$dbName){
$link = mysql_connect($dbHost,$user,$pwd);
mysql_select_db($dbName,$link);
mysql_query("set names utf8");
}
//执行sql语句
function query($sql){
return mysql_query($sql);
}
//记录总数
function numRows($sql){
$result = mysql_query($sql);
$count = mysql_num_rows($result);
return $count;
}
//得到一条记录的一维数组
function fetchOne($sql){
$result = mysql_query($sql);
return mysql_fetch_assoc($result);
}
//得到所有记录的二维数组
function fetch($sql){
$result = mysql_query($sql);
$rows = array();
while($rs = mysql_fetch_assoc($result)){
$rows[] = $rs;
}
return $rows;
}
//关闭数据库链接
function close(){
mysql_close();
}
conn($db["dbhost"], $db["user"], $db["pwd"], $db["dbName"]);