Home > Article > Backend Development > PHP uses adodb to connect to mssql database code_PHP tutorial
php使用adodb连接mssql数据库代码
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();