MsSql7.0数据导入MySql - 连接数据库!
提示:此MSSQL权限为系统权限,也就是跟登录操作系统一样!


<?php //config.inc.php ***Mssql数据库操作配置文件
define(
"MsUserName", "");
define(
"MsPassWord", "");
define(
"MsServerName", "localhost");
$MsDBName=
"db_test";
?&gt;
------------
<?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-&gt;USER;
$pass = $this-&gt;PASS;
$server = $this-&gt;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-&gt;CONN = $conn;
return true;
}

function select($sql=
""){
if (empty($sql)) return false;
if (empty($this-&gt;CONN)) return false;

$conn = $this-&gt;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-&gt;CONN)) return false;

$conn = $this-&gt;CONN;
$results = mssql_query($sql,$conn);
if (!$results) return false;
$results = mssql_insert_id();
return $results;
}
?&gt;
------------
<?php
//连接Mysql数据库的配置文件 config.inc.php
define(
"UserName", "root");
define(
"PassWord", "");
define(
"ServerName", "localhost");
$DBName=
"db_l365";
?&gt;

----------
<?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-&gt;USER;
$pass = $this-&gt;PASS;
$server = $this-&gt;SERVER;
$dbase = $DBName;

$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
echo
"数据库连接失败!请检查系统设置。";
exit;
}
if(!mysql_select_db($dbase,$conn)) {
echo
"数据库 $DBName 选择失败!请检查系统设置。";
exit;
}
$this-&gt;CONN = $conn;
return true;
}

function select($sql=
""){
if (empty($sql)) return false;
if (empty($this-&gt;CONN)) return false;

$conn = $this-&gt;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-&gt;CONN)) return false;

$conn = $this-&gt;CONN;
$results = mysql_query($sql,$conn);
if (!$results) return false;
$results = mysql_insert_id();
return $results;
}
?&gt;

meiking   2004-11-04 17:55:55 评论:0   阅读:1361   引用:0

发表评论>>

署名发表(评论可管理,不必输入下面的姓名)

姓名:

主题:

内容: 最少15个,最长1000个字符

验证码: (如不清楚,请刷新)

谢智的个人博客 @CSS by self