MsSql7.0数据导入MySql - 连接数据库!
提示:此MSSQL权限为系统权限,也就是跟登录操作系统一样!
<?php //config.inc.php ***Mssql数据库操作配置文件
define("MsUserName", "");
define("MsPassWord", "");
define("MsServerName", "localhost");
$MsDBName="db_test";
?>
------------
<?php //dbMsSql.inc.php 此为当年HOFMAN的杰作 ***Mssql数据库操作类文件
Class MsDBSQL{
var $CONN = "";
var $USER = MsUserName;
var $PASS = MsPassWord;
var $SERVER = MsServerName;
var $MsDBName = MsDBName;
function MsDBSQL($MsDBName){
$user = $this->USER;
$pass = $this->PASS;
$server = $this->SERVER;
$dbase = $MsDBName;
$conn = mssql_connect($server,$user,$pass);
/*******
* 看清此处,一般PHP服务器默认是无法连接MSSQL数据库的,
* 必须从php.ini 里设置可连接MSSQL
*******/
if(!$conn) {
echo "数据库连接失败!请检查系统设置。";
exit;
}
if(!mssql_select_db($dbase,$conn)) {
echo "数据库 $DBName 选择失败!请检查系统设置。";
exit;
}
$this->CONN = $conn;
return true;
}
function select($sql=""){
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mssql_query($sql,$conn);
if ((!$results) or (empty($results))) {
mssql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = mssql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mssql_free_result($results);
return $data;
}
function insert($sql=""){
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mssql_query($sql,$conn);
if (!$results) return false;
$results = mssql_insert_id();
return $results;
}
?>
------------
<?php //连接Mysql数据库的配置文件 config.inc.php
define("UserName", "root");
define("PassWord", "");
define("ServerName", "localhost");
$DBName="db_l365";
?>
----------
<?php //Mysql数据库操作类 dbsql.inc.php
Class DBSQL
{
var $CONN = "";
var $USER = UserName;
var $PASS = PassWord;
var $SERVER = ServerName;
var $DBName = DBName;
function DBSQL($DBName)
{
$user = $this->USER;
$pass = $this->PASS;
$server = $this->SERVER;
$dbase = $DBName;
$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
echo "数据库连接失败!请检查系统设置。";
exit;
}
if(!mysql_select_db($dbase,$conn)) {
echo "数据库 $DBName 选择失败!请检查系统设置。";
exit;
}
$this->CONN = $conn;
return true;
}
function select($sql=""){
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if ((!$results) or (empty($results))) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}
function insert($sql=""){
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if (!$results) return false;
$results = mysql_insert_id();
return $results;
}
?>
meiking
2004-11-04 17:55:55
评论:0
阅读:1361
引用:0
