Making a switch to php and MySql.

Forum Moderators: coopster

Message Too Old, No Replies

Making a switch to php and MySql.

I am very new to the dynamic site and need some starting help.

pxp25

7:46 pm on Aug 30, 2004 (gmt 0)

I have an e-commerch site (with Static pages.) The site have grown to carry over 50 items, which make maintaining the site quite a big task. I want to make a switch to dynamic site using php & mySql in hope to decrease the site maintainent time. I have some idea with php but have no clue about using it to access database. I do know a bit about SQL from the collage days, but I am totally new to mySql. I really need some advice on where to start on this quest for a dynamic site.

Here are some questions that I have
How do I link, access and retrive record using php with MySql?

Where should I put the database in the server and how can I set it up?

How do I control what and where the record will appear on my html page.

OR Can anyone suggest a good book on this subject that
I can learn quickly.

I am really excited about the switch over to dynamic site, but to be honest it is like stepping into the unkown for me.

Any help would be appreciated.

Timotheos

8:22 pm on Aug 30, 2004 (gmt 0)

Hi pxp25!

Have a look at the links in this thread.
[webmasterworld.com...]

Tim

grandpa

11:21 pm on Aug 30, 2004 (gmt 0)

In addition to the link provided I've found these resources very helpful.

MySQL Documentation [dev.mysql.com]
php [php.net]

And for your reading pleasure I might recommend The PHP Bible.

I started using php 5 or 6 months ago, and got up to speed pretty quickly. Reading the book helped sort out the mass of information available on the websites.

Best of luck.

thomask

2:55 am on Aug 31, 2004 (gmt 0)

There are a host of 'commmerce' projects out there using php and MySQL, I am using one with good results, and its FREE with forum support...

GoodLuck!

ThomasK

toltec75

10:04 am on Aug 31, 2004 (gmt 0)

PHP Essentials, second edition is a very good book that will get you into basics and some more complex stuff pretty soon!

It helped me a lot! But if you`re looking for advanced stuff, I guess forums like these are good choice to learn from! Sadly I found out there are many essential things which you cannot find in any of the books!