PHP and MySQL

[MrToast]

Hi Everyone!

I've decided recently to teach myself PHP and MySQL in an attempt to "simplify" website design on future sites of mine. I already know Perl, so picking up the gist of PHP hasn't been too bad, but I was wondering if anyone could direct me to some sites that teach how PHP and MySQL interact. (Examples would be great, too!) I've already got everything all set up... PHP, MySQL, PHPMyAdmin... all installed. Just not in my brain.

Thanks a bunch!

Dave

[activemx]

Check out the whitepapers, someone posted a php walk through.
http://www.w3schools.com/ is one of my favorite sites.

http://del.icio.us/tag/php

Do a google search on tutorials and there are plenty out there.
The best way to learn is by look at examples if you already have experiance in scripting. Pick a script from hotscripts.com or freshmeat etc. something simple like a guestbook script and look through it modify it. That worked best for me.
Good luck.

[JonBell]

The best way to interact with MySQL is via PEAR (Think of a young CPAN). There's a module that allows complete OO interaction with mysql, it's very nice.
This looks like a pretty nice tutorial: vulcanonet.com.

Most PHP installations comes with pear, if it doesn't have it, run:
lynx -source http://go-pear.org/ | php

Then you can just do:
pear install DB

Any probs, feel free to ask

[AIBob]

I recently typed a php tutorial, its in the White papers and on my website: bobfrank.org.

And I intend on typing an sql tutorial soon enough, and I will probably add a section to my php tutorial shortly after, linking the two together.

[Greg Marra]

SQL is nice, but don't forget: PHP is extremely powerful on it's own, and certain applications can be easier performed by flat databases and text files than a full blown SQL database.