class tess
{ function query($sqlstr)
{
return mysql_query($sqlstr);
}
} 应用又怎么写? $list=new tess();
$list->query("select * from talbe");
上面只是查询,事实你还要先联接数据库,及set names之类的
{ function query($sqlstr)
{
return mysql_query($sqlstr);
}
} 应用又怎么写? $list=new tess();
$list->query("select * from talbe");
上面只是查询,事实你还要先联接数据库,及set names之类的
class Db {
var $dbConn = "";
var $dbServerName = "localhost";
var $dbUserName = "UserName";
var $dbPwd = "dbPwd";
var $dbName = "dbName ";
var $errorMessage = "";
/*
* 功能: 连接数据库
* 输入: 无
* 返回: 无
*/
function dbConn()
{
if (!$this->dbConn)
{
try
{
$this->dbConn = mysql_connect($this->ServerName,$this->dbUserName,$this->dbPwd);
//mysql_query("set names 'utf-8'");
}
catch(Exception $e)
{
echo "数据库连接失败!";
$this->errorMessage = $e;
}
}
}
/*
* 功能: 关闭数据库
* 输入: 无
* 返回: 无
*/
function dbClose()
{
if (!$this -> dbConn)
{
mysql_close($this->dbConn);
}
}
/*
* 功能: 执行SQL操作
* 输入: $sqlStr ->SQL语句(Insert/Update/Delete)
* 返回: 无
*/
function executeSqlNonQuery($sqlStr)
{
//echo $sqlStr.'---|---';
//exit;
$this -> dbConn();
mysql_select_db($this -> dbName);
mysql_query($sqlStr,$this -> dbConn) or die("executeSqlNonQuery执行出错");
$this -> dbClose();
}
/*
* 功能: 执行SQL操作
* 输入: $sqlStr ->SQL语句(Select)
* 返回: $records ->返回查询的结果(二维数组形式)
*/
function executeSql($sqlStr)
{
//echo $sqlStr.'---|---';
//exit;
$this -> dbConn();
mysql_select_db($this -> dbName);
$result = mysql_query($sqlStr,$this -> dbConn) or die("executeSql执行出错");
$this -> dbClose();
while($record = mysql_fetch_array($result)) //形成二维数组
$records[] = $record;
mysql_free_result($result);
return $records;
}
}//应用
$list=new db();
$arr=$list->query("select * from talbe");
//取数据,遍历数组foreach ($arr as $b){
forech ($b as $c){ echo $c;
}}
//注意返回类型就行了
{
//echo $sqlStr.'---|---';
//exit;
$this -> dbConn();
mysql_select_db($this -> dbName);
$result = mysql_query($sqlStr,$this -> dbConn) or die("executeSql执行出错");
$this -> dbClose();
while($record = mysql_fetch_array($result)) //形成二维数组
$records[] = $record;
mysql_free_result($result);
return $records;
}
}
写得够明白的了!