$tablename = "booking";//ตารางฐานข้อมูล
function insertData($bookDate,$type,$org,$resercount,$province,$resername,$tel,$email)//สร้างฟังก์ชั่น insertdata
{
global $tablename;
$uploadtime = date("H")-1 .date("is");
$uploadday=date("Ymd");//เปลี่ยนชื่อรูปเป็นปีเดือนวัน
$bookDate = mysql_real_escape_string($_POST['bookDate']);
$type = mysql_real_escape_string($_POST['type']);
$org = mysql_real_escape_string($_POST['org']);
$resercount = mysql_real_escape_string($_POST['resercount']);
$province = mysql_real_escape_string($_POST['province']);
$resername = mysql_real_escape_string($_POST['resername']);
$tel = mysql_real_escape_string($_POST['tel']);
$email = mysql_real_escape_string($_POST['email']);
/*
echo $tablename.'';
echo $exday1.'';
echo $exday2.'';
echo $exday3.'';
echo $exday4.'';
echo $exday5.'';
echo $exday6.'';
echo $exday7.'';
echo $type.'';
echo $org.'';
echo $resercount.'';
echo $province.'';
echo $resername.'';
echo $tel.'';
echo $email.'';
echo $uploadday.'';
echo $uploadtime.'';
*/
$strSQL = "INSERT INTO ".$tablename." (ID,bookDate,resertype,reserorg,resercount,reserprovince,resername,resertel,reseremail,uploadday,uploadtime)";
$strSQL = $strSQL."VALUES('','$bookDate','$type','$org','$resercount','$province','$resername','$tel','$email','$uploadday','$uploadtime')";
if (! mysql_query($strSQL)){
$dberr="mysql_errer";
return false;
}
mysql_close();
return true;
}//insertdata
function ShowForm()
{
echo'
';
changelang("
ดูยอดการจอง","","");
}
if ($tablename == "booking"){
if ($bookDate and $resercount and $resername and $tel){
$result=insertData($bookDate,$type,$org,$resercount,$province,$resername,$tel,$email);
if (! $result){
echo "ไม่สามารถเพิ่มข้อมูลการจองได้";
}else{
echo"เพิ่มข้อมูลเรียบร้อยแล้ว";
if ($tablename == "booking"){
echo "
";
}
}
}else{
ShowForm();
}
}else{
echo'';
}
?>