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 = "localhost";
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. $sql = "INSERT INTO customer (CustomerID, Name, Email, CountryCode, Budget, Used) VALUES (?, ?, ?, ?, ?, ?)";
24. $params = array($_POST["txtCustomerID"], $_POST["txtName"], $_POST["txtEmail"], $_POST["txtCountryCode"], $_POST["txtBudget"], $_POST["txtUsed"]);
25.
26. $stmt = sqlsrv_query( $conn, $sql, $params);
27. if( $stmt === false ) {
28. die( print_r( sqlsrv_errors(), true));
29. }
30. else
31. {
32. echo "Record add successfully";
33. }
34.
35. sqlsrv_close($conn);
36.?>
37.</body>
38.</html>
ช่วยกันสนับสนุนรักษาเว็บไซต์ความรู้แห่งนี้ไว้ด้วยการสนับสนุน 
