ต้องแก้ยังไงครับ
ขอบคุณครับ
โค้ด: เลือกทั้งหมด
<?php
if(!session_id()) session_start();
ini_set('display_errors', 1);
error_reporting(~0);
$serverName = "localhost";
$userName = "admin";
$userPassword = "admin";
$dbName = "longmysqli";
$conn = new mysqli($serverName,$userName,$userPassword,$dbName);
$conn->query("set names utf8");
//////////////////////////////// config ตัวใหม่ใช้กับ mysqli
//$i_id = $_POST["i_id"];
$district_name=$_POST["District"];
$amphur_name=$_POST["Amper"];
$province_name = $_POST["Province"];
$postcode = $_POST["PostCode"];
$SQLDistrict="SELECT * FROM district WHERE DISTRICT_NAME='".$district_name."' ";
$result = mysql_query($SQLDistrict);
//$rowDistrict = mysql_fetch_assoc($result);
while($rowDistrict = mysql_fetch_assoc($result)){
$Tdistrict_id = $rowDistrict['DISTRICT_ID'];
}
$SQLAmphur="SELECT A.AMPHUR_ID, A.AMPHUR_NAME FROM amphur A LEFT outer join district B on A.AMPHUR_ID=B.AMPHUR_ID WHERE A.AMPHUR_NAME='".$amphur_name."' ";
$result = mysql_query($SQLAmphur);
while($rowAmphur = mysql_fetch_assoc($result)){
$TAmphur_id = $rowAmphur['AMPHUR_ID'];
}
$SQLProvince="SELECT A.PROVINCE_ID, A.PROVINCE_NAME FROM province A left outer join district B on A.PROVINCE_ID=B.PROVINCE_ID WHERE PROVINCE_NAME='".$province_name."' ";
$result = mysql_query($SQLProvince);
while($rowProvince = mysql_fetch_assoc($result)){
$TProvince_id = $rowProvince['PROVINCE_ID'];
}
mysql_query("UPDATE data_user SET district_id='".$Tdistrict_id."',amphur_id='".$TAmphur_id."',province_id='".$TProvince_id."',postcode='$postcode'
WHERE id = '".$_POST["id"]."' and member_id = '".$_SESSION['login_true']."' ");
?>