Board index   FAQ   Search  
Register  Login
Board index php forum :: Database MySQL Installation

PHP and MySQL set up for Coda text editor

Installation and configuration iussues

Moderators: macek, egami, gesf

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


Return to MySQL Installation

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.