webexplorer said:
O.K. Can you please show me how can I connect a database and Dreamweaver MX 2004? (Some of your examples. Any database software as long as I see something on Dreamweaver.)
I use a combination of the built-in Apache server, mySQL 5 (administered through phpMyAdmin), and php 5 (but the built-in php 4 is just fine) technologies. I use Dreamweaver to build my sites.
mySQL:
http://www.mysql.com (They've got native install packages for Mac OS X)
php 5:
http://www.entropy.ch/software/macosx/php/
phpMyAdmin:
http://www.phpmyadmin.net
Once you've correctly installed, set up and secured mySQL, install php 5. Then, get phpMyAdmin set up. Use it to create your database(s). Then, configure Dreamweaver's Sites correctly for your site, then connect with the Database Connections options in Dreamweaver.
It's a lengthy but simple process, and once you have it set up, it works well. I would recommend installing those packages in that particular order -- each package's documentation is verbose in how to set it up. Posting a how-to on getting a database set up starting from scratch would be quite lengthy. Start with mySQL, and make sure it's configured as the documentation states (e.g., you can start and stop the mySQL server and you've secured the root/admin user). If you've got problems with that portion, come back and we'll get you on the right track... then we'll do php and phpMyAdmin, and so forth.
Here is a rather old how-to on getting Dreamweaver talking to a mySQL database:
http://www.macromedia.com/devnet/dreamweaver/articles/php_macintosh.html
I wouldn't follow those explicit steps, since that how-to was written for Mac OS X 10.2 and many things have changes since then -- those explicit instructions may not even work. But, it is a decent, basic outline of what you would like to do -- it may be advantageous to read over that before beginning.
I hope that helps!