Question

PHP如何连接SQL sever 2000数据库？

Answer 1

class
connCls{
private
$host;
//主机名
private
$name;
//用户名
private
$pass;
//密码
private
$db;
//数据库名
private
$type;
//编码类型
如:GBK,UTF-8
等
public
$sql;
//sql语句
public
$tbl;
//表
public
$n;
//表中的字段
public
$v;
//表中字段的值
public
$id;
//获取的id字段
public
$result=1;//结果集
public
$page;
//当前页

function
__construct($host,$name,$pass,$db,$type){
//构造函数初始化
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->db=$db;
$this->type=$type;
$this->connect();
//调用连接数据库函数
}
//---------------------------------------------------------------------------------
function
connect(){
//定义连接数据库函数
$link=@mysql_connect($this->host,$this->name,$this->pass)or
die("连接数据源失败!错误原因:".mysql_error());
@mysql_select_db($this->db,$link)or
die("抱歉,您选择的数据库".$this->db."不存在!!!");
mysql_query("set
names
'$this->type'");
//防止出现乱码
}
//---------------------------------------------------------------------------------
function
query($sql){
//定义执行sql语句函数
$this->connect();
$rs=mysql_query($sql);
//执行给定的sql语句
return
$rs;
//返回结果集
}

Answer 2

<?php
//(1)打开并选择数据库
$connection
=mssql_connect(
"sql
server
name
",
"databas
user
name
",
"password
");
mssql_select_db(
"database
name
",$connection);
//(2)通过连接，在database
name上运行查询
$result
=
mssql_query(
"select
*
from
tablename
",connection);
//(3)当有结果集中还有行时
while($row
=
mssql_fetch_row($result))
{
(4)输出行中每个属性
for($i=0;$i
<
mssql_num_fields($result);$i++)
echo
$row[$i]
.
"
";
}
//(5)关闭数据库连接
mssql_close($connection);
?>
还要把php.ini关于mssql的那几行前面的分号去掉