';
echo $id_number.'
';
echo $phone.'
';
echo $email.'
';
echo $address1.'
';
echo $address2.'
';
echo $city.'
';
echo $postcode.'
';
echo $state.'
';
echo $country.'
';
*/
$_SESSION['name'] = $name;
$_SESSION['id_number'] = $id_number;
$_SESSION['phone'] = $phone;
$_SESSION['address1'] = $address1;
$_SESSION['address2'] = $address2;
$_SESSION['city'] = $city;
$_SESSION['postcode'] = $postcode;
$_SESSION['state'] = $state;
$_SESSION['country'] = $country;
if($name == ''){
echo 'You forgot to enter Name.
';
$error = 1;
}
if($id_number == ''){
echo 'You forgot to enter IC / Passport number.
';
$error = 1;
}
if($phone == ''){
echo 'You forgot to enter Contact number.
';
$error = 1;
}
if($address1 == ''){
echo 'You forgot to enter Address Line 1.
';
$error = 1;
}
//if($address2 == ''){ echo 'You forgot to enter Address Line 2.
'; }
$today = date('Y-m-d H:i:s');
if($error == 1){
echo 'Click here to go back to add new member form.';
}else {
db_query2("INSERT INTO member(name, id_number, address1, address2, city, postcode, state, country, phone, email, group_id, company_name, date_added, date_modified, user_id)
VALUES('$name','$id_number','$address1','$address2','$city','$postcode','$state','$country','$phone','$email','$group_id','$company_name','$today','$today','$user_id') ");
$new_mid = $_SESSION['new_id'];
//insert into guest table
db_query("INSERT INTO guest(guest1, id_number1, address1, address2, city, postcode, state, country, phone1, email1, group_id, company_name, user_id, member, guest_type, mid) VALUES('$name','$id_number','$address1','$address2','$city','$postcode','$state','$country','$phone','$email','$group_id','$company_name','$user_id','1','1','$new_mid' )");
echo '' .ucwords($name). ' successfully added as member.
';
echo 'Click here if the browser does not automatically redirect you.';
echo '';
exit();
}
}else if($_POST['upd_member']){
$name = $_POST['name'];
$id_number = $_POST['id_number'];
$phone = $_POST['phone'];
$email = $_POST['email'];
$address1 = addslashes($_POST['address1']);
$address2 = addslashes($_POST['address2']);
$city = $_POST['city'];
$postcode = $_POST['postcode'];
$state = $_POST['state'];
$country = $_POST['country'];
$company_name = $_POST['company'];
$mid = $_POST['mid'];
if($name == ''){
echo 'You forgot to enter Name.
';
$error = 1;
}
if($id_number == ''){
echo 'You forgot to enter IC / Passport number.
';
$error = 1;
}
if($phone == ''){
echo 'You forgot to enter Contact number.
';
$error = 1;
}
if($address1 == ''){
echo 'You forgot to enter Address Line 1.
';
$error = 1;
}
$today = date('Y-m-d H:i:s');
if($error == 1){
echo 'Click here to go back to add new member form.';
}else {
db_query("UPDATE member SET name='$name', id_number='$id_number',address1='$address1',address2='$address2',city='$city',postcode='$postcode',state='$state',country='$country',phone='$phone',email='$email',company_name='$company_name',user_id='$user_id', date_modified='$today' WHERE mid='$mid '");
//$new_mid = $_SESSION['new_id'];
db_query("UPDATE guest SET guest1='$name',id_number1='$id_number',address1='$address1',address2='$address2',city='$city',postcode='$postcode',state='$state',country='$country',phone='$phone',email='$email',company_name='$company_name',user_id='$user_id' WHERE mid='$mid'");
echo '' .ucwords($name). ' details successfully updated.
';
echo 'Click here if the browser does not automatically redirect you.';
echo '';
exit();
}
}else{
add_new_member_form();
}
require_once('footer.php');
?>