Jump to content
Larry Ullman's Book Forums

Stored Procedures Errors


Recommended Posts

I've got your first edition of Effortless E-Commerce with PHP and MySQL. I've downloaded the script files and installed into xampp. The first issue I've identified is that some stored procedures are missing. So far, get_shopping_cart_contents and get_wish_list_contents.

 

Looking in my phpMyAdmin, I can see 3 routines. None of them the same as the procedures I'm looking for. Are these routines the same as stored procedures?

 

Looking in the book I find code for get_shopping_cart_contents and 3 other procedures for the cart, so I presume I can create them in the database. However the procedure get_wish_list_contents can't be found in the book or errata. How do I get that info?

 

How much more information am I missing?

Link to comment
Share on other sites

Some versions of mysql doesn't support stored procedures. That might be your problem here. Larry also a wrote a post on how to change from stored procedures (they are a hassle, really) some time ago.

 

http://www.larryullman.com/2010/12/07/rewriting-the-e-commerce-stored-procedures-with-standard-php-mysql/

 

You said you used the first edition, but the same pricinple applies to your case too.

 

Edit: I might have found the same article for the first book:

http://www.larryullman.com/2010/12/28/rewriting-the-e-commerce-stored-procedures-with-standard-php-mysql-3-chapter-10/

Link to comment
Share on other sites

 Share

×
×
  • Create New...