Jump to content
Larry Ullman's Book Forums


  • Content Count

  • Joined

  • Last visited

  • Days Won


zhaopeterson last won the day on October 21 2011

zhaopeterson had the most liked content!

Community Reputation

1 Neutral

About zhaopeterson

  • Rank
  1. sorry Silver I could not be any more help on this. I use Window 7 and downloaded xampp1.7.7. I have not done any other configuration on SSL (it came enabled as is, thank God it worked as I will not know how to figure out how). I am also a beginner, looks like you know more about this. I do have my own remove server with Lunarpages.com, they installed SSL for me so saved me headaches. The checkout.php worked on Firefox, Chrome and Opera (they all give out security warnings I just click proceed), for IE 9 I did what I mentioned above, that is it. Did you at least get it work in Firefox? Is it a browser related issue? P.S. I am a UI designer, I am more a HTML/CSS people, I know some programming php/mysql bare enough to get through the book, that is it. I am trying to read on xampp forum to understand those configuration stuff more, I saw you were there too, good luck.
  2. Hi, Silver: After I seen your post I tried to test the site (I installed xampp 1.7.7. on window 7) and similar problem you had. The IE9 says it has trouble accessing this site along with the note. •If this is an HTTPS (secure) address, click Tools, click Internet Options, click Advanced, and check to be sure the SSL and TLS protocols are enabled under the security section. So I went to my IE 9 tool bar clicked "Internet Options" then a dialog box came up, I clicked the advanced tab, I checked all the following under the security section: use SSL 2.0 (I checked on this) use SSL 3.0 (it was the default already checked) use TLS1.0 (it was the default already checked) use TLS1.1 (I checked on this) use TLS1.2 (I checked on this) Then I restarted IE9, it worked (I can see the coffee site and was able to check out) on localhost. My IE address bar still have red highlight says "certificate error", however I just ignor it as I know this is probably has something to do with XAMPP setting. I will post questions on Apache (xampp) forum later. However I think going to IE security setting is the way to get around that. Hope it helps. P. S. I did load the scripts to my own SSL enabled remove server (with Lunarpages). The scripts worked fine in IE.
  3. Hi, Larry: On page 170 when you define orders and order_contents you used "innoDB" engine as you indicated on page 172 InnoDB supports transaction. I downloaded your sql.sql file (inside ex2) a week or so ago and realized the "orders" and "order_contents" were defined as MyISAM Here is copy/paste from your sql file CREATE TABLE `orders` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `customer_id` int(10) unsigned NOT NULL, `total` decimal(7,2) unsigned DEFAULT NULL, `shipping` decimal(5,2) unsigned NOT NULL, `credit_card_number` mediumint(4) unsigned NOT NULL, `order_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `order_date` (`order_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `order_contents` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `order_id` int(10) unsigned NOT NULL, `product_type` enum('coffee','other','sale') DEFAULT NULL, `product_id` mediumint(8) unsigned NOT NULL, `quantity` tinyint(3) unsigned NOT NULL, `price_per` decimal(5,2) unsigned NOT NULL, `ship_date` date DEFAULT NULL, PRIMARY KEY (`id`), KEY `ship_date` (`ship_date`), KEY `product_type` (`product_type`,`product_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; Was it an error on the sql file or some updates I missed reading? Thanks, Brooke
  4. If it comes with XAMPP, it'd be in the PHP/ext directory, named php_curl.dll. See these instructions for enabling support: http://curl.haxx.se/...hp/install.html Thanks for point out this which was very helpful. It turned out CURL did come with my version of XAMPP 1.7.7, all I need to do was uncomment it in php.ini to activate it.
  5. Hi, Larry and everyone: Thanks for setting up this forum which is really helpful. I am on page 252, I checked my local installation of XAMPP (1.7.7) I used phpinfo() and it DOES not have "curl". My XAMPP does come with the default enable the SSL, after I typed in shipping information it gives an erorr: Fatal error: Call to undefined function curl_init() in C:\xampp\private\gateway_process.php on line 59 I am trying to download, I just want to make sure I download the right stuff (I am new to php development and programming in general") http://curl.haxx.se/dlwiz/?type=bin&os=Win64 Is the second link the right one to download? (I had problem downloading some other software then got virus infected my computer which had been pain) I have Window7 so I choose win64 right? In the book it says "if your PHP installation does not support libcurl, you can have PHP invoke the command-line cURL application via the exec() function: exec('curl<arguments>', $response); I do not get this, where do you type in "exec('curl<arguments>', $response);" , in the php.ini file or the libcurl I will download? Thanks, Brooke
  6. Jonathan: Thank you for your post on DW setting, it really helped me too! Brooke
  7. Hi, Larry: Big fan of you! Bought two of your books PHP 6 and Mysql5 (isbn9780321525994) (not sure which addition as it does not seems to say in the book) and Effortless e-commerce recently trying to learn php and mysql. I love the scripts in the book, well written and easy to understand by a beginner. I feel I am learning a lot. Having trouble to import the sql_utf8.sql file to my local XAMPP, seems you have lots of databases in this file. I am trying to do chap 15 message board, is there a single sql for that chapter I can download?! My XAMPP has many practice databases, I get constant error messages of importing your big sql_utf8.sql as some of the database names are already used. I really appreciate if you can send me a sql for chapter15 Brooke
  • Create New...