php 连接查询显示mssql数据实例

作者：袖梨 2022-06-24

$link = mssql_connect("localhost", "sa", "sa") or die("不能联连上mssql 服务器");
mssql_select_db("test", $link) or die("数据库连接失败");

//创建mssql查询语句

代码如下	复制代码
$ms_sql = "select * from works where username ='www.111com.net'"; $mss_rs = mssql_query( $ms_sql ); if( mssql_num_rows( $mss_rs ) ) { while( $mss_rs = mssql_fetch_object( $mss_rs )) { echo "输出值..."; } } else { echo '记录不存在'; }