Todd.M

In the template.html, line 46 refers to the recommendations.php file and includes a link. Viewing the site in a browser it shows up under the Manage Your Account. I would like to use this as dynamic recommendation section.

I have no idea if this topic has been answered before but; I have not been able to locate the recommendations php in either the book or the site. Am I just missing it? If so, where is the description and code?

Hi Lou22, Just for future reference, if you want to get the most out of designing a database (as with any other programming language) I would recommend that you code it by hand. Just means to type in the structure of the DB and/or Table. You can do this by going to phpMyAdmin > select the SQL tab and type the code into the white box. This is the interface for MySQL Database design. Hope this helps you, Todd

Hello Alexander, The best way (from Apple) is to run what is called a redundant server configuration. It just means that one machine is the main server and it will automatically update all other systems with the data that has changed. You would be able to set what folders, files and when it should propagate. as well this is the best way regardless with multiple servers so that when one fails the next server in line will take its place. Business.Apple.com has pdf's explaining this in not so techie terms and is easy to read. Hope this helps, Todd

So ZEND it is, Thank Larry. The stationary is set to a pdf file type, including the LOGO, TAG LINE and ADDRESS at the bottom. Using the Zend Framework I can modify the pdf to include the purchase information. To make this happen it need to be set as a txt document then appended to the org pdf. Thanks again for the books and the pointers!! Todd

That's a good question, I think Larry or Jonathon (as both have been very helpful to me) would be able to write a sub-script that would re-read or re-set the session to update what information is reading so that the end user would not have to log out and then back in. But on the other hand, I have been to several sites that require the user to log out and then back in after the transaction.

In the Updating the Registration Page the login information is set via: $_SESSION['use_reg_id'] = $uid and the query just before that line finishes with: VALUE('u','$e','" . get_password_hash($p). "', '$fn','ln',SUBDATE(NOW(),INTERVAL 1 DAY))"; this sets the expiration to 24 hours ago. It technically ends the session. After the update from PAYPAL you would need to log out and then log in again to re-set the session so that it reads the new information from the database. This is a function and not a bug. You may try to just refresh the page but i'm thinking that this would not re-set the session. Hope this helps Todd

BTW, This line was rewritten in the ipn_log.php as: $uid = (int) $_POST['custom']; hope this helps you understand it a little better. Todd

Let me see if I can get close. The line I think you are looking at is: $uid = (isset($_POST['custom'])) ? (int) $_POST['custom'] : 0; This is part of a conditional execution of IF statements requesting whether or not the transaction_id in the orders table has changed starting with: if (mysqli_num_rows ($r) ==0 { If this statement is TRUE then it will execute the statement that you are asking about. The $uid is set in register.php script for the PAYPAL link and form. the ipn.php script reuses that same $uid. The question mark is being used as a transitional qualifier to verify that the $uid is an integer. The : 0; in that statement is a TRUE/FALSE (as in Zero and One) remark. If this is close then the $_POST will be placing an integer in the orders table, not the zero. Checking the $uid > 0 happens after this step then is set to update the users table if TRUE and trigger_error if FALSE. Hope this helps a bit. Todd

This would help me out as well. My thoughts on this is that the php is handling the transactions and the tables are handling the information storage so setting the ENGINE=MyISAM will work correctly. (reading for PHP 6 & MySQL 5 ver3, and Effortless E-Commerce) Todd

Just a question so I can understand better (this my just show off my Newbie status:), In the cart.php you have: if (mysqli_num_rows($r) >= 1) { // Products to show! In the wishlist.php you have: if (mysqli_num_rows($r) > 0) { // Products to show! NOTE: (mysqli_num_rows($r) > 0) in the Product show line? Wouldn't it be a more correct statement if written with '>= 1'?

Hello Larry et al. I know that the receipt.php script is not written in the book. So I'll ask here. Being new to this and working my way through (more like hacking/hashing my way through), PHP has PDFlib functions some have been deprecated but there should be a way to create a sales receipt that you could place LOGO (shop stationary), ORDER NUMBER, ITEMS ORDERED, COST (each), COST (total), CARD (last 4), FOOTER (address of store or a coupon good for next purchase (image) amongst a few other items. This could be placed into it's own table for reference as well as be printed by the customer. As I would like to try to create this on my own, could you just let me 1) know if it's possible, 2) am I on the right track with PDFlib and 3) would it be worth my time as the receipt could be past to an html file using a css to define it's look... Thanks, this is my second time around reading your book Larry Todd

I would like to add two things (maybe this isn't the place, let me know) that the people that who pick up your books without the background are the hard core knowledgologists that know your teaching is far better then most, THANK YOU. Second: using the command line is the easiest way to get around MySQL. What I found helpful is this 1) in windows 7 goto START > CONTROL PANEL > SYSTEM > ADVANCED SYSTEM SETTINGS (on the left): Select the Advanced tab, Select Environment Variables... Under User variables for %Name%, Select New. Under Variable Name, type: MySQL Under Variable Value, type: C:\XAMPP\mysql\bin\mysql.exe Select OK (2x's) Then, go to START and type in CMD In the command window type in: %mysql% –h localhost –u root -p (Yes, include the percent signs.) Type in your password and continue from there. For reference: download the PDF (3752p.) refman-5.5-en located at: http://dev.mysql.com/doc/ Refer to chapter 3: Tutorial Hope this helps other Newbies, just like me:)

Disregard the last post, as it is above the root, thx

Thanks to both of you. I found the answer, funny, in PHP 6 and MySQL 5 by none other then Larry Ullman (I know I've heard that name somewhere?!). ok that said, i've have just downloaded the zip's for comparison to what i've scripted and the includes > 'mysql.inc.php' file does not appear to be in the zip folder. did i miss something or should i just keep reading? Jonathon, you are correct. DW Site setup needs to be pointed into the htdocs\* site name* with the reference set to site root for the correct location when sent to server. Give me 4 months and i'll be able to answer questions like a pro, well almost:) using; -Dreamweaver 5.5 (latest ver.) -XAMPP 1.7.7 (latest ver.)