My system allow user to select different year to log in and each year will be in a different database, after uploading the code to the server, I've found out that all of my insert to database query are not working at all (Work fine in localhost). Please let me know where I should fix this issue. Please let me know if you need more details on the issue.Thank you
if(isset($_POST['save']))
{
$HnameSelect = mysqli_real_escape_string($db, $_POST['HnameSelect']);
$group_id = mysqli_real_escape_string($db, $_POST['group_id']);
$member = mysqli_real_escape_string($db, $_POST['member']);
$name = mysqli_real_escape_string($db, $_POST['name']);
$gender = mysqli_real_escape_string($db, $_POST['gender']);
$address = mysqli_real_escape_string($db, $_POST['address']);
$dob = mysqli_real_escape_string($db, $_POST['dob']);
$age = mysqli_real_escape_string($db, $_POST['age']);
$zodiac = mysqli_real_escape_string($db, $_POST['zodiac']);
$mob_ch = mysqli_real_escape_string($db, $_POST['mob_ch']);
if(isset($_POST['leap_month']))
$leap_month = 1;
else $leap_month = 0;
$contact = mysqli_real_escape_string($db, $_POST['contact']);
$contact_mobile = mysqli_real_escape_string($db, $_POST['contact_mobile']);
$dob_ch = mysqli_real_escape_string($db, $_POST['dob_ch']);
$tob_ch = mysqli_real_escape_string($db, $_POST['tob_ch']);
$more_remark = mysqli_real_escape_string($db, $_POST['more_remark']);
date_default_timezone_set('Asia/Kuala_Lumpur');
$postingDate = date('Y-m-d G:i:s ', strtotime("now"));
$status = 1;
$insert = mysqli_query($db, "insert into ".$_SESSION["db"].".familygroup (Hid,Gid,member,name,gender,address,dob_en,age,zodiac,mob_ch,leap_month,phoneNumber,phone2,dob_ch,tob_ch,status,more_remark,postingDate) values('".$HnameSelect."', '".$group_id."', '".$member."', '".$name."', '".$gender."', '".$address."', '".$dob."', ".$age.", '".$zodiac."', '".$mob_ch."', ".$leap_month.", '".$contact."', '".$contact_mobile."', '".$dob_ch."', '".$tob_ch."', ".$status.", '".$more_remark."', '".$postingDate."')");
if($insert)
$msg = "已添加";
}