';
$query = "SELECT * from licence_guide_book_form WHERE id = '".$_SESSION["form_id"]."'";
$result1 = mysqli_query($conn, $query) or die ( mysqli_error());
$row = mysqli_fetch_assoc($result1);
$name= $row['applicant_name'];
$password= $row['mobile_number'];
$email= $row['email_id'];
$status= $row['payment_status'];
$date= $row['form_created_on'];
$user='user'.(rand(5,10000));
echo'
DOWNLOAD YOUR DRIVING LICENCE GUIDE BOOK FROM HERE DOWNLOAD
';
echo '
Thank You For Applying For Driving Licence Online Guide Book
';
echo '
';
echo '
';
echo '
';
echo'
| Login Url: |
Click Here To Login On Driving Licence Guide Quiz Portal |
| Login Details Given Below: |
| Username: |
'.$user.' |
| Password: |
'.$password.' |
| Login details are also mailed on your registered email id |
| Now you are eligible to give free mock test for driving licence guide online on our website |
';
echo "
";
echo "
";
echo "
";
$sql =
"
INSERT INTO users (
user_id,
user_name,
password,
email,
applicant_name,
status,
date
)
VALUES (
'".$_SESSION["form_id"]."',
'".$user."',
'".$password."',
'".$email."',
'".$name."',
'".$status."',
'".$date."'
)";
if(!$result = $conn->query($sql)){
die('There was an error running the query [' . $conn->error . ']');
}
else
{
$_SESSION["form_id"] = $conn->insert_id;
$mail = new PHPMailer(true);
try {
$mail->isSMTP();
$mail->Host = 'smtp.hostinger.com';
$mail->SMTPAuth = true;
$mail->Username = 'no-reply@drivinglicencehelp.com';
$mail->Password = 'freeDOM@611#';
$mail->SMTPSecure = 'tls';
$mail->Port = 587;
$mail->setFrom("no-reply@drivinglicencehelp.com", "Learner Licence Details");
$mail->addAddress("".$row['email_id']."");
$mail->addBcc("udyogaadhaaronline.org@gmail.com");
$mail->isHTML(true);
$mail->Subject = "Login Details For Drivng Licence Guide Mock Test";
$mail->Body = "
Dear
".$row['applicant_name'].",
Your Login Details are
Login Url For Online Mock Test
USER NAME: ".$user."
PASSWORD: ".$password."
Download Your Online Driving Guide Book
";
$mail->send();
$mail->ClearAllRecipients();
$mail->addAddress("no-reply@drivinglicencehelp.com");
$mail->isHTML(true);
$mail->Subject = "Payment Received For ".$row["form_name"]."";
$mail->Body = "
APPLICANT NAME: ".$row["applicant_name"]."
EMAIL ID: ".$row['email_id']."
MOBILE NUMBER: ".$row['mobile_number']."
Client Login Details are
Login Url For Online Mock Test
USER NAME: ".$user."
PASSWORD: ".$password."
Download Your Online Driving Guide Book
";
$mail->send();
}
catch (Exception $e) {
echo "Message could not be sent. Mailer Error: {$mail->ErrorInfo}";
}
}
}
?>