$link=mssql_connect('DEEABEB7136E48B','sa','123456');
if(!$link)
echo "<script language=\"JavaScript\">alert(\"MySQL 数据库连接失败\");</script>";
else
echo "<script language=\"JavaScript\">alert(\"MySQL 数据库连接成功\");</script>";
mssql_close();总弹出第一个连接失败的对话框,要怎么样才能弹出第二个呢? 还需要什么步骤吗?求各位大大帮帮忙了谢谢。
if(!$link)
echo "<script language=\"JavaScript\">alert(\"MySQL 数据库连接失败\");</script>";
else
echo "<script language=\"JavaScript\">alert(\"MySQL 数据库连接成功\");</script>";
mssql_close();总弹出第一个连接失败的对话框,要怎么样才能弹出第二个呢? 还需要什么步骤吗?求各位大大帮帮忙了谢谢。
private $dbname = '';
private $dbuser = '';
private $dbpass = '';
private $dblink = false;
private $errsql; public function __construct(){
$this->dblink = @mssql_pconnect($this->dbhost,$this->dbuser,$this->dbpass) or die($this->halt());
@mssql_select_db($this->dbname,$this->dblink);
} public function exec($sql){
$this->errsql = $sql;
$query = mssql_query($sql) or die($this->halt());
return $query;
} public function fetch($query,$result_type = MSSQL_ASSOC){
$row = mssql_fetch_array($query,$result_type);
return $row;
}
public function affected_rows(){
return mssql_rows_affected($this->dblink) or die ($this->halt());
} public function num_rows($query){
return mssql_num_rows($query);
} public function free_result($query) {
return @mssql_free_result($query) or die($this->halt());;
} public function insert_id(){
$query = $this->query("SELECT @@IDENTITY as last_insert_id");
$row = $this->fetch($query);
$this->free_result($query);
return $row['last_insert_id'];
} public function seek($query,$offset){
@mssql_data_seek($query,$offset) or die($this->halt());;
} public function halt(){
$error = mssql_get_last_message();
return 'MsSQL Error: '.$error."<br>".$this->errsql;
} public function get_one($sql){
$query = $this->exec($sql);
$row = $this->fetch($query);
$this->free_result($query);
return $row;
} public function closedb(){
mssql_close() or die($this->halt());
}}?>试试这个类 0 0
还有,要开启mssql的驱动
还有个相关的ntwdblib.dll文件,自己谷歌下