Beginner PHP and MySQL Tutorial

Name: Beginner PHP and MySQL Tutorial
Rating: 4.4 (10745 reviews)

Learn PHP and MySQL and start developing web apps like a pro!

Created byInfinite Skills

Last updated 1/2017

English

What you'll learn

How to download and install PHP and MySQL tools and frameworks onto a server and home machine.
How to configure relevant setting to match the needs of your project.
How to work between a user interface and a database back-end that stores critical information.
How to plan and apply PHP and MySQL to specific examples and finally your own real world projects.

Course content

14 sections • 156 lectures • 10h 41m total length

Working Files - Download These First0:01
Intro - What This Course Covers1:42
What We Need6:19

Introducing XAMPP0:39
Downloading XAMPP0:59
XAMPP - Installing1:55
XAMPP - Setting Up2:19
Setting Up A PHP Editor - bluefish2:34
Introduction To bluefish2:49
The bluefish Interface3:13
bluefish Summary 0:36
Downloading PHP Snippets2:31
PHP Comments4:19
Our First PHP Page5:01
Using PHP Snippets5:22
Intro To MySQL Databases3:14
Into To phpMyAdmin5:20
External Helpful Resources0:42
Exercises1:07

Connecting To A MySQL Database - Part 16:00
Connecting To A MySQL Database - Part 22:59
Our First MySQL Query - Part 16:21
Our First MySQL Query - Part 25:09
Creating A MySQL Database4:08
Create MySQL Tables - Part 13:37
Create MySQL Tables - Part 25:16
Database Structure5:40
Inserting Data in MySQL5:46
Updating MySQL Tables2:39
Updating MySQL Tables Example3:04
MySQL Delete Command6:44
Intro To Variables And Operators4:05
Arithmetic Operators3:38
Assignment Operators5:24
Comparison Operators4:14
Introduction To Arrays3:18
Numeric Arrays2:24
Associative Arrays4:08
Multi-Dimensional Arrays 6:29
Creating And Working With Arrays4:20
Creating Arrays From A Text File7:18
Lesson Review1:22

Hiding Sensitive Data1:57
Including Sensitive Data4:04
PHP Echo And Quotes - Part 15:13
PHP Echo And Quotes - Part 24:53
Formatting Using sprintf5:49
Outputting Tabular Data4:58
Outputting Data And Time5:31
Introduction To Loops2:21
do...while Loops1:51
Repetition - for Loops1:55
Repetition - foreach Loops4:07
MySQL Select4:31
Formatting Outputted MySQL Data2:03
MySQL Joins - Overview3:58
MySQL Joins3:31
MySQL Where And Order By6:55

Intro To Sending Variables1:47
Using Variables With GET7:57
Using Variables With POST3:27
Inserting Sent Data In A Database7:13
Updating A Database With Sent Data - Part 13:14
Updating A Database With Sent Data - Part 25:11
Redirection In PHP4:02
Creating A List - Example6:32
Styling The List - Example4:48
Add a new telephone field to the table and update the PHP list to show headers and the field, with alternating row colors for a richer, styled contact list.
What We Have Learned1:08

Using One Page To Process Forms - Part 12:07
Using One Page To Process Forms - Part 24:08
Multi Part Forms3:58
Save And Return POST and GET2:58
Save And Return INSERT1:50
Save And Return UPDATE3:02
Normalization4:01
Simple Drop Downs4:19
Complex Drop Downs3:58
Revised Form - The Code4:54
Design and upgrade a CRM-like company list using PHP and MySQL, implementing sortable headers with order by fields, dynamic links, and alternating row styles to guide editing records.
Revised Form - The Result2:50
Lesson Review0:55

Introduction To Security And Errors1:25
Error Types - Databases8:25
PHP Error Types6:41
Custom Error Testing3:26
Explore custom error testing in PHP using set_error_handler to capture runtime errors, inspect the default error handler, and understand why syntax errors cannot be trapped in a page script.
Create A Login Page8:12
Passwords For Login3:02
Protecting Pages8:35
Using Cookies - Theory1:33
Using Cookies - Practice4:42
Access Levels - Basic Restriction5:30
Access Levels - Restrict Fields2:51
Managing Users - Structure3:41
Managing Users - Create New3:46
Audit Trails - Access Function4:22
Audit Trails - Logging Logins3:07
Errors And Security - Review1:08

PHP Templates3:49
Building Our PHP Template CSS/HTML5:23
Build a PHP template by splitting styles into two css files—layout and typography—to define the page structure and rendering in a wrapper with header, menu, content, and footer.
Creating Template Menu5:05
Create Template Login Script4:45
Template Logout Script4:28
Learn to implement a template logout script in PHP, processing a status logout query, clearing the login cookie, and reloading index to show the login form or content updates.
CMS Switch Statement3:49
Building Our CMS4:29
Setting up our CMS Content6:07
Complete CMS Module2:16
Review And Exercise1:45

Description

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.

Learn PHP and MySQL and start developing web apps like a pro! Learn PHP and MySQL and start developing web apps like a pro!

Who this course is for:

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.

Beginner PHP and MySQL Tutorial

What you'll learn

Explore related topics

Course content

Intro to Beginners PHP3 lectures • 8min

Getting Started16 lectures • 43min

Our First Look At MySQL And PHP23 lectures • 1hr 44min

Outputting And Processing Data16 lectures • 1hr 4min

Dealing With Variables10 lectures • 45min

Inserting And Using Database Data12 lectures • 39min

MySQL Joins7 lectures • 37min

PHP Errors And Security16 lectures • 1hr 10min

Building A Template Page10 lectures • 42min

PHP Functions11 lectures • 58min

Description

Who this course is for: