<?php
function conn($MysqlHost,$MysqlUser,$MysqlPass,$MysqlData="xchngg"){ //创建MYSQL 连接句柄
$MysqlConnecting = @mysql_connect($MysqlHost,$MysqlUser,$MysqlPass) or die("连接MYSQL数据库失败!".mysql_error());
if($MysqlConnecting != FALSE){
mysql_query("SET NAMES GB2312");
@mysql_select_db($MysqlData,$MysqlConnecting);
}
return $MysqlConnecting;
}
function pconn($MysqlHost,$MysqlUser,$MysqlPass,$MysqlData="xchngg"){ //创建MYSQL持久 连接句柄
$MysqlConnecting = @mysql_pconnect($MysqlHost,$MysqlUser,$MysqlPass) or die("连接MYSQL数据库失败!".mysql_error());
@mysql_select_db($MysqlData,$MysqlConnecting);
return $MysqlConnecting;
}
function query($sql,$MysqlConnecting){ //发送请求SQL语句
if($sql != "" && $MysqlConnecting != ""){
$MysqlResult = mysql_query($sql,$MysqlConnecting);
return $MysqlResult;
}
}
function fetch($MysqlResult){ //读取MYSQL数据
if($MysqlResult){
$MysqlDataArray = mysql_fetch_array($MysqlResult);
return $MysqlDataArray;
}
}
function close($MysqlConnecting){ //关闭MYSQL
if($MysqlConnecting != "")
return mysql_close($MysqlConnecting);
}
function numrows($MysqlResult){ //获取MYSQL记录条目
if($MysqlResult){
$rows = mysql_num_rows($MysqlResult);
return $rows;
}
}
function free($MysqlResult){
if($MysqlResult)
return mysql_free_result($MysqlResult);
}
function sqlnum($table,$MysqlConnecting){
$MYSQLsql = "select count(*) as rows from $table";
$MysqlResult = mysql_query($MYSQLsql,$MysqlConnecting);
$MysqlData = mysql_fetch_array($MysqlResult);
$rows = $MysqlData[rows];
return $rows;
}
function insertid($MysqlConnecting){
if($MysqlConnecting != "")
return mysql_insert_id($MysqlConnecting);
}
function result($query, $rows){
$query = @mysql_result($query, $rows);
return $query;
}
/****
function num($table,$id,$MysqlConnecting){
$MYSQLsql = "select $id from $table";
$MysqlResult = mysql_query($MYSQLsql,$MysqlConnecting);
$MysqlRows = mysql_num_rows($MysqlResult);
return $MysqlRows;
}
***/
?>