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. show more
XAMPP - Installing00:01:55
XAMPP - Setting Up00:02:19
Setting Up A PHP Editor - bluefish00:02:34
Introduction To bluefish00:02:49
The bluefish Interface00:03:13
Downloading PHP Snippets00:02:31
Our First PHP Page00:05:01
Using PHP Snippets00:05:22
Intro To MySQL Databases00:03:14
Into To phpMyAdmin00:05:20
Into To phpMyAdmin00:05:20
External Helpful Resources00:00:42
Connecting To A MySQL Database - Part 100:06:00
Connecting To A MySQL Database - Part 200:02:59
Our First MySQL Query - Part 100:06:21
Our First MySQL Query - Part 200:05:09
Creating A MySQL Database00:04:08
Create MySQL Tables - Part 100:03:37
Create MySQL Tables - Part 200:05:16
Inserting Data in MySQL00:05:46
Updating MySQL Tables00:02:39
Updating MySQL Tables Example00:03:04
MySQL Delete Command00:06:44
Intro To Variables And Operators00:04:05
Introduction To Arrays00:03:18
Creating And Working With Arrays00:04:20
Creating Arrays From A Text File00:07:18
Hiding Sensitive Data00:01:57
Including Sensitive Data00:04:04
PHP Echo And Quotes - Part 100:05:13
PHP Echo And Quotes - Part 200:04:59
Formatting Using sprintf00:05:49
Outputting Tabular Data00:04:58
Outputting Data And Time00:05:31
Introduction To Loops00:02:21
Repetition - for Loops00:01:55
Repetition - foreach Loops00:04:07
Formatting Outputted MySQL Data00:02:03
MySQL Joins - Overview00:03:58
MySQL Where And Order By00:06:55
Intro To Sending Variables00:01:41
Using Variables With GET00:07:57
Using Variables With POST00:03:27
Inserting Sent Data In A Database00:07:13
Updating A Database With Sent Data - Part 100:03:14
Updating A Database With Sent Data - Part 200:05:11