โค้ด: เลือกทั้งหมด
if (isset($_POST['submit'])) {
$submit1 = @$_POST['submit1'];
$name = $_POST['user_name'];
$value = $_POST['valuenum'];//เราต้องใส่ลิงยูทูปที่จะเปลี่ยนเป็นรหัสไปร
// $key = '';
$sql = "SELECT * FROM mzc_mdistrict
INNER JOIN mzc_mprovince ON mzc_mprovince.PROVINCE_ID = mzc_mdistrict.PROVINCE_ID
INNER JOIN mzc_mamphur on mzc_mamphur.AMPHUR_ID = mzc_mdistrict.AMPHUR_ID
WHERE mzc_mamphur.POSTCODE =$value";
$result2 = mysqli_query($conn, $sql);
while (@$fetch1 = mysqli_fetch_assoc($result2)) {
$district = $fetch1['DISTRICT_NAME'];
$province2 =$fetch1['PROVINCE_NAME'];
$amphor =$fetch1['AMPHUR_NAME'];
}
$sql3 = "INSERT INTO `tool_province`( `user_name`, `PROVINCE_ID`, `DISTRICT_ID`, `AMPHUR_ID`, `postal_code`, `create_date`, `ip`)
VALUES ('$name','$province2','$district','$amphor','$value','$time','$ip')";
$result2 = mysqli_query($conn, $sql3);