Beginner PHP and MySQL Tutorial

Visit Tutorial Page ( Report)
A Verifiable Certificate of Completion is presented to all students who undertake this course. PHP and MySQL are incredibly powerful open source technologies that allow people to create functional websites and apps that go way beyond basic HTML. While it can seem intimidating to someone with no background in coding, working with PHP is much easier than many realize. With the right guidance and a desire to learn, most people can learn how to put together a functional web app in a few days! This PHP / MySQL Tutorial Video Course is narrated by Robert Tucker, a long-time trainer, lecturer and consultant who specializes in helping people learn how to use technology to solve real world problems. In this high-impact course, Robert walks users through the creation of a functional PHP / MySQL interface from beginning to end, explaining where needed the important technical points without relying on excessive jargon. This is not an overview of complex theory, but a hands-on primer that will allow even beginners to create usable solutions quickly! Robert shows you how to make the most from these free technologies used by everyone from small startups to the biggest technology companies in the world. Who is the target audience? Anyone who wants to build a website that goes beyond the requirements of basic HTML and CSS. Anyone who wants to learn how to build an app that can handle data and interface with end users at the same time. Anyone who wants to learn how MySQL can function as a database solution. Anyone who wants to learn basic programming and development skills without days of digging through technical books.
  • Introducing XAMPP
    00:00:39
  • Downloading XAMPP
    00:00:59
  • XAMPP - Installing
    00:01:55
  • XAMPP - Setting Up
    00:02:19
  • Setting Up A PHP Editor - bluefish
    00:02:34
  • Introduction To bluefish
    00:02:49
  • The bluefish Interface
    00:03:13
  • bluefish Summary
    00:00:36
  • Downloading PHP Snippets
    00:02:31
  • PHP Comments
    00:04:19
  • Our First PHP Page
    00:05:01
  • Using PHP Snippets
    00:05:22
  • Intro To MySQL Databases
    00:03:14
  • Into To phpMyAdmin
    00:05:20
  • Into To phpMyAdmin
    00:05:20
  • External Helpful Resources
    00:00:42
  • Exercises
    00:01:07
  • Exercises
    00:01:07
  • Connecting To A MySQL Database - Part 1
    00:06:00
  • Connecting To A MySQL Database - Part 2
    00:02:59
  • Our First MySQL Query - Part 1
    00:06:21
  • Our First MySQL Query - Part 2
    00:05:09
  • Creating A MySQL Database
    00:04:08
  • Create MySQL Tables - Part 1
    00:03:37
  • Create MySQL Tables - Part 2
    00:05:16
  • Database Structure
    00:05:40
  • Inserting Data in MySQL
    00:05:46
  • Updating MySQL Tables
    00:02:39
  • Updating MySQL Tables Example
    00:03:04
  • MySQL Delete Command
    00:06:44
  • Intro To Variables And Operators
    00:04:05
  • Arithmetic Operators
    00:03:38
  • Assignment Operators
    00:05:24
  • Comparison Operators
    00:04:14
  • Introduction To Arrays
    00:03:18
  • Numeric Arrays
    00:02:24
  • Associative Arrays
    00:04:08
  • Multi-Dimensional Arrays
    00:06:29
  • Creating And Working With Arrays
    00:04:20
  • Creating Arrays From A Text File
    00:07:18
  • Lesson Review
    00:01:22
  • Hiding Sensitive Data
    00:01:57
  • Including Sensitive Data
    00:04:04
  • PHP Echo And Quotes - Part 1
    00:05:13
  • PHP Echo And Quotes - Part 2
    00:04:59
  • Formatting Using sprintf
    00:05:49
  • Outputting Tabular Data
    00:04:58
  • Outputting Data And Time
    00:05:31
  • Introduction To Loops
    00:02:21
  • do...while Loops
    00:01:51
  • Repetition - for Loops
    00:01:55
  • Repetition - foreach Loops
    00:04:07
  • MySQL Select
    00:04:31
  • Formatting Outputted MySQL Data
    00:02:03
  • MySQL Joins - Overview
    00:03:58
  • MySQL Joins
    00:03:31
  • MySQL Where And Order By
    00:06:55
  • Intro To Sending Variables
    00:01:41
  • Using Variables With GET
    00:07:57
  • Using Variables With POST
    00:03:27
  • Inserting Sent Data In A Database
    00:07:13
  • Updating A Database With Sent Data - Part 1
    00:03:14
  • Updating A Database With Sent Data - Part 2
    00:05:11
  • Redirection In PHP
    00:04:02
  • Creating A List - Example
    00:06:32
  • Styling The List - Example
    00:04:48
  • What We Have Learned
    00:01:08
  • Using One Page To Process Forms - Part 1
    00:02:07
  • Using One Page To Process Forms - Part 2
    00:04:08
  • Multi Part Forms
    00:03:58
  • Save And Return POST and GET
    00:02:58
  • Save And Return INSERT
    00:01:50
  • Save And Return UPDATE
    00:03:02
  • Normalization
    00:04:01
  • Simple Drop Downs
    00:04:19
  • Complex Drop Downs
    00:03:58
  • Revised Form - The Code
    00:04:54
  • Revised Form - The Result
    00:02:50
  • MySQL Join Types - Examples
    00:05:57
  • MySQL Join Diagrams
    00:01:44
  • Creating Nested Lists
    00:04:34
  • MySQL Nested Processing
    00:03:32
  • Styling Our Lists
    00:05:11
  • Intro To Functions
    00:07:34
  • Included Files
    00:08:28
  • Introduction To Security And Errors
    00:01:25
  • Error Types - Databases
    00:08:25
  • PHP Error Types
    00:06:41
  • Custom Error Testing
    00:03:36
  • Create A Login Page
    00:08:12
  • Passwords For Login
    00:03:02
  • Protecting Pages
    00:08:35
  • Using Cookies - Theory
    00:01:33
  • Using Cookies - Practice
    00:04:42
  • Access Levels - Basic Restriction
    00:05:30
  • Access Levels - Restrict Fields
    00:02:51
  • Managing Users - Structure
    00:03:41
  • Managing Users - Create New
    00:03:46
  • Audit Trails - Access Function
    00:04:22
  • Audit Trails - Logging Logins
    00:03:07
  • Errors And Security - Review
    00:01:08
  • PHP Templates
    00:03:49
  • Building Our PHP Template CSS/HTML
    00:05:23
  • Creating Template Menu
    00:05:05
  • Create Template Login Script
    00:04:45
  • Template Logout Script
    00:04:28
  • CMS Switch Statement
    00:03:49
  • Building Our CMS
    00:04:29
  • Setting up our CMS Content
    00:06:07
  • Complete CMS Module
    00:02:16
  • Review And Exercise
    00:01:45
  • Function Structure
    00:06:40
  • Built In Functions Maths And Strings
    00:07:43
  • Built In Functions Date And Time
    00:04:05
  • Custom Functions
    00:04:08
  • Format With Functions
    00:03:18
  • Email Address Checking
    00:07:41
  • Database Functions
    00:04:34
  • Array Functions - sort And unique
    00:05:22
  • Array Functions - search, slice And merge
    00:07:09
  • Server Variables
    00:04:17
  • Browser Detection
    00:03:09
  • Using External Files, And Images
    00:44:07
  • Email With PHP
    00:34:27
  • Real Life Introduction
    00:01:29
  • Building PHP Tools - Button Maker
    00:05:30
  • Building PHP Tools - Embedded Tool
    00:03:59
  • Managing Deletions - Suspension Fields
    00:03:29
  • Managing Deletions - Suspend Record
    00:05:28
  • Managing Deletions - Restore Records
    00:05:08
  • OO Programming - A Caveat
    00:02:06
  • OO Programming Model - DB Connection
    00:03:37
  • OO Programming - DB Examples
    00:06:05
  • CMS Open Source
    00:01:29
  • CMS Joomla
    00:04:56
  • CRM Download And Extract
    00:03:05
  • CRM vTiger Install
    00:03:39
  • CRM Modifying vTiger
    00:02:01
  • About The Author
    00:01:15
Write Your Review

Reviews