01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & SQL Server (sqlsrv)</title>
04.</head>
05.<body>
06.<?php
07. ini_set('display_errors', 1);
08. error_reporting(~0);
09.
10. $serverName = "region\region";
11. $userName = "sa";
12. $userPassword = "";
13. $dbName = "mydatabase";
14.
15. $connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword, "MultipleActiveResultSets"=>true);
16.
17. $conn = sqlsrv_connect( $serverName, $connectionInfo);
18.
19. if( $conn === false ) {
20. die( print_r( sqlsrv_errors(), true));
21. }
22.
23.
24. $stmt = "SELECT * FROM customer";
25. $query = sqlsrv_query($conn, $stmt);
26.
27.?>
28.<table width="600" border="1">
29. <tr>
30. <th width="91"> <div align="center">CustomerID </div></th>
31. <th width="98"> <div align="center">Name </div></th>
32. <th width="198"> <div align="center">Email </div></th>
33. <th width="97"> <div align="center">CountryCode </div></th>
34. <th width="59"> <div align="center">Budget </div></th>
35. <th width="71"> <div align="center">Used </div></th>
36. </tr>
37.<?php
38.while($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC))
39.{
40.?>
41. <tr>
42. <td><div align="center"><?php echo $result["CustomerID"];?></div></td>
43. <td><?php echo $result["Name"];?></td>
44. <td><?php echo $result["Email"];?></td>
45. <td><div align="center"><?php echo $result["CountryCode"];?></div></td>
46. <td align="right"><?php echo $result["Budget"];?></td>
47. <td align="right"><?php echo $result["Used"];?></td>
48. </tr>
49.<?php
50.}
51.?>
52.</table>
53.<?php
54.sqlsrv_close($conn);
55.?>
56.</body>
57.</html>
