01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & SQL Server (PDO)</title>
04.</head>
05.<body>
06.<?php
07. ini_set('display_errors', 1);
08. error_reporting(~0);
09.
10. $strKeyword = null;
11.
12. if(isset($_POST["txtKeyword"]))
13. {
14. $strKeyword = $_POST["txtKeyword"];
15. }
16.?>
17.<form name="frmSearch" method="post" action="<?php echo $_SERVER['SCRIPT_NAME'];?>">
18. <table width="599" border="1">
19. <tr>
20. <th>Keyword
21. <input name="txtKeyword" type="text" id="txtKeyword" value="<?php echo $strKeyword;?>">
22. <input type="submit" value="Search"></th>
23. </tr>
24. </table>
25.</form>
26.
27.<?php
28.
29. $serverName = "localhost";
30. $userName = "sa";
31. $userPassword = "";
32. $dbName = "mydatabase";
33.
34. $conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);
35.
36. $sql = "SELECT * FROM customer WHERE Name LIKE '%".$strKeyword."%' ";
37.
38. $stmt = $conn->prepare($sql);
39. $stmt->execute();
40.
41.?>
42.<table width="600" border="1">
43. <tr>
44. <th width="91"> <div align="center">CustomerID </div></th>
45. <th width="98"> <div align="center">Name </div></th>
46. <th width="198"> <div align="center">Email </div></th>
47. <th width="97"> <div align="center">CountryCode </div></th>
48. <th width="59"> <div align="center">Budget </div></th>
49. <th width="71"> <div align="center">Used </div></th>
50. </tr>
51.<?php
52.while($result = $stmt->fetch( PDO::FETCH_ASSOC ))
53.{
54.?>
55. <tr>
56. <td><div align="center"><?php echo $result["CustomerID"];?></div></td>
57. <td><?php echo $result["Name"];?></td>
58. <td><?php echo $result["Email"];?></td>
59. <td><div align="center"><?php echo $result["CountryCode"];?></div></td>
60. <td align="right"><?php echo $result["Budget"];?></td>
61. <td align="right"><?php echo $result["Used"];?></td>
62. </tr>
63.<?php
64.}
65.?>
66.</table>
67.<?php
68.$conn = null;
69.?>
70.</body>
71.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
