mghightech
Select Language: English Spanish Portuguese
PHP & MySQL classes
Courses
C Language
C++ Language
Computer Basics
Maintenance of Computers Laptops (A+)
Microsoft Excel
Java Language
Adobe Photoshop
Microsoft Access
Adobe Flash
Microsoft Power Point
Webdesign
Microsoft Word
IT Security
AutoCAD
Final Cut Pro
Adobe Illustrator
Adobe InDesign
CCNA
Dreamweaver
Linux Workshop
Quickbooks Pro
Tablet & Smartphone Repair
PHP & MySQL

 

PHP & MySQL
PHP is a reliable programming language which helps developers to work with web forms and to communicate with databases.

Acquired Skills:

This course provides you with the correct knowledge to learn basics of PHP (including variables, logical expressions, loops and function) and understand to connect PHP to MySQL database.

Prerequisites:

Knowledge of HTML, CSS and Java Script

Course Duration:

This course will be completed in 4 months or on average 60 hours.

Curriculum Material:

The language and teaching techniques are geared to the course’s final use. It includes explanatory exercises and examples with working on real devices.

Course Topics:


    Topics

    PHP Overview

    • Why choose PHP?
    • Installation overview
    • Working with Apache Web Server
    • Changing the Document root
    • Enabling PHP
    • Upgrading PHP
    • Configuring PHP
    • Installing MySQL
    • Configuring MySQL
    • Text editor

    Exploring Data Types

    • Variables
    • Strings
    • Strings functions
    • Integers
    • Floating points
    • Arrays
    • Associative arrays
    • Array functions
    • Booleans
    • NULL and empty
    • Type juggling and casting
    • Constants

    Control Structures: Logical Expressions

    • if statements
    • Else and elseif statements
    • Logical operators
    • Switch statements

    Control Structures:Loops

    • While loops
    • For loops
    • Foreach loops
    • Continue
    • Break

    User-Defined Functions

    • Defining functions
    • Function arguments
    • Returning values from a function
    • Multiple return values
    • Scope and global variables

    Debugging

    • Common problems
    • Warnings and errors
    • Debugging and troubleshooting

    Building Web Pages with PHP

    • Links and URLs
    • Using GET values
    • Encoding GET values
    • Encoding for HTML
    • Including and requiring files
    • Modifying headers
    • Page redirection
    • Output buffering

    Working with Forms and Form Data

    • Building forms
    • Detecting form submissions
    • Single-page form processing
    • Validating form values
    • Problems with validation logic
    • Displaying validation errors
    • Custom validation functions
    • Single-page form with validations

    MySQL Basics

    • MySQL introduction
    • Creating a database
    • Creating a database table
    • CRUD in MySQL
    • Populating a MySQL database
    • Relational database tables
    • Populating the relational table

    Using PHP to Access MySQL

    • Database APIs in PHP
    • Connecting to MySQL
    • CRUD in MySQL
    • Populating a MySQL database
    • Relational database tables
    • Populating the relational table
    • Relational database tables
    • Populating the relational table

    Application CRUD

    • Finding a Subject in the database
    • Refactoring the page selection
    • Creating a new subject form
    • Processing form values and adding subjects
    • Passing data in the session
    • Validating form values
    • Creating an edit subject form
    • Using single-page submission
    • Deleting a subject
    • Cleaning up

    Building the Public Area

    • The public appearance
    • Adding a default subject behavior
    • The public content area
    • Protecting page visibility

    Regulating Page Access

    • User authentication overview
    • Admin CRUD
    • Encrypting passwords
    • Salting passwords
    • Adding password encryption to CMS
    • New PHP password functions
    • Checking for authorization
    • Creating a logout page

Certificate of Completion

At the end of the course the student will receive our certificate of completion for this training.
mghightech