PHP and mySQL

[kevin49093]

Ok guys...
My brother wants me to put together a simple database driven web site for him.. It is going to be a directory listing of traveler friendly yoga studios. I've begun to look into php and mysql, and they seem to make sense. My question is this, are there any apps or tools out there that can really help in the writing of the pages> I think I've got the actual database side of it figured out, now I just need to display the info!

Thanks!

 

[Taft]

This page has everything you need to do a query and display the results in HTML.

http://www.php.net/manual/en/ref.mysql.php

Its from the PHP documentation page. (http://www.php.net/manual/en/) This page will be invaluable to you as you start using PHP to build web pages.

You may also want to check out PostgreSQL (http://www.postgresql.com/). Its like MySQL on steroids and includes such great items as stored procedures and transactions (items MySQL doesn't have). In my opinion, its definitely a more complete and enterprise-ready database.

Taft

 

[macktheknife]

If you happen to have Dreamweaver, it has PHP support. JaneBUILDER is a visual editor for PHP that you might want to check out. It costs about $50 or so, but you might want to check it out:

http://www.seejanecode.com/

 

[kevin49093]

Thanks...

Thanks for your tips guys...

I'm starting to look at it now, it seems a bit coufusing, but I might be able to manage it. I think the server for the site does not allow remote access of the mySQL database, so I'll have to work around that.

I think I am understanding how to actually create the coded pages (using apps), but don't get how to upload a large ammount of info into the database at once. Am I missing something very simple here?