Group A Presentation

1
Group A Presentation

• Roberto Jarquin, Systems Analyst
• Brandon Heron-Vanta, Programmer
• John Flinn, Security
• Jason Owens, Deputy Team Leader
• Antonious Kokkinos, Team Leader
• Arturo Peguero, Programmer
• Julie Kwock, DBA
• Andrew Bailey, Systems Analyst
• Douglas Logue, Security Analyst

2
Objective

• Explain PHP, Mysql, Apache
• Explain Installation of PHP, MySQL, Apache
• Show Implementation of Sample Programs

3
Systems

• PHP
• MySQL
• Apache

4
What is PHP?

• Scripting Language
• Suited for web development and embedded into HTML
• Syntax borrowed from C, Java, and Perl

5
Goal of PHP

• Allow web developers to write dynamically
  generated pages quickly

6
PHP Scripts

• Server Side Scripting- PHP parser, web server,
  web browser
• Command Line- PHP parser
• Writing client-side GUI applications

7
PHP

• Can be used on all major operating systems
• Linux, Unix, Microsoft Windows
• Supports most of the web servers
• Apache, Microsoft internet information server,
  Personal web server, Netscape

8
(No Transcript)
9
PHP Article

• Although PHP is universally thought of as
  implying Linux, Apache and MySQL, nearly 7 of
  PHP sites when counting by ip address run on
  Windows. This has doubled over the last year, and
  on its current growth trajectory PHP will
  overtake Cold Fusion as the most popular
  non-Microsoft scripting language used on Windows
  during the next year.

10
IP Addresses on Windows Operating System
11
PHP

• Easy to learn!

12
My SQL

• Most popular 4 million installations
• Powering
• Websites, data warehouses, business applications
• Customers
• Yahoo Finance, MP3.com, Motorola, NASA, Silicon
  Graphics, Texas instruments

13
My SQL Core Values

• The best and the most used database in the world
• Available and affordable for all
• Easy to use
• Continuously improved while remaining fast and
  safe
• Fun to use and improve
• Free from bugs

14
What is MySQL?

• Database Management System
• Computers handle large amount of data
• Open Source

15
MySQL

• Maximize speed and reliability
• Handles large datasets and supports many
  programming languages

16
Apache

• Web Server Software that is developed Open Source
  by the Apache Software Foundation
• Used to host web sites

17
Apache

• Powered sites at over 60
• Freely available, reliable and simple to set up

18
Installation

• Apache
• PHP
• MySQL
• PHPMYADMIN

19
Apache Installation

• Go to Apache.org
• Select a mirror to download
• Make sure it is a Win32 installer (for windows
  installation)
• Run setup.exe

20
Apache Installation

• Set domain to localhost
• Follow screen instructions
• Apache is now installed

21
PHP Installation

• Go to PHP.net
• Run setup.exe
• Select standard installation

22
PHP Installation

• Set address as localhost

23
PHP Installation

• Select Apache on list because we are running an
  Apache service
• Then click next and you are almost done
• ScriptAlias /php/ "c/php/" AddType
  application/x-httpd-php .php .phtml Action
  application/x-httpd-php "/php/php.exe"
• Copy the above script in you httpd.conf.
• Put in bottom and save

24
MySQL Installation

• Go to MySQL.com
• Download
• Run setup and follow click yes or no pending
  services you want

25
Next you need PHPmyAdmin

• Go to http//prdownloads.sourceforge.net/phpmyadmi
  n/phpMyAdmin-2.2.6-php.zip?downloadrelease_id8583
  2
• This will display several mirrors, choose one

26
PHPmyAdmin

• This program allows you to access an interface
  for mysql
• This program allows you to manage online
  databases
• Next Step
• Extract PHPmyadmin to
• Program FilesgtApachegthtdocs (this is your online
  folder)

27
Start MySql

• You need to open notepad
• Enter in
• c\mysql\bin\mysqld-nt.exe --standalone
• Save as a .bat file
• This file will allow you to start MySql service,
  when you open it

28
Create a Frontpage

• Create an html document (index.html)
• Drag into Apachegthtdocs (online folder)
• If you see this then you did not do it right,
  check naming

29
Sample Implentations

• Fstats
• PHP Book

30
Fstats

• Displays website hit statistics
• Uses PHP tied with MySQL commands to display
  statistics and store them in a database

31
Fstats

• Steps to Install
• Download
• Extract files to htdocs
• Then open config.php in the folder
• Enter in Database info, password, domain name,
  etc.
• Put a Script in index.html to enable counter

32
Fstat Config.php file
33
PHP Book

• Guest book with PHP and MySQL
• Creates Tables and scans for bad words, ip
  address, and smiley face characters
• Features Possible one-time entry, ip-logging,
  changeable interface

34
PHP Book Installation

• Download
• Extract all files into htdocs directory
• Then Create tables using
• Install.php
• Or copy pasting it into phpmyadmin sql statements

35
PHP Book Create Tables
36
PHP Book config.php
37
Lets Test

• PHP Book
• Add an entry
• Show Fstat Screens