|
|
Getting Started
Course Setup Using XAMPP
What is "XAMPP"?
What is included with XAMPP?
Are there any other choices?
Each operating system has its own series of web servers and database servers, some free, others not
Cross Platform: XAMPP, Zend Server CE, Bitnami
Linux: LAMP, OPEW
Mac: MAMP, DAMP
Windows: EasyPHP, Server2Go, The Uniform Server,
WAMP Developer Pro*, Web Developer Suite (both are not free!)
Why was XAMPP chosen for this course?
XAMPP was chosen as it is cross platform, open source,
free of charge, well supported, and provides a consistent interface
How do you get information on XAMPP?
XAMPP: http://www.apachefriends.org/en/xampp.html
Apache: http://httpd.apache.org/
MySQL: http://dev.mysql.com/
PHP: http://php.net/
Perl: http://www.perl.org/
Configuring PHP and MySQL
Why would you want to configure PHP?
Configure PHP if you need to improve performance or to address special needs.
The default settings work well in most cases.
How do you configure PHP?
Edit the /path/to/xampp/php/php.ini file, and then
restart the web server which reloads PHP.
XAMPP includes a "config" option under Apache which
opens a screen to edit the php.ini file
What are the most important PHP parameters to configure?
date.timezone, output_buffering, memory_limit, max_execution_time,
display_errors, error_reporting, include_path, upload_tmp_dir
Why would you want to configure MySQL?
Normally the default MySQL settings for your system work well.
Only change settings if you notice poor performance.
You can also use the phpmyadmin "advisor" (under "status") to perform an analysis and to give recommendations.
How do you configure MySQL?
1. Use the phpmyadmin "advisor" to determine settings which should be changed
2. Edit the /path/to/xampp/mysql/bin/my.ini file
What are the most important MySQL parameters to configure?
long_query_time, log_slow_queries, query_cache_size, query_cache_type,
max_heap_table_size, tmp_table_size, key_buffer_size, open_files_limit, thread_cache_size
Setup and Finding Course Files
Where are the course files located?
Course files are located under the "WorkingFiles" folder
Files are grouped by chapter
Where is the course outline?
What needs to be done before you can run the examples?
1. Install XAMPP on your local computer
2. Copy the "WorkingFiles" folder to your local /path/to/xampp/htdocs folder
3. Open the XAMPP control panel (click on /path/to/xampp/xampp-control.*) and start Apache and MySQL
4. In your browser type "http://localhost/phpmyadmin"
5. Make sure you have assigned a password to the MySQL root user!
(see http://localhost/security/index.php)
What needs to be done continued
6. Click "User" and then "Add User"
7. Enter the following information:
Username: class | Host: localhost | Password: password | Re-type: password
8. Under "Database for User" select: "Create database with same name and grant all privileges"
9. Select the "class" database and click "Import"
10. Click "Choose File" and select /path/to/xampp/WorkingFiles/Chapter1/class_setup.sql
11. Accept the defaults and click "Go"
You should now have all the class tables needed for the exercises in the database chapters
|
|
