banner
歡迎光臨迷你植物的店,最特別的手機吊飾。

ToyTree迷你植物的店訂單查詢&問題回報區

親愛的顧客您好~您的訂單狀況如下:

"); //echo $qpid."看看
"; //Database define('DB_USER', 'fateigei_toytree'); define('DB_PASSWORD', 'S2SL[wCUtMep'); define('DB_HOST', 'localhost:3306'); define('DB_DATABASE', 'fateigei_toytree'); /* 連接資料庫 */ $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('無法連接到資料庫:'.mysql_error()); mysql_query("SET NAMES 'utf8'"); /* 選用資料庫 */ mysql_select_db(DB_DATABASE,$link)or die('無法連接到資料庫:'.mysql_error()); /* 執行查詢 */ $sql = "SELECT * FROM orderlist WHERE pid = '$qpid' AND name = '$qname'"; $result = mysql_query($sql) or die('錯誤'); $row = mysql_fetch_row($result); //print_r($row); if($row[0]==$qpid){ echo "訂單編號:".$keyinpid."
"; echo "訂購時間:".$row[14]."
"; echo "訂購商品:".$row[5]."
"; if(strlen($row[2])==0){ echo "處理進度:準備出貨中~請您安心等待
"; }else{ echo "處理進度:".$row[2]."
"; } $qnum =$row[13]+1; $sql = "UPDATE orderlist SET qnum ='$qnum' WHERE pid = '$qpid' AND name = '$qname'"; mysql_query($sql) or die('無法執行'); }else{ echo "很抱歉,我們無法查詢到您的訂單,請確認[收貨人姓名]與[訂單編號]無誤,或至下方反映您的問題,將由客服為您處理~"; } mysql_close($link); } else if(isset($_POST["Submit"])){ $name = $_POST["name"]; $email = $_POST["email"]; $category = $_POST["category"]; $comment = $_POST["content"]; //date_default_timezone_set("Asia/Taipei"); $time = date("Y年m月d日 星期w h:i:s a",strtotime("+15 hours")); print ("

親愛的 "); print ($name); print (" 顧客您好,我們已經收到您的問題,我們將迅速為您處理。

如果您使用免費信箱(如yahoo,pchome),為了確保您能收到我們的回覆信,請將service@toytree.dodozoo.com加入你的好友名單~"); $header = 'MIME-Version: 1.0' . "\r\n"; $header .= 'Content-type: text/plain; charset="utf-8"'."\r\n"; $header1 = $header."From: [ToyTree Q]\nReply-To: [ToyTree Q]\n"; $header .= "From: [ToyTree Store]迷你植物的店\nReply-To: [ToyTree Store]迷你植物的店\n"; $subject = "=?UTF-8?B?".base64_encode('[ToyTree.DoDoZoo.com] Question Submit確認信')."?="; //$subject = "[ToyTree]迷你植物吊飾問題反映確認信"; $subject1 = "[ToyTree]問題反映 --- ".$category; $mail = "親愛的 ".$name." 您好:

"; $mail .= "我們已收到您有關於: [".$category."] 的問題
"; $mail .= "我們將會迅速處理並回覆您~

"; $mail .= "ToyTree迷你植物的店祝您事事順心~

"; $mail .= "P.S 本信件僅作為確認之用,請勿直接回復,如有任何問題
"; $mail .= "請至 http://toytree.dodozoo.com/contact.php

"; $mail .= "ToyTree網址: http://toytree.dodozoo.com"; // If any lines are larger than 70 characters, we will use wordwrap() $mail1 = "ToyTree迷你植物的店,請您查看客戶反映的問題:
"; $mail1 .= "問題內容如下
"; $mail1 .= "提問人: ".$name."
"; $mail1 .= "電子郵件: ".$email."
"; $mail1 .= "問題種類: ".$category."

"; $mail1 .= "反映問題: ".$comment."
"; $mail = str_replace("
", "\n", $mail); $mail1 = str_replace("
", "\n", $mail1); // Send the email... mail($email, $subject, $mail, $header); mail("punkdodo@gmail.com", $subject1, $mail1, $header1); mail("bradchius@gmail.com", $subject1, $mail1, $header1); //Database define('DB_USER', 'richl1_tree'); define('DB_PASSWORD', '1234'); define('DB_HOST', 'localhost'); define('DB_DATABASE', 'richl1_minitree'); /* 連接資料庫 */ $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD) or die('無法連接到資料庫:'.mysql_error()); mysql_query("SET NAMES 'utf8'"); /* 選用資料庫 */ mysql_select_db(DB_DATABASE,$link)or die('無法連接到資料庫:'.mysql_error()); /* 執行查詢 */ $result = mysql_query("SELECT * FROM orderlist") or die('錯誤'); $num_rows = mysql_num_rows($result);//總共有幾筆訂單資料 // 定義 SQL 命令的字串變數 $pid = $num_rows + 1; $content = str_replace("
", "\n", $order); $sql = "insert into faq(pid, name, email, cate, qcontent, date) values('$pid','$name', '$email', '$category', '$comment','$time')"; // 開始執行查詢 mysql_query($sql,$link) || die('無法執行查詢: '.$sql); mysql_close($link); }else{ print ("

親愛的顧客您好~

如果有任何問題,請填寫您的問題,我們會迅速為您服務~

"); } ?>

訂單查詢:
收貨人姓名*
訂單編號*

 

問題反映區:
您的大名*
E-Mail:* (我們將回覆至您的信箱)
問題種類*
問題內容*

 

 

迷你植物的店關心大家