Beginner PHP and MySQL Tutorial

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