Example #1
0
} elseif ($_POST['recipients'] == 'feedback_1') {

    $feedback_input = nl2br(htmlentities($_POST['feedback_input_logged'], ENT_QUOTES, 'UTF-8'));
    $comp_id = $_POST['comp_id_logged'];
    $user_id = UserMail($_POST['user_id_logged']);
    $customer_name = getCompName($comp_id);


    $query = "INSERT INTO sohorepro_feedback
			SET     comp_id         = '" . $comp_id . "',
                                user_name       = '" . $user_id . "',
                                feedback        = '" . $feedback_input . "' ";

    $sql_result = mysql_query($query);
    $feedback_id = mysql_insert_id();
    $select_feedback = SelectFeedback($feedback_id);
    $user_details = GetUserDetails($select_feedback[0]['comp_id'], $select_feedback[0]['user_name']);
    $user_name = $user_details[0]['cus_fname'] . ' ' . $user_details[0]['cus_lname'];
    $user_email = $user_details[0]['cus_email'];
    $user_company = companyName($select_feedback[0]['comp_id']);

    $message .= '<div style="border:3px solid #FF7E00;">';
    $message .= '<table border="0" style="width:100%;">';

    $message .= '<tr>';
    $message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">Name</td>';
    $message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">:</td>';
    $message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;">' . $user_name . '</td>';
    $message .= '</tr>';

    $message .= '<tr>';
<?php
include './admin/config.php';
include './admin/db_connection.php';

$id              =  '12';
$select_feedback = SelectFeedback($id);
$user_details       = GetUserDetails($select_feedback[0]['comp_id'], $select_feedback[0]['user_name']);
$user_name          = $user_details[0]['cus_fname'].'&nbsp;'.$user_details[0]['cus_lname'];
$user_email         = $user_details[0]['cus_email']; 
$user_company       = companyName($select_feedback[0]['comp_id']);  

$message .= '<div style="border:3px solid #FF7E00;">';
$message .= '<table border="0" style="width:100%;">';

$message .= '<tr>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">Name</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">:</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;">'.$user_name.'</td>';
$message .= '</tr>';

$message .= '<tr>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">Email</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">:</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;">'.$user_email.'</td>';
$message .= '</tr>';

$message .= '<tr>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">Company</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;font-weight:bold;">:</td>';
$message .= '<td style="padding-top: 10px;padding-left: 10px;color:#000;">'.$user_company.'</td>';
$message .= '</tr>';