Description
What will you learn:-
- How to instal PHP and MySQL tools and frameworks on a server and a personal computer.
- How to configure appropriate settings to meet your project's requirements.
- How to connect a user interface to a database back-end that maintains important data.
- How to plan and implement PHP and MySQL in real-world scenarios before moving on to your own projects.
Syllabus:-
-
Working Files - Download These First
-
Intro - What This Course Covers
-
What We Need
-
Introducing XAMPP
-
Downloading XAMPP
-
XAMPP - Installing
-
XAMPP - Setting Up
-
Setting Up A PHP Editor - bluefish
-
Introduction To bluefish
-
The bluefish Interface
-
bluefish Summary
-
Downloading PHP Snippets
-
PHP Comments
-
Our First PHP Page
-
Using PHP Snippets
-
Intro To MySQL Databases
-
Into To phpMyAdmin
-
External Helpful Resources
-
Exercises
-
Connecting To A MySQL Database - Part 1
-
Connecting To A MySQL Database - Part 2
-
Our First MySQL Query - Part 1
-
Our First MySQL Query - Part 2
-
Creating A MySQL Database
-
Create MySQL Tables - Part 1
-
Create MySQL Tables - Part 2
-
Database Structure
-
Inserting Data in MySQL
-
Updating MySQL Tables
-
Updating MySQL Tables Exmple
-
MySQL Delete Command
-
Intro To Variables And Operators
-
Arithmetic Operators
-
Assignment Operators
-
Comparison Operators
-
Introduction To Arrays
-
Numeric Arrays
-
Associative Arrays
-
Multi-Dimensional Arrays
-
Creating And Working With Arrays
-
Creating Arrays From A Text File
-
Lesson Review
-
Hiding Sensitive Data
-
Including Sensitive Data
-
PHP Echo And Quotes - Part 1
-
PHP Echo And Quotes - Part 2
-
Formatting Using sprint
-
Outputting Tabular Data
-
Outputting Data And Time
-
Introduction To Loops
-
do...while Loops
-
Repetition - for Loops
-
Repetition - foreach Loops
-
MySQL Select
-
Formatting Outputted MySQL Data
-
MySQL Joins - Overview
-
MySQL Joins
-
MySQL Where And Order By
-
Intro To Sending Variables
-
Using Variables With GET
-
Using Variables With POST
-
Inserting Sent Data In A Database
-
Updating A Database With Sent Data - Part 1
-
Updating A Database With Sent Data - Part 2
-
Redirection In PHP
-
Creating A List - Example
-
Styling The List - Example
-
What We Have Learned
-
Using One Page To Process Forms - Part 1
-
Using One Page To Process Forms - Part 2
-
Multi Part Forms
-
Save And Return POST and GET
-
Save And Return INSERT
-
Save And Return UPDATE
-
Normalization
-
Simple Drop Downs
-
Complex Drop Downs
-
Revised Form - The Code
-
Revised Form - The Result
-
Lesson Review
-
MySQL Join Types - Examples
-
MySQL Join Diagrams
-
Creating Nested Lists
-
MySQL Nested Processing
-
Styling Our Lists
-
Intro To Functions
-
Included Files
-
Introduction To Security And Errors
-
Error Types - Databases
-
PHP Error Types
-
Custom Error Testing
-
Create A Login Page
-
Passwords For Login
-
Protecting Pages
-
Using Cookies - Theory
-
Using Cookies - Practice
-
Access Levels - Basic Restriction
-
Access Levels - Restrict Fields
-
Managing Users - Structure
-
Managing Users - Create New
-
Audit Trails - Access Function
-
Audit Trails - Logging Logins
-
Errors And Security - Review
-
PHP Templates
-
Building Our PHP Template CSS/HTML
-
Creating Template Menu
-
Create Template Login Script
-
Template Logout Script
-
CMS Switch Statement
-
Building Our CMS
-
Setting up our CMS Content
-
Complete CMS Module
-
Review And Exercise
-
Function Structure
-
Built In Functions Maths And Strings
-
Built In Functions Date And Time
-
Custom Functions
-
Format With Functions
-
Email Address Checking
-
Database Functions
-
Array Functions - sort And unique
-
Array Functions - search, slice And merge
-
Server Variables
-
Browser Detection