01.<?php
02.header("content-type: text/html; charset=utf-8");
03.header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
04.header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
05.header ("Cache-Control: no-cache, must-revalidate");
06.header ("Pragma: no-cache");
07.
08.
09.
10.$play_province = $_POST[play_province];
11.$play_amphur = $_POST[play_amphur];
12.$play_district = $_POST[play_district];
13. include ('config.php');
14.
15. mysql_connect($config[db_server], $config[db_username], $config[db_password]);
16. mysql_query("SET NAMES utf8");
17. mysql_select_db($config[db_name]);
18.
19. $sql = "SELECT PROVINCE_ID, PROVINCE_NAME FROM play_province order by PROVINCE_NAME ASC";
20. $sql1 = "SELECT * FROM play_event WHERE id='".$_GET['id']."' ";
21. $result = mysql_query($sql);
22. $result1 = mysql_query($sql1);
23. $data=mysql_fetch_array($result1);
24. echo "[{\"play_province\":\"";
25. echo "<label for='play_province'>จังหวัด :</label>";
26. echo "<select name='play_province' id='play_province' onchange='dochange(this)'>";
27. echo "<option value='0'>--กรุณาเลือกจังหวัด--</option>";
28. while ($fetcharr = mysql_fetch_array($result)) {
29. $PROVINCE_ID = $fetcharr[PROVINCE_ID];
30. $PROVINCE_NAME = $fetcharr[PROVINCE_NAME];
31. if($data[PROVINCE_ID] == $fetcharr[PROVINCE_ID]){
32. echo "<option value='$PROVINCE_ID' selected>$PROVINCE_NAME</option>";
33. else
34. echo "<option value='$PROVINCE_ID' >$PROVINCE_NAME</option>";
35. }
36. }
37. echo "</select>\",\"play_amphur\":\"";
38. echo "<label for='play_amphur'>อำเภอ :</label>";
39. echo "<select name='play_amphur' id='play_amphur' onchange='dochange(this)'>";
40.
41. if ($play_province != "0" && $play_province != "") {
42. echo "<option value='0'>--กรุณาเลือกอำเภอ--</option>";
43. $sql = "SELECT AMPHUR_ID, AMPHUR_NAME FROM ".$prefix."play_amphur WHERE PROVINCE_ID='$play_province'";
44. $result = mysql_query($sql);
45. while ($fetcharr = mysql_fetch_array($result)) {
46. $AMPHUR_ID = $fetcharr[AMPHUR_ID];
47. $AMPHUR_NAME = $fetcharr[AMPHUR_NAME];
48. echo "<option value='$AMPHUR_ID'";
49. if ($play_amphur == $AMPHUR_ID)
50. {
51. echo " selected='selected'";
52. }
53. echo ">$AMPHUR_NAME</option>";
54. }
55. } else {
56. echo "<option value=''>--------------</option>";
57. }
58. echo "</select>\",\"play_district\":\"";
59. echo "<label for='play_district'>ตำบล :</label>";
60. echo "<select name='play_district' id='play_district' onchange='dochange(this)'>";
61.
62. if ($play_amphur != "0" && $play_amphur != "") {
63. echo "<option value='0'>--กรุณาเลือกตำบล--</option>";
64. $sql = "SELECT DISTRICT_ID, DISTRICT_NAME FROM ".$prefix."play_district WHERE AMPHUR_ID='$play_amphur'";
65. $result = mysql_query($sql);
66. while ($fetcharr = mysql_fetch_array($result)) {
67. $DISTRICT_ID = $fetcharr[DISTRICT_ID];
68. $DISTRICT_NAME = $fetcharr[DISTRICT_NAME];
69. echo "<option value='$DISTRICT_ID'";
70. if ($play_district == $DISTRICT_ID)
71. {
72. echo " selected='selected'";
73. }
74. echo ">$DISTRICT_NAME</option>";
75. }
76. } else {
77. echo "<option value=''>--------------</option>";
78. }
79. echo "</select>\"}]";
80. mysql_close();
81.?>
Quote:
