PHP and MySQL set up for Coda text editor

Installation and configuration iussues

Moderators: macek, egami, gesf

amartinez
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Jun 23, 2011 6:35 am
Location: Santa Barbara

PHP and MySQL set up for Coda text editor

Postby amartinez » Thu Jun 23, 2011 6:39 am

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
New php-forum User
New php-forum User
Posts: 2
Joined: Thu Jun 23, 2011 6:35 am
Location: Santa Barbara

Re: PHP and MySQL set up for Coda text editor

Postby amartinez » Thu Jun 23, 2011 10:49 pm

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
New php-forum User
New php-forum User
Posts: 9
Joined: Tue Sep 20, 2011 11:00 pm

Re: PHP and MySQL set up for Coda text editor

Postby victorsmith » Tue Sep 20, 2011 11:12 pm

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


Return to “MySQL Installation”

Who is online

Users browsing this forum: No registered users and 1 guest

cron