PHP and MySQL set up for Coda text editor

[amartinez]

Hi, I just purchased Coda (http://www.panic.com/coda/) text editor and it is working great so far, but I'm not familiar with how php and mysql should be set up with this program. Can someone help me with this please.
I have a MAMP installation in my mac, but even though it worked just fine with DW, it isn't with Coda.

[amartinez]

Not sure if there are many beginers like me out there, but here is what fixed my problem.

Install Apache/PHP/MySQL on Snow Leopard

Apache
Start Apache
sudo apachectl start
Check it's working: http://localhost/

PHP
In /etc/apache2/httpd.conf, uncomment this line:
LoadModule php5_module libexec/apache2/libphp5.so
Restart Apache
sudo apachectl restart

Fix a warning appearing in phpinfo()
Create /etc/php.ini and make it writable
cd /etc
sudo cp php.ini.default php.ini
sudo chmod 666 php.ini
In php.ini, find this line:
;date.timezone =
Uncomment it and insert your time zone (http://php.net/manual/en/timezones.php)
date.timezone =America/Vancouver
Restart Apache
sudo apachectl restart

MySQL
• Download the MySQL package for Mac OS X.5 (32 or 64 bits depending on your machine)
• Install everything in the package in this order: mysql, the startup item, the preference pane.
• Start MySQL in the preference pane.
• test it's working:
/usr/local/mysql/bin/mysql

Fix mysql.sock location in php.ini
• In /etc/php.ini, replace the three occurences of /var/mysql/mysql.sock by /tmp/mysql.sock

pdo_mysql.default_socket=/tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
mysqli.default_socket = /tmp/mysql.sock

Restart Apache
sudo apachectl restart

Extra

Activate PHP short tags
In /etc/php.ini, under Language Options, change
short_open_tag = Off
to
short_open_tag = On
Restart Apache
sudo apachectl restart


source : http://maestric.com/doc/mac/apache_php_ ... ow_leopard

[victorsmith]

There are a number of programs for Mac and Windows that allow you to edit plain text files that are made specifically for people who are writing code. These programs have varying features such as displaying text in a color coded format so it is easier to pick out mistakes, quick code buttons, showing a preview, or upload capabilities.

Classified php script