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_nationality =$_POST["nisit_nationality"];
$nisit_race = $_POST["nisit_race"];
$nisit_id_card= $_POST["nisit_id_card"];
$nisit_accout = $_POST["nisit_accout"];
$nisit_year = $_POST["nisit_year"];
$nisit_GPA = $_POST["nisit_GPA"];
$nisit_adviser = $_POST["nisit_adviser"];
$nisit_yearloan = $_POST["nisit_yearloan"];
$nisit_birthday2 = "$_POST[birthday]";
list( $bday,$bmonth,$byear)= explode("-",$nisit_birthday2);
$byear+543;
$nisit_birthday = "$byear"."-"."$bmonth"."-"."$bday";
if($_POST["list1"]==1) {$nisit_faculty="คณะเกษตร กำแพงแสน";}
else if($_POST["list1"]==2) {$nisit_faculty ="คณะวิทยาศาสตร์การกีฬา";}
else if($_POST["list1"]==3) {$nisit_faculty ="คณะวิศวกรรมศาสตร์ กำแพงแสน";}
else if($_POST["list1"]==4) {$nisit_faculty ="คณะสัตวแพทยศาสตร์";}
else if($_POST["list1"]==5) {$nisit_faculty ="คณะศิลปศาสตร์และวิทยาศาสตร์";}
else if($_POST["list1"]==6) {$nisit_faculty ="คณะศึกษาศาสตร์และพัฒนศาสตร์";}
else if($_POST["list1"]==7) {$nisit_faculty ="คณะประมง";} else $nisit_faculty = $objResultID["nisit_faculty"] ;
$nisit_branch=$_POST["list2"];
$nisit_old=$_POST["age"];
$query1 = "update nisit set nisit_id='$nisit_id' ,nisit_name='$nisit_name' ,nisit_lastname='$nisit_lastname' ,nisit_birthday='$nisit_birthday' ,nisit_old='$nisit_old',nisit_nationality='$nisit_nationality' ,nisit_race='$nisit_race' ,nisit_id_card='$nisit_id_card' ,nisit_accout='$nisit_accout' ,nisit_year='$nisit_year' ,nisit_faculty='$nisit_faculty' ,nisit_branch='$nisit_branch' ,nisit_GPA='$nisit_GPA' ,nisit_adviser='$nisit_adviser',nisit_status='1',nisit_yearloan='$nisit_yearloan' where nisit_id_card='".$_SESSION["mem_idcard"]."'" ;
//echo $query1;
$sql = "update member_user set nisit_id='$nisit_id',mem_faculty='$mem_faculty',mem_branch='$mem_branch' where mem_id= '".$_SESSION["mem_idcard"]."'";
$objQuery2 = mysql_db_query($dbname,$sql);
$objQuery = mysql_db_query($dbname,$query1);
if($objQuery){
echo "";
}
}
?>