File manager - Edit - /home/asiatechinc/public_html/asiatechinc-websites/dhyeyaprakashan.com/insert.phpbooking_id
Back
<?php $mysqli = mysqli_connect("localhost","asiatechinc_dhyeyaprakashan", "dhyeyaprakashan@321","asiatechinc_dhyeyaprakashan"); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } session_start(); if(isset($_POST)){ if(!empty($_POST["amount"]) && is_numeric($_POST["amount"])){ $_SESSION['booking_id'] = 'ACC'.date("ymd").round(microtime(true)); $_SESSION["name"] = $_POST["name"]; $email = $_POST["email"]; $_SESSION["mobile"] = $_POST["mobile"]; $_SESSION["address"] = $_POST["address"]; $_SESSION["amount"] = $_POST["amount"]; $_SESSION["city"] = $_POST["city"]; $sql = mysqli_query($mysqli,"INSERT INTO `payment`(`booking_id`, `name`, `email`, `mobile`,`address`, `amount`, `city`, `time`) VALUES ('".$_SESSION['booking_id']."','".$_POST["name"]."','".$_POST["email"]."','".$_POST["mobile"]."','".$_POST["address"]."','" .$_POST["amount"]."','" .$_POST["city"]."', '".date('Y-m-d H:i:s')."')"); $subject ="Payment from dhyeyaprakashan"; $to =$email; $headers = "From: dhyeyaprakashan <info@dhyeyaprakashan.in> \r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; $headers .= "CC: info@dhyeyaprakashan.in" . "\r\n"; $headers .= "BCC: support@asiatech.in" . "\r\n"; $email_content='<div style="border:3px solid 98bc6c; width:80%;display:block;margin: 0px auto;"> <div><span style="color:#00BAF2;font-size:20pt;border:3px solid 98bc6c;">Payment From dhyeyaprakashan Website</span> <table> <tr><td>Booking Id</td><td>'.$_SESSION['booking_id'].'</td></tr> <tr><td>Name</td><td>'.$_SESSION["name"].'</td></tr> <tr><td>Email Id</td><td>'.$email.'</td></tr> <tr><td>Mobile</td><td>'.$_SESSION["mobile"].'</td></tr> <tr><td>Amount</td><td>'.$_SESSION["amount"].'</td></tr> <tr><td>Message</td><td>'.$_SESSION["city"].'</td></tr> </table><br/>Regards<br/><a href="https://www.dhyeyaprakashan.in/">dhyeyaprakashan</a> </div></div>'; //echo $email_content; //mail($to, $subject, $email_content, $headers); if (mail($to, $subject, $email_content, $headers)){ echo "Thank You! Your Payment we have received.<br>"; echo "If you are not redirected yet <a href='https://www.dhyeyaprakashan.in/'>click here</a>."; echo '<script>window.location="https://www.dhyeyaprakashan.in/";</script>'; } else { echo "Oops! Something went wrong and we couldn't send your message."; } } }else { echo "There was a problem with your submission, please contact with AsiaTech Hotels."; } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.02 |
proxy
|
phpinfo
|
Settings