Order

⃥KvҟAIԋX[AԋXA΃LElEEx@AѭBܧXwҟ]AISBN@ﭠ⻥Kv鲐Aխy[WubNZ[Ej[ Display Order IB

* ҟK{B
'0') { $list = array(); $ctgry = array(); while($row = mysql_fetch_array($result)) { $ctgry[] = $row['product_cat']; $list[$row['product_cat']]['product_title'][] = $row['product_title']; $list[$row['product_cat']]['product_item'][] = $row['product_item']; $list[$row['product_cat']]['product_price'][] = $row['product_price']; $list[$row['product_cat']]['product_isbn'][] = $row['product_isbn']; $list[$row['product_cat']]['product_vname'][] = $row['product_vname']; $list[$row['product_cat']]['product_id'][] = $row['product_id']; } $ctgry = array_unique($ctgry); $tab = 5; foreach($ctgry as $i => $ctgry_nm) { echo " "; foreach($list[$ctgry_nm]['product_id'] as $key => $value) { echo " "; $tabindex = $tab+1; echo " "; } echo ""; } mysql_free_result ($result); } ?>

qll

NCbNĹN

ҟqlAIԋXаMB

  

Ωy[WWv

*

R[XubN
sN`[fBNViĹ[
Үwp
[
tpĹ\[X

*

AhX *

XN[ /
䕳 *

ԋX

m?

ANV *

lĹ[YCOĹbVubNX
 

ĹXg
 

^Cg

i

*

" . $ctgry_nm . "

" . $list[$ctgry_nm]['product_title'][$key] . " " . $list[$ctgry_nm]['product_item'][$key] . "

߲" . $list[$ctgry_nm]['product_price'][$key] . "
 
 

 

 

Japanese English
 
'; if (isset($error)) { echo '

Order
'; } else { echo ''; $error = 'TRUE'; } if ($_POST['lname'] != '') { $_POST['lname'] = trim($_POST['lname']); $_POST['lname'] = ucfirst($_POST['lname']); echo ''; } else { echo ''; $error = 'TRUE'; } // take a given email address and split it into the username and domain. list($userName, $mailDomain) = split("@", $email); if (!checkdnsrr($mailDomain, "MX")) { echo ''; $error = 'TRUE'; } else if (!ereg("^..*\@.+\..+[A-Za-z0-9]$", $_POST['email'])) { echo ''; $error = 'TRUE'; } else echo ''; if ($_POST['company'] != '') { $_POST['company'] = trim($_POST['company']); $_POST['company'] = ucfirst($_POST['company']); echo ''; } else { echo ''; $error = 'TRUE'; } foreach($_POST as $key => $val) { if (($val > '0') && (is_numeric($val))) { if (ereg("([0-9])", $val)) { $new_array[$key] = $val; } } else { if ($val == '0') { $error_val = 'TRUE'; $error = 'TRUE'; } } } if ($error_val == 'TRUE') echo ''; if (count($new_array) == 0) { echo ''; $error = 'TRUE'; } echo '

:

'.(stripslashes($_POST['fname'])).'

Please enter your first name.

:

'.(stripslashes($_POST['lname'])).'

Please enter your last name.
There seems to be a problem with the email address you have submitted. Please go back and check.
Your email is not in the correct format. Please go back and check.

[AhX:

'.$_POST['email'].'

䕳:

'.(stripslashes($_POST['company'])).'

Please enter the organisation you represent.
0 is not a permitted quantity. Please go back and check.
Please enter a quantity for the product(s) you are interested in.



'; include("../includes/jpnav_floor.php"); echo '
'; include("../includes/jpcopyright.php"); echo'

 

 

 '; include("../includes/jpnav_level1.php"); echo'
'; } else { ?>   $val) { if (ereg("^x_", $key)) { if (!empty($val)) { $sql4 = " INSERT INTO qty( qty_rowid, qty_orderid, qty_item, qty_quantity) VALUES( '', '" . $orderid . "', '" . $key . "', '" . $val . "')"; $result4 = mysql_query($sql4); } } } echo '

ISBN

i/

' ; ob_start(); foreach($_POST as $key => $val) { if ($val != '') { $sql = " SELECT product_title, product_item, product_isbn, product_price FROM products WHERE product_vname='".$key."'"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { extract($row); echo "

".$product_isbn."

".$product_title." ".$product_item."

".$val."

߲".$product_price."\n

"; $itemdetails = ob_get_contents(); } mysql_free_result ($result); } } ob_end_flush(); $itemdetails = strip_tags($itemdetails); if ($_POST['bookseller'] == "jno") { echo "

 

Please print this out and take it with you to your local bookseller. If you have any problems finding our products, send us a message by visiting our Contact page at http://www.saxoncourtelt.com/pages/jpcontact.html.

"; } else { // send notification e-mail to owner // changethe $bookseller variable abb. to the full name and // select the correct bookseller to send the email to switch ($bookseller) { case "er": $mailbookseller = "The English Resource"; $to = "info@englishresource.co.jp"; break; default: $mailbookseller = "Nellie's English Books"; $to = "orders@nellies.jp"; break; } // define the subject line $subject = "Saxoncourt ELT Order Enquiry for " . $mailbookseller . " - Ordering Inside Japan"; // build the message string - note the concatenating full stops and the \n $msg = "This is an automated email from http://www.saxoncourtelt.com\n" . "The person below has requested to be contacted by " . $mailbookseller . " regarding the items listed.\n\n" . "Please contact the customer with regard to total price including shipping, applicable discounts and availability. If you have any queries concerning this email, please reply to: contact@saxoncourtelt.com\n\n" . "----------------------------------------\n\n" . "PERSONAL DETAILS\n" . "Name: " .(stripslashes($_POST['fname'])) . " " .(stripslashes($_POST['lname'])) . "\n" . "Company/School: " .(stripslashes($_POST['company'])) . "\n" . "Email: " .(stripslashes($_POST['email'])) . "\n\n" . "PRODUCT ENQUIRY\n" . "Each order enquiry has four parts.These are:\n" . "(1) ISBN (2) Product Title (3) Quantity Requested (4) Japan Retail Price/Item\n\n" . "" . $itemdetails . "\n\n" . "****************************************\n" . "(If you find you cannot view 'Yen prices per item' correctly, please alter the encoding settings for the email application you use. Change them to Windows(ISO-Latin 1). For Outlook Express this can be found in: View > Encoding > Windows(ISO-Latin 1).)"; // extra headers - important $headers = "From: contact@saxoncourtelt.com\nReply-To: contact@saxoncourtelt.comn\nBCC: contact@saxoncourtelt.com\nBCC: backup@saxoncourtelt.com"; // need this too, don't know quite why $config = "-fcontact@saxoncourtelt.com"; if (mail("$to", "$subject", "$msg", "$headers", "$config")) { echo "

 

Please print this message out for your records. The details above have been emailed to " . $mailbookseller . " who will contact you shortly. Thank you for your interest.

"; } else echo "

Unfortunately, your email could not be processed. Please email support@saxoncourtelt.com separately with your enquiry.

\n"; } ?>