Ryan R Posted August 23, 2011 Share Posted August 23, 2011 Hi all, The book "effortless e-commerce" said that email_receipt.php file will be described in a few page. But I don't see the file anywhere in this book. I found the php file from download. I linked this file to final.php and executed. There was an error msg as soon as I executed it. To clarify where the error was coming from, I excluded the email_receipt.php file and executed it. And it worked well. I am attaching the file codes here below: The error line is in bold. The error msg is: "An error occurred in script 'C:\xampp\htdocs\includes\email_receipt.php' on line 25: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given" ------------------------------------------------------------------------------------------------ <?php // This script sends a receipt out in HTML format. // This script is created in Chapter 10. // Create the message body in two formats: $body_plain = "Thank you for your order. Your order number is {$_SESSION['order_id']}. All orders are processed on the next business day. You will be contacted in case of any delays.\n\n"; $body_html = '<html><head><style type="text/css" media="all"> body {font-family:Tahoma, Geneva, sans-serif; font-size:100%; line-height:.875em; color:#70635b;} </style></head><body> <p>Thank you for your order. Your order number is ' . $_SESSION['order_id'] . '. All orders are processed on the next business day. You will be contacted in case of any delays.</p> <table border="0" cellspacing="8" cellpadding="6"> <tr> <th align="center">Item</th> <th align="center">Quantity</th> <th align="right">Price</th> <th align="right">Subtotal</th> </tr>'; // Get the cart contents for the confirmation email: $r = mysqli_query($dbc, "CALL get_order_contents({$_SESSION['order_id']})"); // Fetch each product: while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) { // Add to the plain version: $body_plain .= "{$row['category']}::{$row['name']} ({$row['quantity']}) @ \${$row['price_per']} each: $" . $row['subtotal'] . "\n"; // Add to the HTML: $body_html .= '<tr><td>' . $row['category'] . '::' . $row['name'] . '</td> <td align="center">' . $row['quantity'] . '</td> <td align="right">$' . $row['price_per'] . '</td> <td align="right">$' . $row['subtotal'] . '</td> </tr> '; // For reference after the loop: $shipping = $row['shipping']; $total = $row['total']; } // End of WHILE loop. // Clear the stored procedure results: mysqli_next_result($dbc); // Add the shipping: $body_html .= '<tr> <td colspan="2"> </td><th align="right">Shipping & Handling</th> <td align="right">$' . $shipping . '</td> </tr> '; $body_plain .= "Shipping & Handling: \$$shipping\n"; // Add the total: $body_plain .= "Total: \$$total\n"; $body_html .= '<tr> <td colspan="2"> </td><th align="right">Total</th> <td align="right">$' . $total . '</td> </tr> '; // Complete the HTML body: $body_html .= '</table></body></html>'; // For Zend: set_include_path('./library/'); // Include the class definition: include ('Zend/Mail.php'); // Create a new mail: $mail = new Zend_Mail(); $mail->setFrom('admin@example.com'); $mail->addTo($_SESSION['email']); $mail->setSubject("Order #{$_SESSION['order_id']} at the Coffee Site"); $mail->setBodyText($body_plain); $mail->setBodyHtml($body_html); $mail->send(); -------------------------------------------------------------------------------- I tested it with disabling email parts by commenting them. I thought it might cause issues. But it was nothing to do with it. Thanks for your help and look forward to hearing from you soon. Link to comment Share on other sites More sharing options...
Larry Posted August 24, 2011 Share Posted August 24, 2011 Sorry about that. Those pages had to be cut out at the last minute. But the content can be found in a PDF you can download here: http://www.larryullman.com/2010/11/11/“effortless-e-commerce-with-php-and-mysql”-chapter-10-bonus-pages/ That error, though, always means that the query didn't work (as in wasn't executable). Link to comment Share on other sites More sharing options...
Ryan R Posted August 24, 2011 Author Share Posted August 24, 2011 Thanks for your info. I know that it means query didn't work. Strangely, all other stored procedure queries worked but only this query didn't work. I tested this query on final.html file by creating simple codes just under the paragragh: ------------------------------------------------------------- <?php // Get the cart contents for the confirmation email: $r = mysqli_query($dbc, "CALL get_order_contents({$_SESSION['order_id']})"); // Fetch each product: while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) { echo 'Per price is '.$row['price_per'].'and you ordered '.$row['quantity'].'.'; } // End of WHILE loop. ?> ----------------------------------------------------- Surprisingly, it worked ok. That's really odd and don't understand.. There must be something else causing the problem.. Can you help me with this issue? Link to comment Share on other sites More sharing options...
Larry Posted August 24, 2011 Share Posted August 24, 2011 If you know that it means the query didn't work, then I assume you know that you'll need to apply the standard PHP-MYSQL debugging techniques to find out WHY it didn't work. Link to comment Share on other sites More sharing options...
Recommended Posts