";
$error=1;
}
if ($LastName=="") {
$error_string .= "Last name is mandatory
";
$error=1;
}
if ($Email=="") {
$error_string .= "Enter your email address
";
$error=1;
}
if ($Country=="") {
$error_string .= "Select your country from dropdown
";
$error=1;
}
if ($Mobile=="") {
$error_string .= "Mobile is mandatory
";
$error=1;
}
if (!is_numeric($Mobile)) {
$error_string .= "Enter your valid mobile number
";
$error=1;
}
if ($error==1) {
$error = '{"status":"validation_failed", "message":"'.$error_string.'"}';
die($error);
}else {
$chksql = "select * from eventbookings where EventId='".mysqli_real_escape_string($con,$eventid)."' and Email='".mysqli_real_escape_string($con,$Email)."'";
$chkrsq = mysqli_query($con,$chksql);
if (mysqli_num_rows($chkrsq)==0) {
$sql = "insert into eventbookings set ";
$sql .= "EventId='".mysqli_real_escape_string($con,$eventid)."', ";
$sql .= "MemberId='".$_SESSION['MASTER_ID']."', ";
$sql .= "FirstName='".mysqli_real_escape_string($con,$FirstName)."', ";
$sql .= "LastName='".mysqli_real_escape_string($con,$LastName)."', ";
$sql .= "Company='".mysqli_real_escape_string($con,$Company)."', ";
$sql .= "Email='".mysqli_real_escape_string($con,$Email)."', ";
$sql .= "Mobile='".mysqli_real_escape_string($con,$Mobile)."', ";
$sql .= "Country='".mysqli_real_escape_string($con,$Country)."', ";
$sql .= "Linkedin='".mysqli_real_escape_string($con,$Linkedin)."', ";
$sql .= "Twitter='".mysqli_real_escape_string($con,$Twitter)."', ";
$sql .= "CreatedIP='".$_SERVER['REMOTE_ADDR']."', ";
$sql .= "CreatedOn='".gmdate("Y-m-d H:i:s")."'";
if (!mysqli_query($con,$sql)) {
$error = '{"status":"technical_error", "message":"Sorry, there was a technical problem."}';
die($error);
}else {
$error = '{"status":"success", "message":"Your booking request has been successfully executed."}';
die($error);
}
} else {
$error = '{"status":"technical_error", "message":"You’ve already requested to join this event."}';
die($error);
}
}
}
$sql = "select a.*, b.FirstName, b.LastName, b.Email, b.ProfilePicture, b.Designation, b.MemberCode from events a join members b on a.CreatedBy=b.MemberId and EventId='".mysqli_real_escape_string($con,$eventid)."'";
$rsq = mysqli_query($con,$sql);
if (mysqli_num_rows($rsq)==0) {
header("location: list-your-event");
die();
}
$rs = mysqli_fetch_assoc($rsq);
$crsq = mysqli_query($con,"select * from countries order by nicename asc");
$mrsq = mysqli_query($con,"select FirstName,LastName,Email from members where MemberId='".$_SESSION['MASTER_ID']."'");
$mrs = mysqli_fetch_assoc($mrsq);
?>
- PROJECT_TITLE