Introduction to MySQL

A NELINET Workshop
October 26th, 2005
9:30 - 3:30

Tired of constantly updating static web pages? Want to know how to "plug" databases into your web pages? This two part course will examine creating web accessible databases using MySQL and PHP. Participants will develop a prototype database project for managing a database on the web.

• 9:30 - 11:00
  • Overview of key concepts
  • The MySQL database and permissions
  • Introduction to phpMyAdmin
• 11:00 - 12:00
  • Creating tables
  • Introduction to select
• 12:00 - 1:00
  • Lunch
• 1:00 - 2:30
  • Joins
  • Aggregations
• 2:30 - 3:30
  • Functions
  • Wrap-Up

• Customers
• Orders
• Pizzas

Documents

• Introduction to MySQL (ppt)
• Select & Join
• Functions

Exercises

• Select Practicum
• Key to Select Practicum

Software

• MySQL
  • MySQL
  Install into default directory. During installation, make sure you do not select to have an anonymous user and set the root password. Make sure the MySQL is installed as a service -- it should default to this, but you can double-check within your control panel's administrative tools.
• Web Server
• Apache Web Server

  Install using all default values. Edit the httpd.conf file (found in the conf folder), to include these entries (you may need to either add them or uncomment them in the file). You can see a copy of my httpd.conf file here

  1. LoadModule php5_module c:/php/php5apache.dll
  2. AddModule mod_php5.c
  3. AddType application/x-httpd-php .php
  4. AddType application/x-httpd-php "/php/php.exe"

• PHP
  • PHP
  • PHP PECL

  Install the PHP program using all defaults. Install the PECL files into the ext directory within your PHP directory. Then copy all the *.dll files into your c:\windows\system32 folder.

  Copy the php.ini.dist file to c:\windows\php.ini. Edit c:\windows.php.ini by adding extension=php_mysqli.dll to the list of extensions. You can see a copy of my php.ini file here

• phpMyAdmin
  • phpMyAdmin

    Decompress this into your webdocs folder. Edit the config.inc.php file (found within the phpmyadmin folder) to include these lines. You can see a copy of my config.inc.php file here.

    1. $cfg['PmaAbsoluteUri'] = 'localhost/phpmyadmin/';
    2. $cfg['Servers'][$i]['user'] = 'root';
    3. $cfg['Servers'][$i]['password'] = 'ZIPPY';

  ---