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 info@verhoef.com