Mike Kelly Analyst

1
Presentation 1

• Mike Kelly - Analyst
• Gaby Charbonneau - Analyst
• Tristan Derries - Programmer
• Faye Nolen - Programmer
• Jason Coine - Web Wizard
• Vic Gill - Web Wizard  
• Mila Supandi - Database Administrator
• Bobby Clark - Database Administrator
• Brian Johnson - Presenter

2
Requirements

• Sample system implementation
• Install system software
• PHP
• Apache
• MySQL
• Execute an application of moderate complexity
  utilizing system software

3
Understanding PHP

• PHP is a scripting language as opposed to a
  programming language, which means PHP is designed
  to do something only after an event occurs, for
  example when a user submits a form or goes to a
  URL.
• PHP can interact with databases and files,
  handle email, which HTML cannot.
• Everything PHP does occurs on the server as
  opposed to the client.
• It can be used on machines running Unix,
  Windows, Macintosh, OS/2 and other operating
  systems.
• PHP is embedded in HTML which means that it can
  be within your HTML code (HTML code being the
  code with which all Web pages are built.

4
How PHP Works

• PHP is a server-side language, which means that
  the code you write in PHP resides on a host
  computer that serves Web pages to Web browsers.
• When a visitor goes to a website
  (www.DMCinsights.com) your Internet service
  provider directs your request to the server that
  holds the www.DMSinsights.com information.
• The server reads the PHP code and processes it
  according to its scripted directions. The PHP
  code tells the server to send the appropriate
  Webpage data to your browser in the for of HTML.

PHP
HTML
Server
Client
URL
5
Basic Syntax

• You will start off exactly as you would if you
  were creating an HTML document from scratch.
• PHP scripts should be saved with the .PHP
  extension
• Example of code
• ltHTMLgt
• ltHEADgt
• ltTITLEgt First PHP Scriptlt/TITLEgt
• lt/HEADgt
• lt?PHP
• ?gt
• lt/BODYgt
• lt/HTMLgt

6
(No Transcript)
7
Some Facts

• MySQL is the world's most popular open source
  database, recognized for its speed and
  reliability.
• Customers such as Yahoo! Finance, MP3.com,
  Motorola, NASA, Silicon Graphics, and Texas
  Instruments use the MySQL server in
  mission-critical applications.

8
Running MySQL

• MySQL is ran through a console window where
  databases can be built and many other functions
  performed.

9
Working Together As A Team

• Set username and password in MySQL

connection mysql_connect(localhost,
username, password)
10
Testing Your Connection

• lt?
• connection mysql_connect("localhost",
  username", password")
• or die(mysql_error())
• if (connection)
• msg "success!"
• ?gt
• ltHTMLgt
• ltHEADgt
• ltTITLEgtMySQL Connectionlt/TITLEgt
• lt/HEADgt
• ltBODYgt
• lt? echo "msg" ?gt
• lt/BODYgt
• lt/HTMLgt

11
Connection Made!
12
Apache

• HTTP Server
• Open-source HTTP server for modern operating
  systems
• Includes console for ease of use
• Most popular web server on the Internet since
  April of 1996

13
Working Together As A Team

• LoadModule php4_module c/php-4.3.3-win32/sapi/php
  4apache.dll
• AddModule mod_php4.c
• AddType application/x-httpd-php .phtml .php
• AddType application/x-httpd-php-source .phps

14
Testing Your Connection

• lt? phpinfo() ?gt
• Name it phpinfo.php
• http//127.0.0.1/phpinfo.php

15
Connection Made!
16
Questions???