ob_start();
session_start();
?>
$host = "//localhost";
$user = "studentloan";
$pass = "mL5hejr";
$dbname = "studentloan";
$conndb = mysql_connect($host,$user,$pass) or die ("Erwwror");
mysql_select_db($dbname,$conndb);
mysql_query("SET NAMES UTF8");
mysql_query("set character set utf8");
?>
Untitled Document
if($_GET["action"]!="save") {?>
ข้อมูลที่อยู่ปัจจุบัน
}?>
if($_GET["action"]=="save")
{
$nisit_num_home2=$_POST["nisit_num_home2"];
$nisit_moo2 =$_POST["nisit_moo2"];
$nisit_soy2=$_POST["nisit_soy2"];
$nisit_road2=$_POST["nisit_road2"];
$nisit_code2=$_POST["nisit_code2"];
$nisit_numberphone2=$_POST["nisit_numberphone2"];
$nisit_tumbol2=$_POST["tumbonHidden1"];
$nisit_aumpur2=$_POST["amphurHidden1"];
$nisit_jungwud2=$_POST["provinceHidden1"];
$qqq=" SELECT * FROM province where PROVINCE_NAME = '".$nisit_jungwud1."' ";
$pr=mysql_query($qqq);
$qpr=mysql_fetch_array($pr);
$aaa=" SELECT * FROM geography where GEO_ID = '".$qpr['GEO_ID']."' ";
$GE=mysql_query($aaa);
$QGE=mysql_fetch_array($GE);
$GEO2=$QGE["GEO_NAME"];
$query1 = "update nisit set nisit_num_home2='$nisit_num_home2' ,nisit_moo2='$nisit_moo2' ,nisit_soy2='$nisit_soy2' ,nisit_road2='$nisit_road2' ,nisit_tumbol2='$nisit_tumbol2' ,nisit_aumpur2='$nisit_aumpur2' ,nisit_jungwud2='$nisit_jungwud2'
,GEO2='$GEON'
,nisit_code2='$nisit_code2' ,nisit_numberphone2='$nisit_numberphone2' where nisit_id_card='".$_SESSION["mem_idcard"]."'" ;
echo $query1;
$objQuery = mysql_db_query($dbname,$query1);
if($objQuery){
echo "";
}
}
?>