php连接mssql并输出内容

作者：袖梨 2022-06-24

include_once('adodb5/adodb.inc.php教程');

代码如下

复制代码

$conn=adonewconnection('odbc_mssql');
$conn->pconnect("driver={sql server};server=dlut-pcsqlexpress;database=yuyan;",'zhouhao','950288');
$adodb_fetch_mode=adodb_fetch_assoc;
$sqlstr='select * from yuyan where ps教程nno=?';
$rst=$conn->execute($sqlstr,'005') or die('connect error');
while(!$rst->eof)
{
//echo $rst->fields['ps教程nname'].'->'.$rst->fields['psnno'].'';
echo 'dajiahao';
$rst->movenext();
}
$rst->close();
$conn->close();