- 伺服器:Windows7
- Apache:2.2.22
- PHP:5.4.3
- MSSQL Server:SQLSERVER2008
網站伺服器需要安裝:
PHP 需要 extensions 套件:
PHP 登入範例:
<?php $DB_HOST1 = "";//IP $DB_LOGIN1 = "";//uid $DB_PASSWORD1 = "";//pwd $DB_NAME1 = "";//db name $serverName = $DB_HOST1; $connectionInfo = array("UID"=>$DB_LOGIN1, "PWD"=>$DB_PASSWORD1, "Database"=>$DB_NAME1, "CharacterSet" => "UTF-8" ); $conn = sqlsrv_connect( $serverName, $connectionInfo); $params = array(); $options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET ); $sqlstr = "select * from Users"; $res = sqlsrv_query($conn,$sqlstr,$params,$options); $num = sqlsrv_num_rows($res); for($i=0;$i<$num;$i++) { $r = sqlsrv_fetch_array($res); echo $r[0].' '.$r[1].'<br />'; } ?>
沒有留言:
張貼留言