
100yen
Members-
Content Count
42 -
Joined
-
Last visited
-
Days Won
1
100yen last won the day on September 11 2013
100yen had the most liked content!
Community Reputation
2 NeutralAbout 100yen
-
Rank
Member
-
Hi, I run into trouble sending html email to hotmail and aol address using php mail() function. Gmail and Yahoo are fine. But hotmail and aol are failed to receive anything. Here is my header setting $headers = "From: sales@thtc-usa.com\r\n"; $headers .= "Reply-To: sales@thtc-usa.com\r\n"; $headers .= "Return-Path:sales@thtc-usa.com\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; any suggestion please?
-
Hi, I am reading this book at second time. At advance Event Handling section, I am confusing about the statement that describes 'return false' vs 'e.preventDefault()'. At page 290, Larry writes 'On any browser that supports the addEventListener() method, event handlers will automatically receive a single argument, which represents the event that occurred. I think the single argument is event object, right? At page 298, 'For browsers that don't support the addEventListener() method, an alternative way of preventing the default event behavior is to invoke the preventDefaut() method o
-
Hi, Larry. I am reading into chapter 2 or your Yii book. It's time to download the Yii application. The Yill download page offers Yii 1.14 or 2.0. The 2.0 is a complete rewrite and it's not compatible with 1.1. So which one should I download? thanks.
-
Combine Two Queries?
100yen replied to 100yen's topic in Effortless E-Commerce with PHP and MySQL (2nd Edition)
and here is the statement block that comes from the add_order procedure. It works to me, so post it as reference if (empty($billing_errors)) { $cc_exp = sprintf('%02d%d', $_POST['cc_exp_month'], $_POST['cc_exp_year']); // check for existing order ID in the session // to prevent double orders if (isset($_SESSION['order_id'])) { $order_id = $_SESSION['order_id']; $order_total = $_SESSION['order_total']; } else { // if no existing order ID, get the last four digitals of cc number $cc_las -
Combine Two Queries?
100yen replied to 100yen's topic in Effortless E-Commerce with PHP and MySQL (2nd Edition)
Hi, Antonio After reading your reply, I tested the script. As you said, the sql is wrong and it returns a message : Error Code: 1327. Undeclared variable: subtotal. So I adapter your method, replace the INTO with AS, and the script is fully functional now. Thank you very much for pointing out. -
Combine Two Queries?
100yen posted a topic in Effortless E-Commerce with PHP and MySQL (2nd Edition)
Hi, Larry In page 294. I try to break down the add_order procedure into separated piece since my shared host doesn't support routine. The problem lies in the last two statement. I believe the subtotal is a temporary column to store the result of quantity * price_per and then deal with the UPDATE statement that comes after. So, what's the best way to rewrite those two statements as normal sql query? I personally try to combine those two queries since they should work as one: $query = "UPDATE orders SET total=((SELECT SUM(quantity*price_per) INTO subtotal FROM order_contents WHE -
Hi, Larry. Here is update. I have applied for a dream host account and moved the tutorial project into the web host. So I can continue to follow the book. The question for now is that do I required to sign up for a security certificate as well? Because in the figure 6.9 you used https to redirect the user, can I just use normal http instead of https?
-
Hi, Larry. I stock in page 159 when I need to supply the 'cancel' and 'finish' URL after customer cancel or finish the transaction. Knowing that I work on this example store in my localhost mamp server, and I don't have SSL in the localhost server. What's the option under this situation? Can I supply http://localhost:8888/pdf_store/cancel.php ? or I will need to signup for a web host to do lesson in this chapter? Thank you