PHP/MySQL Fundamentals Training

PHP is a popular, open-source programming language optimized for dynamic web pages and web-based applications, like registration systems, shopping carts, and polling systems. Many of today's high-traffic websites, such as Facebook and Yahoo, make extensive use of PHP.

AcademyX's PHP/MySQL training class walks you through the steps of implementing PHP within the Apache web server environment. By the end of our PHP training class, you will be able to generate dynamic HTML forms, and collect and store their input data to either a MySQL or Microsoft Access database.

How PHP, MySQL and Apache Work Together

In this first part of the PHP/MySQL training, you will learn how a web server generates dynamic web pages from PHP scripts with embedded HTML. We'll show you:

  • How web servers work with PHP
  • How to configure the "php.ini" file, as well as error reporting, logging, and delimiters
  • How the Apache web server is configured for PHP
  • How PHP scripts generate HTML web pages on the fly

Basics

  • Syntax: the rules for writing PHP code
  • Variables: how to store text and numbers
  • Output: how to create HTML using your PHP code
  • Conditionals: how to execute certain sections of code depending on different conditions
  • Loops: how to iterate over code blocks to repeat certain actions a certain number of times
  • Form Data Capture

    Forms are often the primary means of providing data to web servers. You can use PHP code to capture form data on the server and store it in a database, or send data out from the database via email. In this part of the PHP training, our expert instructor will show you how to:

    • Use HTML to create a form and send from data to a PHP Script
    • Create PHP scripts for processing inputted form data

    Sending Emails with Code

    • Implement the mail() function to relay email to a mail server
    • Issues that arise when sending email programatically
    • Dealing with bouncebacks and reply-to fields
    • Adding carriage returns and newlines to emails send from PHP

    Lists and Associative Arrays

    Arrays are the most commonly used data storage structure, conveniently built into the PHP programming language. In this part of the PHP training class, you will learn how to:

    • Program a random number generator
    • Use a for loop to iterate through numerically indexed and associative arrays
    • Create a shipping cost tabulation program using associative arrays

    Retrieving Recordsets from Databases

    In this part of the PHP/MySQL training, you will learn to interact with two of the most popular relational databases: MySQL, a widely used open-source database, and Microsoft Access, a popular desktop database. We'll teach you how to:

    • Create a new database schema
    • Define and edit tables using the table editor
    • Use the MySQL Query Browser to run SQL queries on your database
    • Write basic SQL to insert, update, and delete records, and more
    • Add, edit and display records using SQL statements
    • Use PHP to connect to a MySQL database or MS Access database
    • Retrieve recordsets and output them as tables in your HTML
    • Manipulate form input on the fly and display it on another HTML form or web page

    Working with Sessions

    Web pages are stateless and, therefore, do not retain information between page loads. This means that forms lose their field data once the next page loads. Sessions can solve this issue. In this section of the PHP training course, you'll learn how to work with sessions, as well as:

    • Differentiate between "normal" variables and "session" variables
    • Use PHP to assign unique identifiers to each of your web site's visitors
    • Set up a customer database that provides a snapshot of past orders for all "authorized" users

    File Input/Output