1. $conn=ADONewConnection('odbc_mssql'); 
2. $conn->PConnect("Driver={SQL Server};Server=DLUT-PCSQLEXPRESS;Database=yuyan;",'zhouhao','950288'); 
3. $ADODB_FETCH_MODE=ADODB_FETCH_ASSOC; 
4. $sqlstr='select * from yuyan where ps教程nNo=?'; 
5. $rst=$conn->execute($sqlstr,'005') or die('connect error'); 
6. while(!$rst->EOF) 
7. { 
8. //echo $rst->fields['psnName'].'->'.$rst->fields['www.phpfensi.com'].''; 
9. echo 'dajiahao'; 
10. $rst->movenext(); 
11. } 
12. $rst->close(); 
13. $conn->close();

Tags: php mssql数据库连接

分享到：