最近看了forest斑竹的access类,小弟刚要用到,把access的数据导入mssql,呵呵
因为数据库设计的结构不同,没法子dtc,呵呵,只好自己些程序了,为了方便,
循着forest斑竹的思路,写了个mssql的连接和查询类,没经过测试,请各位大虾指教!
========================================
<?php
//--------------------------------------------------------------------
//FileName:mssql.class.php
//Summary: Mssql数据库操作类
//Author:-_-( netman)
//CreateTime: 2007-1-31
//LastModifed:
//copyright (c)2007 oldsock@163.com
// 使用范例:
//$mssqlHost='localhost';
//$mssqlPwd='yourpassword';
//$mssqlUser='yourusername';
//$db='yourdb';
//include_once("includes/mssql.class.php");
//$access=new Mssql($databasepath,$dbusername,$dbpassword,$db);
//--------------------------------------------------------------------
class Mssql
{
var $mssqlHost,$mssqlUser,$mssqlPwd,$link,$linkDB,$db;
function __construct($mssqlHost,$mssqlUser,$mssqlPwd,$db)
{
$this -> mssqlHost = $mssqlHost;
$this -> mssqlUser = $mssqlUser;
$this -> mssqlPwd = $mssqlPwd;
$this -> db = $db;
$this -> msSelectDB();
}
function msConnect()
{
$this -> link = mssql_connect($this->mssqlHost,$this->mssqlUser,$this->mssqlPwd);
if ($this->link) {
echo '数据库服务器连接成功!';
}else {
echo '数据库服务器连接错误!';
}
return $this->link;
}
function msSelectDB()
{
$this->linkDB=mssql_select_db($this->db,$this->msConnect());
if ($this->linkDB) {
echo '数据库连接成功!';
}else {
echo '对不起,请稍后连接!';
}
return $this->linkDB;
}
function msQuery($sql)
{
return mssql_query($sql,$this->linkDB);
}
//取得记录集总数
function msTotalNum($sql)
{
return mssql_num_rows($this->msQuery($sql));
}
//取得字段总数
function msFieldNum($sql)
{
return mssql_num_fields($this->msQuery($sql));
}
//取得记录集
function msFetchArray($sql)
{
return mssql_fetch_array($this->msQuery($sql));
}
function msClose()
{
mssql_close($this->link);
}
}
?>
因为数据库设计的结构不同,没法子dtc,呵呵,只好自己些程序了,为了方便,
循着forest斑竹的思路,写了个mssql的连接和查询类,没经过测试,请各位大虾指教!
========================================
<?php
//--------------------------------------------------------------------
//FileName:mssql.class.php
//Summary: Mssql数据库操作类
//Author:-_-( netman)
//CreateTime: 2007-1-31
//LastModifed:
//copyright (c)2007 oldsock@163.com
// 使用范例:
//$mssqlHost='localhost';
//$mssqlPwd='yourpassword';
//$mssqlUser='yourusername';
//$db='yourdb';
//include_once("includes/mssql.class.php");
//$access=new Mssql($databasepath,$dbusername,$dbpassword,$db);
//--------------------------------------------------------------------
class Mssql
{
var $mssqlHost,$mssqlUser,$mssqlPwd,$link,$linkDB,$db;
function __construct($mssqlHost,$mssqlUser,$mssqlPwd,$db)
{
$this -> mssqlHost = $mssqlHost;
$this -> mssqlUser = $mssqlUser;
$this -> mssqlPwd = $mssqlPwd;
$this -> db = $db;
$this -> msSelectDB();
}
function msConnect()
{
$this -> link = mssql_connect($this->mssqlHost,$this->mssqlUser,$this->mssqlPwd);
if ($this->link) {
echo '数据库服务器连接成功!';
}else {
echo '数据库服务器连接错误!';
}
return $this->link;
}
function msSelectDB()
{
$this->linkDB=mssql_select_db($this->db,$this->msConnect());
if ($this->linkDB) {
echo '数据库连接成功!';
}else {
echo '对不起,请稍后连接!';
}
return $this->linkDB;
}
function msQuery($sql)
{
return mssql_query($sql,$this->linkDB);
}
//取得记录集总数
function msTotalNum($sql)
{
return mssql_num_rows($this->msQuery($sql));
}
//取得字段总数
function msFieldNum($sql)
{
return mssql_num_fields($this->msQuery($sql));
}
//取得记录集
function msFetchArray($sql)
{
return mssql_fetch_array($this->msQuery($sql));
}
function msClose()
{
mssql_close($this->link);
}
}
?>