Introduction to PHP

A NELINET Workshop
November 30th, 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
    1. document structure
    2. variables
    3. printing
    4. connecting to the MySQL server and choosing a database
• 11:00 - 12:00
  • Creating the Login Page

• 12:00 - 1:00
  • Lunch

• 1:00 - 2:30
  • Creating the Order Review Page

• 2:30 - 3:30
  • Creating the Order Page

• SQL commands to create pizza tables and data

  This will create the database. To create this project, you will need a user account in MySQL called pizza. It needs to have a password of pizza and have insert, select and delete priveledges in the pizza database

• Index page for pizza project (save as index.html)
• Web page to create new pizza accounts

• 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';

  ---