PHP Programming with MySQL

This online hands on PHP Programming course provides the knowledge necessary to design and develop dynamic, database-driven web pages using PHP version 7. PHP is a language written for the web, quick to learn, easy to deploy and provides substantial functionality required for webbase application.

Introducing Oracle Application Express

• Application Express Overview
• Application Express Terms and Concepts
• Using Application Express

Creating a Desktop and Mobile Database Application
Overview Of PHP

• Static vs. Dynamic Web Sites
• Dynamic Content from Databases
• Developing Dynamic Internet Applications
• Client-Side Scripting vs. Server-Side Scripting
• Overview of PHP Advantages and Capabilities
• Configuring php.ini
• PHP vs. ASP

Conditional Constructs

• True and False Expressions
• if, else and elseif
• switch/case Statement
• The ? (Ternary) Operator
• Timestamps

Basic Scripting and Looping Constructs

• PHP Scripting Fundamentals
• Print Statement
• Code Blocks
• Primitive Data Types
• Defining Constants and Variables
• Looping Constructs
• while
• do … while
• for
• exit & break

Introduction to the Apache Web Server

• Apache Configuration Files
• Configuring Apache for PHP
• WWW Sites within Apache
• Apache Virtual Hosts
• Website Properties

PHP Operators

• Logical Operators
• Relational Operators
• Bitwise Operators
• Other Operators

PHP Functions

• Introduction to Functions
• Declaring Functions
• Scope
• Passing Arguments to Functions
• Local and Global Scope
• Passing Arguments to Functions by Value and Reference
• Returning Values from a Function
• Using Include Files
• The Require Statement
• Recursion
• Dynamic Function Calls
• Predefined PHP Functions

Arrays in PHP

• What are Arrays?
• Usage of Arrays in PHP
• Array Indexing
• Initializing Arrays
• Operating on Arrays
• Sorting Arrays
• One-Dimensional Arrays
• Multi-Dimensional Arrays
• Associative Arrays
• Array Functions
• Forms and Arrays in Web Applications

Working with Data Files in PHP

• Searching File Contents With Regular Expressions
• Changing and Editing File Contents
• Splitting and Joining Information Inside Files
• String Functions
• Regular Expression Functions
• Reading, Writing and Deleting Files
• Handling File Permissions
• File Locking
• Reading Directory Contents
• Creating and Deleting Directories

Configuring and Using MySQL

• MySQL as a Client/Server Solution
• Introduction to MySQL Capabilities as a Powerful RDBMS
• Installing and Configuring MySQL
• Connecting to MySQL
• PHP Functions Specific to MySQL
• Executing SQL Calls
• SELECT
• INSERT
• FETCH
• UPDATE
• DELETE
• Using PHP MyAdmin to configure MySQL

Miscellaneous PHP Tasks

• Error Logging
• Session Management and Maintaining State
• Web Application Architecture
• Using Environment Variables
• Changing Execution by Redirecting to Other URLs
• Embedding JavaScript within PHP
• Using the HTTP Protocols to Pass Data
• Showing Different Content to Different Browsers
• Getting IP Addresses from Visitors