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();