www.uburst.com www.uburst.com

"Mysql + Php + uShop (sorry i know this has been commented on a LOT)"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Programmer Tips
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Mysql + Php + uShop (sorry i know this has been commented on a LOT)"
Posted by Darryl Barney Jr on Aug-08-02 at 04:37 PM (EST)
Hello.

Let me give you some background info.. I just change departments in my office, and one of my main jobs is to update this website. Well, im done with everything BUT, the uShop. Someone else made it, and im going to be converting it into a php and mysql ran system. I use to code a bit in php, and mysql.. Im not GREAT, but i know whats going on and how to figure it all out.
This is the site: http://www.floridapathfinders.com/uShop/STORE/STOREindex.html

What is involved in doing this? What files would be needed to be edited? Would you recommend many tables inside the database to manage each section? Any help appreciated!! Thanks

Click to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

RE: Mysql + Php + uShop (sorry i kn..., Bill Weiner, Aug-09-02, (1)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "RE: Mysql + Php + uShop (sorry i know this has been commented on a LOT)"
Posted by Bill Weiner on Aug-09-02 at 04:01 AM (EST)
The key thing to remember is that the uShop Applets can be placed anywhere on any HTML page. So that means you can write your PHP such that it pulls the product data from your MySQL database and then generates the HTML pages with the uShop Applets on them.

Here are some other tips/notes that may help:

1) uShop has a variety of "Input" applets that can be used to add items to the shopping cart. You can see them in the applet reference at:

http://www.uburst.com/uShop/reference/applets.html

2) Note what product fields/parameters that the "Input" applets (mentioned above) have ... such as id, name, description, price, taxable, weight, etc... At a minimum, you would want your product database tables to contain those fields.

3) In your PHP, you'd probably want to make some subroutines for outputting the HTML needed for each "Input" applet you plan to use. For instance, I noticed your website uses the "uShopInput3" applet a lot, so a subroutine where you can pass it the product information from the database... and output the HTML for that applet would come in handy. Just call that subroutine as desired when generating the HTML for each page in your store.

4) Usually the recommended CODEBASE setting for the applets is:

codebase="../classes/"

However, when the HTML pages are dynamically being generated by something like PHP, it is often recommended to use the FULL URL of your "classes" directory as your CODEBASE setting. Such as:

codebase="http://www.yourdomain.com/classes/"

The codebase setting is described further at:

http://www.uburst.com/uShop/codebase.html

Hopefully these tips will help.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.