Developing Web-Sites Using PHP and MySQL

Course: PHPMYS

Duration: 5 Days

Level: I

Course Summary

Anytime you're on the web, you're going to be landing on PHP pages. By most counts, over a million web sites have been written in PHP, including some of today's largest, most recognizable sites. And those sites often use MySQL as the database.

That means there's a continuing demand for web developers who know how to use PHP and MySQL at the professional level.

« Hide The Details

Topics Covered In This Course

Introduction to web development with PHP

The architecture of a web application
How to edit and test a PHP application
How to use NetBeans to develop a PHP application

How to code a PHP application

Basic PHP skills
How to get data from a request
How to work with data
How to code control statements
How to use the PHP documentation

Introduction to relational databases and MySQL

An introduction to relational databases
The SQL statements for data manipulation
An introduction to MySQL
How to use phpMyAdmin

How to use PHP with a MySQL database

PHP for working with MySQL
How to get data from a result set

How to use the MVC pattern

An introduction to the MVC pattern
How to code functions
How to redirect requests

How to test and debug a PHP application

An introduction to testing and debugging
How to debug with xDebug and NetBeans

How to work with form data

How to get data from a form
How to display data on a web page

How to code control statements

How to code conditional expressions
How to code the selection structures
How to code the iteration structures

How to work with strings and numbers

How to work with strings
How to work with numbers
Other skills for working with strings and numbers

How to work with dates

How to use timestamps to work with dates
How to use objects to work with dates

How to create and use arrays

How to create and use an array
How to create and use an associative array
How to use functions to work with arrays
How to work with arrays of arrays

How to work with cookies and sessions

How to work with cookies
How to work with sessions

How to create and use functions

Basic skills for working with functions
How to create and use a library of functions
Advanced skills for working with functions

How to create and use objects

How to create and use classes
How to code class constants, properties, and methods
Additional skills for working with How to work with inheritance

How to use regular expressions, handle exceptions, and validate data

How to use regular expressions
How to handle exceptions

How to design a database

How to design a data structure
How to normalize a data structure
A database design tool

How to use SQL to create a MySQL database

How to work with databases
How to work with tables
How to work with indexes
How to work with users and privileges
Other skills for creating a database

How to use SQL to work with a MySQL database

How to select data from a single table
How to select data from multiple tables
How to code summary queries
How to code subqueries
How to insert, update, and delete rows

Professional PHP for working with MySQL

Three ways to use PHP to work with MySQL
How to work with PDO
How to work with mysqli

How to create secure web sites

How to use a secure connection
How to use authentication
How to work with encrypted data

How to send email and access other web sites

How to send email
How to get data from other servers

How to work with files, uploads, and images

How to work with files
How to upload a file
How to work with images

What You Can Expect

This course teaches all the skills you need to develop almost any type of database-driven web site with PHP and MySQL. The course gradually moves from the simple to the complex as they show you how to work with:

the PHP language
the MySQL database
the SQL statements for MySQL
the PDO and mysqli extensions
the MVC pattern
debugging and exception handling
sessions and cookies
object-oriented PHP
regular expressions and data validation
SSL and secure connections
authentication and login forms
email and content from other sites (like YouTube)
file uploads
and more!

Who Should Take This Course

Developers who wish to learn how to use PHP and MySQL to build database driven web sites.

Recommended Prerequisites

A basic understanding of internet concepts and programming would be advantageous.

Training Style

Instructor led with 60% lecture and 40% lab.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
RORSQL	mySQL with RUBY and RAILS	5 Days	I	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]