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