GeoffreyETD

HartleySan & Larry - with especial apologies to Larry! I think I jumbled your separate replies, attributing them both to HartleySan. Guess I shouldn't work so late! Re. Larry's point: "The problem is that your site is in a subfolder: localhost/_LUecommerce2/html/, not just localhost. You've should have absolute references to the images, links, and CSS (which is required with the mod_rewrite), but your references probably don't start with /_LUecommerce2/html/." If I understand that correctly, it means that I have either to put only my (aquasilver.ca) site files into xampp/htdocs/, hence being unable to use xampp for anything else, or to figure out how to fully qualify all the other stuff that needs qualifying, which I think is beyond me at this point. I guess I could move the ecommerce sites elsewhere on my system to study, in conjunction with using the ecommerce websites at dmcinsights.com to see how the code actually works in practice. That would be quite a workable solution but leaves me having to use xampp for only one test site (e.g. aquasilver.ca) at a time (acceptable I guess but not desired). Did I get this right? Re. Dreamweaver, I think I'm already weaning off it. NotePad++ seems to work well, or would you suggest something else? Re. aquasilver.ca, I agree it's not chic or modern. I had trouble communicating with my wife who came up with the graphic parts! Re. my choice of how to proceed with getting Larry's code working on it, I'll continue pondering the options a bit. Re: using Stripe for the payment method, I actually got quite enthusiastic about it a few weeks ago and so I was excited to hear that you (Larry) are getting involved there. Will you be coming up with tips on how to use it instead of PayPal and Authorize.net in your ecommerce sites? Thanks again, and I greatly appreciate your kindness in helping people like me!

HartleySan: I understand that Windows allows either way, and indeed your suggestion made no difference, but thanks. I had mentioned that that configuration worked fine for me with Larry Ullman's ecommerce1 site (Knowledge is Power). Looking at your second point, I think that must be the explanation, and I'll dig into it. Thanks! Re. what it's all about: I'm simply trying to get Larry's e-commerce (per his Effortless E-Commerce book) working under xampp on my PC so that I can get to learn from them. I have the Knowledge is Power site working fine, but t would be nice to have the Coffee site working as well, since it contains functions I need to acquire skills in. My desire to learn this stuff is to use it on a website that I already have working (aquasilver.ca) but lacking e-commerce capabilities such as a decent, flexible shopping cart and Authorize.net e-payments (plus member log-in and possible also PayPal eventually). I had PayPal working OK but found its shopping cart totally inadequate for my needs, then eventually discovered Larry's book, etc. and figured it would be my fastest route to doing what's needed (plus helping me get smart enough to do some other web projects I want to pursue). I'm currently wrestling with the BIG question whether to (A) keep my existing aquasilver.ca site structure more or less as it is and somehow add Larry's techniques into it, or ('B') start fresh with a total copy of Larry's Coffee site in place of aquasilver.ca then somehow slide my aquasilver stuff into it, replacing the Coffee look and feel where applicable. My existing site structure is VERY different from Larry's Coffee site so my head is spinning over this question. My intuition tells me that the "B" option would be best, though I have nothing concrete to back that idea up! Since I'm accustomed to working with Dreamweaver, I would be doing one or the other of these two options within an aquasilverTEST folder in c:/xampp/htdocs (as well as in my "local" folders on my D: drive, of course), side by side with my existing regular aquasilver folder in the same places. I use NotePad++ also, as appropriate and convenient. Any assistance towards resolving this question would be extremely welcome, since both these options look rather intimidating to me at the mo! I'm sure there must be a wisdom-based choice better than what would happen if I tossed a coin to resolve it or just went on my intuition. Thanks!

Thx again, Edward, and HartleySan! I was premature in thinking the Coffee site would emerge in its full glory! After setting up the db (carefully, after reading Larry's instructions after first trying without), the site "works" in that it comes up in browsers without error messages, but it's not displaying everything correctly. Here's what it looks like: [NOTE: When trying to post this, later, I got a message, "trying to post more images than allowed" - so I've replaced some or all with text describing them.] -------------actually 4 of these, for index, cart, contact and sitemap CoffeeWouldn't you love a cup right now? Coffee ------------actually 5, for Coffee, Goodies, Sales, Wish List and Cart Sale Items -------------actually 2 of them listed below this line Welcome to Our Online Coffee House!We're so glad you made it. Have a seat. Let me get you a fresh, hot cup o' Joe. Cream and sugar? There you go. Please use the links at the top to browse through our catalog. If you've been here before, you can find things you bookmarked by clicking on your Wish List and Cart links. About Clever Coffee, Inc.Clever Coffee, Inc. has been selling coffee online since 1923. For years, Clever Coffee, Inc. failed to make a profit, due to the lack of computers and the Internet. Yadda, yadda, yadda. It's safe to shop here, promise! © - Clever Coffee, Inc. Site designed by: Templates.com I guess it's not finding the various objects that are showing up here improperly (or improperly not showing up?). In case it's my config.inc.php location settings, which are working fine like this for the ecommerce1 site, these are: define ('BASE_URI', 'C:/xampp/htdocs/_LUecommerce2/'); define ('BASE_URL', 'localhost/_LUecommerce2/html/'); define ('MYSQL', BASE_URI . 'mysql.inc.php'); Again, I look forward to your helpful suggestions, with appreciation!

Thanks again, Edward! I've just spent a few million seconds rereading your comments, rechecking my stuff, slightly simplifying my file names, comparing, testing, scratching, etc., and finally have success with the KIP site. What worked in the config.inc.php file is this: // Determine location of files and the URL of the site: define ('BASE_URI', 'C:/xampp/htdocs/_LUecommerce1/'); define ('BASE_URL', 'localhost/_LUecommerce1/html/'); define ('PDFS_DIR', BASE_URI . 'pdfs/'); // Added in Chapter 5. define ('MYSQL', BASE_URI . 'mysql.inc.php'); It works in the Coffee one also (substituting "2" for "1") except that I haven't created and populated the db yet. Will do it in the morning and am hopefully not overly confidently assuming it will come through with Larry's coffee sampler site! Thx again, I really appreciate your help and encouragement to battle through it! btw: how do you get those cute boxes in, with the colored text so nicely in place?

Thanks Edward and Larry! Larry - I will definitely be trying to educate myself on PHP (particularly) and MySQL (already somewhat familiar). Edward: Yes, my "base-site" in Dreamweaver is on my D: drive, and my "test-site" is on my C: drive in xampp/htdocs/, so I think I have that all set up fine. I did try your suggestions (other than the last one) and they did not resolve the issue. Could there be a problem with the PEAR thing (can't get any information as to what php/PEAR is all about, so any elucidation would be most appreciated). After all, the very last part of the error message says: "Fatal error: require(): Failed opening required '/C:/xampp/htdocs/_LUecommerce1test/mysql.inc.php' (include_path='.;C:\xampp\php\PEAR')" Seems to me that it could have something to do with PEAR, otherwise the script wouldn't have run far enough to bring up a message referring to it, no? I'm guessing, of course, but it does seem suspicious.

An error occurred in script 'C:\xampp\htdocs\_LUecommerce1test\html\index.php' on line 15: require(/C:/xampp/htdocs/_LUecommerce1test/mysql.inc.php): failed to open stream: Invalid argument Fatal error: require(): Failed opening required '/C:/xampp/htdocs/_LUecommerce1test/mysql.inc.php' (include_path='.;C:\xampp\php\PEAR') This is happening when I try to run index.php per Item-8 "Test the result" on page 71. I'm using Dreamweaver F12 to run it. Here are the final lines of the spacious backtrace printout on the browser: [1] => Array ( [file] => C:\xampp\htdocs\_LUecommerce1test\html\index.php [line] => 15 [function] => require ) ) I'm new to this type of programming so I sure hope someone can help me figure it out! Thanks in advance! - GeoffreyETD