Home >Backend Development >PHP Tutorial >php mssql database connection code_PHP tutorial
php tutorial mssql database tutorial connection code
$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 tutorialnNo=?';
$rst=$conn->execute($sqlstr,'005') or die('connect error');
while(!$rst->EOF)
{
//echo $rst->fields['psnName'].'->'.$rst->fields['www.bKjia.c0m'].'';
echo 'dajiahao';
$rst->movenext();
}
$rst->close();
$conn->close();