Using MySQL for a catalog

SusanMoore

I had someone program my Web site, www.fanent.com. It uses PHP and MySQL to generate page views on the fly. Everything works well, in my opinion.

However, I want to create a printed catalog that contains the same information (especially about the buttons). I could just fire up WordPefect, create a humongous table, and start loading it, but that will be a royal pain when I need to update it.

I can't find where the database resides on my server. My programmer says it's inbedded in the PHP code, but I can't find it there. I hoped I could use MySQL commands to extract info from the database and use that info to construct my catalog.

Any suggestions?

Thanks in advance,
Susan

greg252

you would have to write a script to ret the records from the database and write the HTML to organize the layout. If you have no idea how to do this, I would get the programmer that wrote the site to write the script for you-- as a programmer, any problem that may arise from another script accessing a database I designed will void ALL warranties.
Also...
If this is a professional catalogue, the resolution of the images is waaaaayyyy too low to print accurately. This is something that should have been discussed at the beginning of the project.

SusanMoore

Thanks for the help, Greg.

You're right about the image resolution. I'll have to recreate each and every one of them. Sigh.

I'll speak with my programmer and see what can be done.

Susan

paulg

Hey Susan,
When you speak to your programmer, have him check out the cart. I selected a magazine at $16 each. I changed the qty to 10 and the basket total showed as still $16, even onto the checkout page. ooops!:eek:

SusanMoore

Paul (and others):

Thanks for pointing that out. 🆒 However, the ordering and shopping cart work just fine. You failed to click the "Change Quantity" button after you increased your order past the initial "1." There are instructions to that effect beneath the shopping cart.

If you, or any of the others, think this is a logic lapse on the page, please suggest how it would work better to instruct the shopper how to increase the quantity purchased or cancel the purchase entirely.

Thanks again!
Susan

paulg

Hi Susan, don't know what happened there. I thought i did click the button.😕

Aha! Setting the quantity to 10 or 100 works fine, but try making the quantity 1000. Quantity total works okay, but the basket total gets screwed up (see grabbed text below).

Product Type Product Name Price Quantity Total

Button Mouse Pads I'm not tense $ 8.00 $ 8,000.00
Current total: $ 8.00

I know not many customers are likely to order a thousand units😃

SusanMoore

Oooh, good catch, Paul!

To keep from bothering (paying) my programmer, let me see if I can fix this. It's surely just an issue of making the spaces for the quantity window and the Current total larger.

More on this later. I appreciate the help!

paulg

Yeah, could just be the size of the form var. Also check out the tables involved. If the basket data is held in a table, the total or item-total fields may need to be adjusted.

Save even more money - learn to php/mysql it yourself. Think of all those Friday & Saturday nights you could spend at home instead of partying!😃