Thursday, May 14, 2009

Installation of phpESP in ubuntu 9.04

phpESP is a online survey support application that allows the rapid deployment of an online survey. The survey can be created, modified, tested, and activated by the survey creator. It can support large surveys (100 questions) and large respondent groups (4,000+) without a problem. The collected data can be viewed online in various simple cross-analysis and cross-tabulations. For more advanced analysis the data can be downloaded as a CSV file (Comma Separated Values) and imported into Excel or Access.

Installation of phpESP in ubuntu 9.04

• Step 1: Download the latest stable version of phpESP from http://sourceforge.net/projects/phpesp/
• Step 2: Uncompress the downloaded file on your desktop.
• Step 3: Upload the extracted files to your web hosting account via FTP to a specified directory of your choice (e.g. /phpesp).
• Step 4: Go to “PhpMyAdmin”, Create a MySQL Database name “phpesp”
• (If PhpMyAdmin is not installed then follow these steps)
sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin

Copy phpmyadmin into my document root directory to work http://localhost/phpmyadmin, with this command in shell:

sudo ln -s /usr/share/phpmyadmin/ /var/www/phpmyadmin

# /usr/share/phpmyadmin/ is the directory where phpmyadmin installed
# /var/www/ is your document root directory

To make sure everything installed correctly we will now test phpmyadmin to ensure it is working properly.
1. Open up any web browser and then enter the following into the web address:
http://localhost/phpmyadmin/index.php

• Step 5 In “PhpMyAdmin”, select the database you have just created, and click on “SQL”.
• Step 6: Search for “mysql_populate.sql file, Copy the content of the file and paste it into the SQL Form and click Go. This will create the database tables of phpESP.
• Step 6: After successful creation of the database and its tables, go to the location of your newly uploaded files: http://www.yourdomain.com/phpesp/