if (isset($submit)) {
setcookie("name",$name);
setcookie("sex",$sex);
setcookie("phone_day",$phone_day);
setcookie("phone_night",$phone_night);
setcookie("service",$service);
setcookie("ca",$ca);
setcookie("payment",$payment);
setcookie("area",$area);
setcookie("address",$address);
// include configuration file
include ("../config/config.php");
$time = time();
// Table name
$tblname = "fs_wbap1";
// create connection to MySQL
mysql_connect($dbhost, $dbuname, $dbpass);
@mysql_select_db("$dbname") or die ("Unable to select database");
// Get new record number
$query = "select id from ".$tblname." order by id desc";
$result = mysql_query($query);
if(!$result){
echo mysql_errno(). ": ".mysql_error(). "
"; exit();
}
$num_results = mysql_num_rows($result);
if ($num_results ==0 ) { // No records
$id = 1;
}
else {
$row = mysql_fetch_array($result);
$id = $row[id] + 1;
}
$name = addslashes($name);
$sex = "$sex_M$sex_F";
$phone_day = addslashes($phone_day);
$phone_night = addslashes($phone_night);
$service = "$service_1$service_2$service_3$service_4$service_5$service_6";
$ca = "$ca_1$ca_2$ca_3";
$payment = "$payment_1$payment_2$payment_3$payment_4";
$address = addslashes($address);
$other = addslashes($other);
$query = "insert into $tblname
(id,name,sex,phone_day,phone_night,service,ca,payment,area,address,other,created)
values
($id, '$name', '$sex', '$phone_day', '$phone_night', '$service', '$ca', '$payment', '$area', '$address', '$other', $time)";
$result = mysql_query($query);
if(!result){
echo mysql_errno(). ": ".mysql_error(). "
"; exit();
}
$showmsg = "
您的申請資料已經送出,我們將會儘快處理";
unset($submit);
}
?>
鳳信有線電視股份有限公司