PHP / Mysql

PHP is the web’s most popular server-side scripting language that is the backbone of many web related activities.
 
In addition many of the most popular CMS (Content Management Systems) such as WordPress, Drupal, and Joomla are written in PHP. Understanding this language will enable you to have a deeper understanding of these web tools making them easier to customize for your needs.

  • Web Development Level 1
  • Photoshop for Web & UI
  • Web Development Level 2
  • JavaScript & jQuery
  • Mobile & Responsive Web Design
  • WordPress
  • PHP & MySQL
  • HTML Email
  • Then Design & Build Your Own Website

MySQL is the world’s most popular open source database. Your database can store customer information, product information, and much, much more. Together PHP and MySQL are available for free on nearly every host.

This class will introduce you to the basics of PHP and MySQL. We’ll start from the ground up, building a solid foundation of how PHP works, thus allowing you to tackle your own projects and applications.

This class assumes that you have a solid understanding of HTML, but you don’t need to have prior programming experience.

 

Basic PHP Syntax

  • Echo, Strings, and Variables
  • Single Quotes vs. Double Quotes
  • Escaping Characters
  • Heredoc
  • Concatenation
  • Comments

Working with Numbers

  • Arithmetic Operators
  • Assignment Operators
  • Table of Arithmetic Operators
  • Table of Assignment Operators
  • Defining a Site and Testing Server in Dreamweaver

Conditionals

  • If/Else
  • Elseif
  • Switch
  • Comparison Operators
  • Logical Operators
  • The Difference Between == and ===

Conditionals

  • If/Else
  • Elseif
  • Switch
  • Comparison Operators
  • Logical Operators
  • The Difference Between == and ===

Arrays

  • Creating a simple array
  • Using array()
  • Multidimensional Arrays
  • Printing an Entire Array Using print_r()

Loops

  • While Loops
  • Do…While
  • For Loops
  • For Each
  • Break Out of Loop
  • Continue

Working with Strings

  • Comparing Strings
  • Converting to Upper and Lower Case
  • Searching Through Strings
  • Case-Sensitive and Case-Insensitive

Form Basics and Security

  • Post vs. Get
  • Radios, Checkboxes, and Select Fields
  • Magic Quotes
  • Securing the page
  • Using Functions

Sending Email

  • Setting Up MAMP Pro
  • Setting Up XAMPP and Mercury Mail
  • Sending a Test Email

Simple Form Validation and Email

  • Sanitizing Input
  • Error Checking
  • Displaying Errors
  • Sending Email
  • Adding a Thank You Page
  • Including Files

Cookies

  • Adding Cookies
  • Tracking the Number of Visits
  • Sending an Email with the Cookie Info

Sessions

  • Starting a Session
  • Using Session Variables
  • Log In/Log Out
  • Destroying Session Variables

File Uploads

  • Making a File Upload Form
  • The $_FILES Array
  • Uploading Files
  • Basic Security

Creating a Database/MySQL/SELECT

  • Creating a New Database
  • Connecting to the Database
  • SQL Basics
  • The SELECT Statement
  • Display the Number of Rows Returned
  • Making a Reusable Connection Script
  • MySQL vs. MySQLi vs. PDO

Making a Reusable Connection Script

  • Error Checking
  • Making an Include
  • Sorting Results

Prepared Statements

  • Selecting and Filtering Results
  • Preventing SQL Injection Attacks with Prepared Statements

SQL: Insert

  • The INSERT Statement
  • Using phpMyAdmin
  • Inserting Information from a Form

SQL: Update

  • The UPDATE Statement
  • Update Form
  • Display Data in the Update Form
  • Display Checkboxes
  • Hidden Fields

SQL: Delete

  • The DELETE Statement
  • Deleting Rows from a Database
  • Passing ID Variables in a URL

SQL: Search

  • Wildcard Searches
  • Searching with a Form
PHP / Mysql Training Schedule
Duration 18 hrs.
Next Batch Starting Oct 23, 2017
Oct 29, 2017