01.<html>
02.<head>
03.<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
04.<title>ThaiCreate.Com PHP & SQL Server (sqlsrv)</title>
05.</head>
06.<body>
07.<?php
08. ini_set('display_errors', 1);
09. error_reporting(~0);
10.
11. $serverName = "localhost\SQL2012";
12. $userName = "sa";
13. $userPassword = "";
14. $dbName = "mydatabase";
15.
16. $connectionInfo = array("Database"=>$dbName, "UID"=>$userName, "PWD"=>$userPassword,
17. "MultipleActiveResultSets"=>true,"CharacterSet" => 'UTF-8');
18.
19. $conn = sqlsrv_connect( $serverName, $connectionInfo);
20.
21. if( $conn === false ) {
22. die( print_r( sqlsrv_errors(), true));
23. }
24.
25.
26. $stmt = "SELECT * FROM customer";
27. $query = sqlsrv_query($conn, $stmt);
28.
29.?>
30.<table width="600" border="1">
31. <tr>
32. <th width="91"> <div align="center">CustomerID </div></th>
33. <th width="98"> <div align="center">Name </div></th>
34. <th width="198"> <div align="center">Email </div></th>
35. <th width="97"> <div align="center">CountryCode </div></th>
36. <th width="59"> <div align="center">Budget </div></th>
37. <th width="71"> <div align="center">Used </div></th>
38. </tr>
39.<?php
40.while($result = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC))
41.{
42.?>
43. <tr>
44. <td><div align="center"><?php echo $result["CustomerID"];?></div></td>
45. <td><?php echo $result["Name"];?></td>
46. <td><?php echo $result["Email"];?></td>
47. <td><div align="center"><?php echo $result["CountryCode"];?></div></td>
48. <td align="right"><?php echo $result["Budget"];?></td>
49. <td align="right"><?php echo $result["Used"];?></td>
50. </tr>
51.<?php
52.}
53.?>
54.</table>
55.<?php
56.sqlsrv_close($conn);
57.?>
58.</body>
59.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
