1#@!#!123s

: / home3 / encodto1 / cholobanglay.com /
Filename : enquiry_submit.php
back
<?php include'config.php';
// error_reporting(0);
$html = "";

if (isset($_POST['action']) && $_POST['action'] == 'contact_enquiry') {
    $name = $_POST['name'];
    $email = $_POST['email'];
    if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
        echo "";
    }
    $phone = $_POST['phone'];
    $subject = $_POST['subject'];
    $message = $_POST['message'];
    $date = date('Y-m-d');
    // print_r($_POST);

    $insrt_contact = "INSERT INTO `contact_us`() VALUES ('','$name','$email','$phone','$subject','$message','$date')";
        $insrt_query = mysqli_query($conn, $insrt_contact) or die(mysqli_error($conn));
    if ($insrt_query) {
        echo "Contact inquiry submitted.";

        $html="<table>
        <tr><td colspan='2'><h3>Contact Enquiry</h3></td></tr>
        <tr><td>Name :</td><td>$name</td></tr>
        <tr><td>Email :</td><td>$email</td></tr>
        <tr><td>Mobile :</td><td>$phone</td></tr>
        <tr><td>Subject :</td><td>$subject</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->SMTPSecure="tls";
        // $mail->Port=587;
        // $mail->SMTPAuth=true;
        // $mail->Username="kalpantpoddar420@gmail.com";
        // $mail->Password="rqxpfjguixcglrxb";
        // $mail->SetFrom("kalpant.k.poddar@gmail.com", "$company Contact Inquiry");
        // $mail->addAddress("kalpantpoddar420@gmail.com", "Contact Enquiry");
        // $mail->IsHTML(true);
        // $mail->Subject="New Contact Enquiry";
        // $mail->Body=$html;
        // $mail->SMTPOptions=array('ssl'=>array(
        //     'verify_peer'=>false,
        //     'verify_peer_name'=>false,
        //     'allow_self_signed'=>false
        // ));

        // if($mail->send()){
        //     echo "Enquiry mail send.";
        //     // echo '<script>window.history.go(-1)</script>';
        // }else{
        //     echo $mail->ErrorInfo;
        // }
    }
    else{ 
        echo "Contact inquiry did not submitted.";
        // echo '<script>alert("Contact inquiry did not submitted.")</script>';
    }
}

if (isset($_POST['action']) && $_POST['action'] == 'reservation_enquiry') {
    error_reporting(0);
    $name =  $_POST['name'];
    $phone =  $_POST['phone'];
    $person =  $_POST['person'];
    $purpose =  $_POST['purpose'];
    $row_date =  $_POST['date'];
    $date = date("Y-m-d", strtotime($row_date));

    $time =  $_POST['time'];
    $message =  $_POST['message'];
    $addon = date('Y-m-d');
    // $arr = array($name, $location, $phone,$address,$city,$state,$pin,$product,$category, $date);
    // pr($arr);


        echo $insrt_ordr = "INSERT INTO special_reservation() VALUES('','$date','$time','$name','$phone','$purpose','$person','$message','$addon')";
        $query_ordr = mysqli_query($conn, $insrt_ordr) or mysqli_error($conn);
        if($query_ordr){
            echo "New reservation booking is successful."; 
        }else{
            echo "Your reservation booking failed.".mysqli_error($conn);
        }
        
    // if ($query_ordr) {
    //     echo "Costomer ".$name." submitted.";
    //     $html="<table>
    //     <tr><td colspan='2'><h3>New Customer Registered.</h3></td></tr>
    //     <tr><td>Name :</td><td>$name</td></tr>
    //     <tr><td>Email :</td><td>$email</td></tr>
    //     <tr><td>Mobile :</td><td>$phone</td></tr>
    //     </table>";
    //     // echo $html;
    
    //     include('smtp/PHPMailerAutoload.php');
    //     $mail=new PHPMailer(true);
    //     $mail->isSMTP();
    //     $mail->Host="smtp.gmail.com";
    //     $mail->SMTPSecure="tls";
    //     $mail->Port=587;
    //     $mail->SMTPAuth=true;
    //     $mail->Username="kalpantpoddar420@gmail.com";
    //     $mail->Password="rqxpfjguixcglrxb";
    //     $mail->SetFrom("kalpant.k.poddar@gmail.com", "ICP Customer Registration");
    //     $mail->addAddress("kalpantpoddar420@gmail.com", "New Customer Registration");
    //     $mail->IsHTML(true);
    //     $mail->Subject="New Customer Registration.";
    //     $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('Order Booking mail send.');</script>";
    //         echo '<script> window.location.href = "login";</script>';
    //     }else{
    //         echo $mail->ErrorInfo;
    //     }
    //     echo "Your order booked.";
    // }else{
    //     echo "Your order booking failed.";
    // }
}


?>