session_start(); require_once "utils/db_utils.php"; require_once "utils/string_utils.php"; require_once "utils/config.php"; require_once "utils/email_utils.php"; require_once "utils/file_utils.php"; if (!isset($con)) $con = db_connect(); $email_template = "email_askexpert_template.html"; $error_code = -1; if ($_SERVER['REQUEST_METHOD'] == "POST"){ $name = mysql_real_escape_string(trim($_POST["name"])); //$phone = mysql_real_escape_string(trim($_POST["phone"])); $email = mysql_real_escape_string(trim($_POST["email"])); $city = mysql_real_escape_string(trim($_POST["city"])); $state = mysql_real_escape_string(trim($_POST["state"])); $expertid = mysql_real_escape_string(trim($_POST["expertid"])); $query = mysql_real_escape_string(trim($_POST["query"])); $querytelugu = mysql_real_escape_string(trim($_POST["querytelugu"])); $querytext = (empty($querytelugu)) ? $query : $querytelugu; $language = $_POST["language"]; $check1 = "Y"; //if ($check1 != "Y") $check1 = "N"; $c_captcha = $_POST["c_captcha"]; $captcha_key = substr($_SESSION['captchakey'],0,6); if ($c_captcha != $captcha_key){ $error_str = "Verification code is not valid. Please try again"; if ($language == "t"){ ?> } } else{ $qry = "INSERT INTO Queries(UserName, UserEmail, UserCity, UserState, ExpertId, Query, SendEmail) VALUES('$name', '$email', '$city', '$state', '$expertid', '$querytext', '$check1')"; $res = mysql_query($qry) or die(mysql_error()); $question_id = mysql_insert_id(); $error_code = 0; //SEND THE EMAIL $from_email = $def_from_email; $to_email = $email; $subject = $name . ", your question has been submitted"; $unique_qid = $question_id * $query_multiplier; $email_body = read_file($email_template); $email_body = str_replace("##name##", $name, $email_body); $email_body = str_replace("##questionid##", $unique_qid, $email_body); phpmail($from_email, $to_email, $subject, $email_body, "html"); } } ?>
|
Your question has been successfully submitted. A unique Question ID has been emailed to you. You can search for the status of your question on our website using this unique Question ID. Our experts will soon post an answer to your question on our website. We will update you about the status of your question through email. |
|