$hostname = "localhost"; //MSSQL Server$dbuser = "sa"; //用户名$dbpasswd = "1111111"; //密码//连接数据库$id = mssql_connect($hostname,$dbuser,$dbpasswd) or die("无法连接数据库服务器!");$db = mssql_select_db("DB",$id) or die("无法连接数据库!");//以TABLE表为例,构建查询字符串$query = "select * from TABLE";//执行查询语句$rresult = mssql_query($query) or die("无法执行SQL:$query");
$av_user = "sa";
$av_password = "密码";
$av_conn_id = mssql_connect($av_dsn,$av_user,$av_password);
$db="dboa";
$db = mssql_select_db("$db",$av_conn_id) or die("无法连接数据库!");
$av_user = "sa";
$av_password = "密码";
$av_conn_id = mssql_connect($av_dsn,$av_user,$av_password);
$db="dboa";
$db = mssql_select_db("$db",$av_conn_id) or die("无法连接数据库!");
这个是连接MSSQL的代码,不是连接MYSQL的$hostname = "换成IP";
$dbuser = "root"; //用户名
$dbpasswd = ""; //密码
//连接数据库
$id = mysql_connect($hostname,$dbuser,$dbpasswd) or die("无法连接数据库服务器!");
$db = mysql_select_db("数据库") or die("无法连接数据库!");
$id = mssql_connect($hostname,$dbuser,$dbpasswd);
$db = mssql_select_db("DB",$id);
$query = "select * from TABLE";
$rresult = mssql_query($query) or die("无法执行SQL:$query");