01.<?php
02.$conn = new mysqli("localhost","root","12345678", "mydatabase") or die( mysqli_connect_error());
03.$conn = "SET CHARACTER SET UTF8";
04.$strSQL = "SELECT * FROM paper WHERE 1 AND p_id = '".$_POST["p_id"]."' ";
05.$result = $conn->query($strSQL) or die ($conn->error);
06.
07.$resultArray = array();
08.while($row = $result->fetch_assoc()){
09. $resultArray[]=$row;
10. }
11.$conn->close();
12.echo json_encode($resultArray);
13.?>
14.
15.
16.<script type="text/javascript">
17.$(document).ready(function(){
18.
19. $("#p_id").change(function(){
20. $.ajax({
21. url: "rpdcheck.php" ,
22. type: "POST",
23. data: 'p_id=' +$("#p_id").val()
24. })
25. .success(function(result) {
26.
27. var obj = jQuery.parseJSON(result);
28.
29. if(obj == '')
30. {
31. alert('ไม่พบข้อมูล !! หรือคุณยังไม่ได้เพิ่มข้อมูล !!');
32.
33. return false;
34. }
35. else
36. {
37. $.each(obj, function(key, inval) {
38.
39. $("#p_id").val(inval["p_id"]);
40. $("#p_name").val(inval["p_name"]);
41. $("#p_price").val(inval["p_price"]);
42. $("#p_picture").val(inval["p_picture"]);
43. $("#p_qty").val(inval["p_qty"]);
44. });
45. }
46.
47. });
48.
49. });
50. });
51.</script>
