01.<?php
02. $serverName = "NONAMESERVER";
03. $connectionInfo = array("Database"=>"DBandroid", "UID"=>"sa", "PWD"=>"PASSWORD");
04. $conn = sqlsrv_connect($serverName, $connectionInfo);
05.
06.
07. sqlsrv_begin_transaction( $conn );
08.
09. $arr = null;
10. $var = $_POST['sStock'];
11. $jsonArray = json_decode($var, true);
12.
13. foreach ($jsonArray as $result)
14. {
15. $result["Procode"];
16. $result["Barcode"];
17. $result["Size"];
18. $result["Colorcode"];
19. $result["Desc"];
20. $result["Price"];
21.
22. $DateNow = date("Y-m-d H:i:s");
23.
24. $sql = "INSERT INTO stockverify (branch, stock_date, log_time, barcode, prodcode, size, color, price) VALUES (?,?,?,?,?,?,?,?)";
25. $color = iconv('UTF-8', 'TIS-620',$result["Desc"]);
26. $params = array('C001', date("Y-m-d"), date("H:i:s"), $result["Barcode"], $result["Procode"], $result["Size"], $color, $result["Price"]);
27. $stmt = sqlsrv_query($conn,$sql,$params);
28. }
29.
30.
31.
32. if( $stmt )
33. {
34. sqlsrv_commit( $conn );
35. $arr["Status"] = "1";
36. $arr["Message"] = "Send Data Successfully";
37. }
38. else
39. {
40. sqlsrv_rollback( $conn );
41. $arr["Status"] = "0";
42. $arr["Message"] = "Send Data Failed";
43. }
44.
45. sqlsrv_free_stmt($stmt);
46. echo json_encode($arr);
47.
48. sqlsrv_close($conn);
49.?>
