|
When people think of building their own Web sites that are reliable, low-cost,
and immune to the plethora of attacks and viruses that cripple other popular Web servers, they think
Apache. It's a multi-platform server that runs on Linux, Unix, NetWare, Windows, and more. Many Web sites
need to store data in a database and an equally reliable, low-cost, and multi-platform database engine is
needed. The MySQL database engine is most commonly used.
Going beyond the static Web page content that HTML offers requires a programming environment.
One of the more popular is PHP because it's relatively easy to learn and is well-supported.
The combination of Apache, MySQL, and PHP is one of the most popular Web site environments. It's
commonly referred to as AMP for Apache, MySQL, and PHP.
ALC offers AMP training in a hands-on format that ranges from 3 to 5 days. Call us for details.
The AMP Trainer
You'll receive a copy of the AMP Trainer - a CD-ROM that allows you to use pre-installed, ready-to-run
copies of Apache, MySQL, PHP, and other related software. You simply boot your computer from the
CD-ROM and you're ready to work with Apache, MySQL, and PHP.
Course Outline
- Overview
- HTTP - A specialized, client/server, file-transfer protocol
- Methods - GET, PUT, HEAD, etc.
- Features - Cookies, Content negotiation, Authentication, Redirection
- HTML Markup, Sripting languages, CGI, Javascript, Java, etc.
- Databases and the SQL language
- Apache
- The most standards-compliant Web server
- Two current versions - 1.3 and 2.0
- Runs on Linux, Unix, NetWare, and Windows
- How it's typically installed on Linux, NetWare, and Windows
- Configuration Files
- Virtual Hosts/Virtual Servers
- HTTP and HTTPS (SSL) support
- Name-based versus IP-based hosts/servers
- Relationship with DNS
- Server Side Includes
- Access and error logging
- SSL Certificates and Certificate Authorities
- MySQL
- A lightweight RDBMS
- Comparison to Oracle
- Installing and Configuring MySQL
- Connecting to MySQL
- PHP Functions Specific to MySQL
- Executing SQL Calls
- Select, Insert, Fetch, Update, Delete
- Configuring MySQL with PHP MyAdmin
- PHP
- PHP Installation and Configuration
- Static vs. Dynamic Web Sites
- Dynamic Content from Databases
- Developing Dynamic Internet Applications
- Client-Side Scripting vs. Server-Side Scripting
- Configuring php.ini
- Basic Scripting
- PHP Scripting as HTML tags
- Print Statement
- Code Blocks
- Primitive Data Types
- Defining Constants and Variables
- Looping and Conditionals
- For, While, Do/While, Exit, and Break
- Conditional Constructs
- True and False Expressions
- If, Else, and Elseif
- Switch/Case Statement
- Functions
- Declaring Functions
- Scope
- Passing Arguments to Functions
- Returning Values from a Function
- Include Files
- The Require Statement
- Dynamic Function Calls
- Predefined Functions
- Operators
- Logical Operators
- Relational Operators
- Bitwise Operators
- Other Operators
- Arrays
- Indexing Arrays
- Initializing Arrays
- Adding and Removing data from arrays
- One-Dimension Arrays
- Multi-Dimension Arrays
- Array Functions
- Working with Databases and Forms
- Configuring PHP For Database Support
- PHP's Database APIs
- PHP's SQL API
- Database Drivers
- Database Driver Class Wrappers
- ODBC
- Simple SQL Queries via PHP
- Tracking Visitors with Session IDs
- Populating Forms
- Retrieving Data from Forms
- Working with Data Files in PHP
- Searching File Contents With Regular Expressions
- Changing and Editing File Contents
- Splitting and Joining Information Inside Files
- String Functions
- Regular Expression Functions
- Reading, Writing and Deleting Files
- Handling File Permissions
- File Locking
- Reading Directory Contents
- Creating and Deleting Directories
- E-mail and PHP
- Using Mail Servers
- Converting Messages to Readable Formats
- Sending E-mail
- Sending Attachments
- Sending Binary Attachments
- Sending HTML E-mail
- Validating an E-mail Address
- Automating E-mail Messaging
- Using Cookies with PHP
- Purpose of Cookies
- Cookie Myths
- Setting and retriving cookies
- Expiring and deleting cookies
- Miscellaneous PHP Tasks
- Error Logging
- Session Management & Maintaining State
- Using Environmental Variables
- Getting IP Addresses from Visitors
|
