1#@!#!123s

: / home3 / encodto1 / bambooinn.in /
Filename : enquiry_submit.php
back
<?php
include'config.php';
if(isset($_POST['book_room'])){
    $company = $_POST['company'];
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $type = $_POST['business_type'];
    $city = $_POST['city'];
    $address = $_POST['address'];
    $country = $_POST['country'];
    $pin = $_POST['pin'];
    $message = $_POST['message'];
    $date = date("Y/m/d");

    $insrt_item = "INSERT INTO business_enquiry (business_id, business_user, business_company, business_etype, business_phone, business_email, business_address, business_city, business_country, business_pin, business_msg, business_edate) 
    VALUES('', '$name', '$company', '$type', '$phone', '$email', '$address', '$city', '$country', '$pin', '$message', '$date')";
    $run_enquiry = mysqli_query($conn, $insrt_item) or die(mysqli_error($conn));
    if ($run_enquiry) {
    	echo "<script>alert('Thankyou! B2B Enquiry Submitted.');</script>";
        
        $html="<table>
        	<tr><td colspan='2'><h3>Room Enquiry</h3></td></tr>
           	<tr><td>Enquiry Date :</td><td>$date</td></tr>
           	<tr><td>Room :</td><td>$$company</td></tr>
            <tr><td>Name :</td><td>$name</td></tr>
            <tr><td>Email :</td><td>$email</td></tr>
            <tr><td>Mobile No. :</td><td>$phone</td></tr>
            <tr><td>City :</td><td>$city</td></tr>
            <tr><td>Country :</td><td>$country</td></tr>
            <tr><td>Pin Code :</td><td>$pin</td></tr>
            <tr><td>Address :</td><td>$address</td></tr>
            <tr><td>Message :</td><td>$message</td></tr>
            </table>";

            // echo $html;

        include('smtp/PHPMailerAutoload.php');
        $mail=new PHPMailer(true);
        $mail->isSMTP();
        $mail->Host="smtp.gmail.com";
        $mail->Port=587;
        $mail->SMTPSecure="tls";
        $mail->SMTPAuth=true;
        $mail->Username="kalpantpoddar420@gmail.com";
        $mail->Password="rqxpfjguixcglrxb";
        $mail->SetFrom("kalpantpoddar420@gmail.com");
        $mail->addAddress("kalpantpoddar420@gmail.com");
        $mail->IsHTML(true);
        $mail->Subject="New Room Booking Enquiry";
        $mail->Body=$html;
        $mail->SMTPOptions=array('ssl'=>array(
            'verify_peer'=>false,
            'verify_peer_name'=>false,
            'allow_self_signed'=>false
        ));
        if($mail->send()){
            echo "<script>alert('Thankyou for booking.');</script>";
        }else{
            echo "<script>alert('Booking mail not send.');</script>";
        }
    }
}

if(isset($_POST['tour_enquiry'])){
    $package = $_POST['package'];
    $name = $_POST['name'];
    $email = $_POST['email'];
    $phone = $_POST['phone'];
    $person = $_POST['person'];
    $child = $_POST['child'];
    $message = $_POST['message'];
    $date = $_POST['date'];
    $addon = date("Y/m/d");

    $insrt_item = "INSERT INTO tour_enquiry () VALUES('', '$date', '$package', '$name', '$phone', '$email', '$person', '$child', '$message', '$addon')";
    $run_enquiry = mysqli_query($conn, $insrt_item) or mysqli_error($conn);
    if ($run_enquiry) {
        echo "<script>alert('Thankyou! B2B Enquiry Submitted.');</script>";
        
        $html="<table>
            <tr><td colspan='2'><h3>Room Enquiry</h3></td></tr>
            <tr><td>Enquiry Date :</td><td>$date</td></tr>
            <tr><td>Room :</td><td>$$package</td></tr>
            <tr><td>Name :</td><td>$name</td></tr>
            <tr><td>Email :</td><td>$email</td></tr>
            <tr><td>Mobile No. :</td><td>$phone</td></tr>
            <tr><td>Message :</td><td>$message</td></tr>
            </table>";

            // echo $html;

        include('smtp/PHPMailerAutoload.php');
        $mail=new PHPMailer(true);
        $mail->isSMTP();
        $mail->Host="smtp.gmail.com";
        $mail->Port=587;
        $mail->SMTPSecure="tls";
        $mail->SMTPAuth=true;
        $mail->Username="kalpantpoddar420@gmail.com";
        $mail->Password="rqxpfjguixcglrxb";
        $mail->SetFrom("kalpantpoddar420@gmail.com");
        $mail->addAddress("kalpantpoddar420@gmail.com");
        $mail->IsHTML(true);
        $mail->Subject="New Room Booking Enquiry";
        $mail->Body=$html;
        $mail->SMTPOptions=array('ssl'=>array(
            'verify_peer'=>false,
            'verify_peer_name'=>false,
            'allow_self_signed'=>false
        ));
        if($mail->send()){
            echo "<script>alert('Thankyou for booking.');</script>";
        }else{
            echo "<script>alert('Booking mail not send.');</script>";
        }
    }
}

?>