if(!isset($_SESSION)){
session_start();
}
require_once('Connections/connbenico.php');?>
include_once("include/function.php");
//取出資料#########################################
if(isset($_SESSION['inq_session'])){
mysql_select_db($database_connbenico, $connbenico);
$query_inq = sprintf("SELECT * FROM tbinquiry inq LEFT JOIN tbpd pd ON inq.inq_pid = pd.p_id WHERE inq_session = %s", GetSQLValueString($_SESSION['inq_session'], "int"));
$inq = mysql_query($query_inq, $connbenico) or die(mysql_error());
$row_inq = mysql_fetch_assoc($inq);
$totalRows_inq = mysql_num_rows($inq);
mysql_select_db($database_connbenico, $connbenico);
$query_inqList = sprintf("SELECT * FROM tbinquiry inq LEFT JOIN tbpd pd ON inq.inq_pid = pd.p_id WHERE inq_session = %s", GetSQLValueString($_SESSION['inq_session'], "int"));
$inqList = mysql_query($query_inqList, $connbenico) or die(mysql_error());
$row_inqList = mysql_fetch_assoc($inqList);
}
//設定頁面標題
$page_title="Contact Us";
?>
//處理寄送mail
if ((isset($_POST["action"])) && ($_POST["action"] == "contact123")) {
//取出寄送的EMAIL LIST####################################################################
mysql_select_db($database_connbenico, $connbenico);
$query_mb = "SELECT * FROM tbmailBox WHERE mb_id = 1";
$mb = mysql_query($query_mb, $connbenico) or die(mysql_error());
$row_mb = mysql_fetch_assoc($mb);
$totalRows_mb = mysql_num_rows($mb);
//##########################################################################
$mb_array=$row_mb['mb_mail'];
$mb_array=explode(",",$mb_array);
$count_mb = count($mb_array);
include("PHPMailer/class.phpmailer.php"); //匯入PHPMailer類別
$mail= new PHPMailer(); //建立新物件
$mail->IsSMTP(); //設定使用SMTP方式寄信
$mail->SMTPAuth = true; //設定SMTP需要驗證
$mail->SMTPSecure = "ssl"; // Gmail的SMTP主機需要使用SSL連線
$mail->Host = "smtp.gmail.com"; //Gamil的SMTP主機
$mail->Port = 465; //Gamil的SMTP主機的SMTP埠位為465埠。
$mail->CharSet = "utf-8"; //設定郵件編碼
$mail->Username = "benicotw@gmail.com"; //設定驗證帳號
$mail->Password = "benicotw168!^*"; //設定驗證密碼
$mail->From = "service@benico.com.tw"; //設定寄件者信箱
$mail->FromName = "Benico Admin"; //設定寄件者姓名
$mail->Subject = "來自Benico的聯繫訊息!"; //設定郵件標題
$mail->Body = nl2br('訊息內容如下:
* First Name:'.$_POST['First'].'
* Last Name:'.$_POST['Last'].'
* Company:'.$_POST['Company'].'
Title:'.$_POST['Title'].'
* E-Mail:'.$_POST['E-Mail'].'
Phone Number:'.$_POST['Phone Number'].'
* Country:'.$_POST['Country'].'
Address:'.$_POST['Address'].'
City:'.$_POST['City'].'
State:'.$_POST['State'].'
Zip Code:'.$_POST['Zip'].'
Website:'.$_POST['Website'].'
Comments:'.$_POST['Comments'].'
時間:'.date("Y-m-d H:i:s").'
IP:'. $_SERVER["REMOTE_ADDR"].'
詢價清單:
'
. $_POST['inqlist'].'
'); //設定郵件內容
$mail->IsHTML(true); //設定郵件內容為HTML
//迴圈
for($i=0;$i<=$count_mb;$i++){
$mail->AddAddress($mb_array[$i]); //設定收件者郵件及名稱
}
if(!$mail->Send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
}
//刪除詢價單session
unset($_SESSION['inq_session']);
//setcookie("inq_session", "", time()-3600);
$url = "index.php";
echo "";
exit;
}
?>