Beginner PHP and MySQL Tutorial

Learn PHP and MySQL and start developing web apps like a pro! This course also comes with a Certificate of Completion.
  • Lectures 157
  • Video 11 Hours
  • Skill level all level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Course Description

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.

What am I going to get from this course?

  • Over 157 lectures and 10.5 hours of content!
  • 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.

What 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.

Curriculum

Section 1: Intro to Beginners PHP
Working Files - Download These First
Text
Intro - What This Course Covers
01:42
What We Need
06:19
Text
All Users of this course are eligible for a Certificate of Completion. Each certificate is issued with a unique number which allows verification that the user has undertaken the course listed. In order to obtain your certificate you should visit the URL below:- http://www.infiniteskills.com/cert/016…
Section 2: Getting Started
Introducing XAMPP
00:39
Downloading XAMPP
00:59
XAMPP - Installing
01:55
XAMPP - Setting Up
02:19
Setting Up A PHP Editor - bluefish
02:34
Introduction To bluefish
02:49
The bluefish Interface
03:13
bluefish Summary
00:36
Downloading PHP Snippets
02:31
PHP Comments
04:19
Our First PHP Page
05:01
Using PHP Snippets
05:22
Intro To MySQL Databases
03:14
Into To phpMyAdmin
05:20
External Helpful Resources
00:42
Exercises
01:07
Section 3: Our First Look At MySQL And PHP
Connecting To A MySQL Database - Part 1
06:00
Connecting To A MySQL Database - Part 2
02:59
Our First MySQL Query - Part 1
06:21
Our First MySQL Query - Part 2
05:09
Creating A MySQL Database
04:08
Create MySQL Tables - Part 1
03:37
Create MySQL Tables - Part 2
05:16
Database Structure
05:40
Inserting Data in MySQL
05:46
Updating MySQL Tables
02:39
Updating MySQL Tables Example
03:04
MySQL Delete Command
06:44
Intro To Variables And Operators
04:05
Arithmetic Operators
03:38
Assignment Operators
05:24
Comparison Operators
04:14
Introduction To Arrays
03:18
Numeric Arrays
02:24
Associative Arrays
04:08
Multi-Dimensional Arrays
06:29
Creating And Working With Arrays
04:20
Creating Arrays From A Text File
07:18
Lesson Review
01:22
Section 4: Outputting And Processing Data
Hiding Sensitive Data
01:57
Including Sensitive Data
04:04
PHP Echo And Quotes - Part 1
05:13
PHP Echo And Quotes - Part 2
04:53
Formatting Using sprintf
05:49
Outputting Tabular Data
04:58
Outputting Data And Time
05:31
Introduction To Loops
02:21
do...while Loops
01:51
Repetition - for Loops
01:55
Repetition - foreach Loops
04:07
MySQL Select
04:31
Formatting Outputted MySQL Data
02:03
MySQL Joins - Overview
03:58
MySQL Joins
03:31
MySQL Where And Order By
06:55
Section 5: Dealing With Variables
Intro To Sending Variables
01:47
Using Variables With GET
07:57
Using Variables With POST
03:27
Inserting Sent Data In A Database
07:13
Updating A Database With Sent Data - Part 1
03:14
Updating A Database With Sent Data - Part 2
05:11
Redirection In PHP
04:02
Creating A List - Example
06:32
Styling The List - Example
04:48
What We Have Learned
01:08
Section 6: Inserting And Using Database Data
Using One Page To Process Forms - Part 1
02:07
Using One Page To Process Forms - Part 2
04:08
Multi Part Forms
03:58
Save And Return POST and GET
02:58
Save And Return INSERT
01:50
Save And Return UPDATE
03:02
Normalization
04:01
Simple Drop Downs
04:19
Complex Drop Downs
03:58
Revised Form - The Code
04:54
Revised Form - The Result
02:50
Lesson Review
00:55
Section 7: MySQL Joins
MySQL Join Types - Examples
05:57
MySQL Join Diagrams
01:44
Creating Nested Lists
04:34
MySQL Nested Processing
03:32
Styling Our Lists
05:11
Intro To Functions
07:34
Included Files
08:28
Section 8: PHP Errors And Security
Introduction To Security And Errors
01:25
Error Types - Databases
08:25
PHP Error Types
06:41
Custom Error Testing
03:26
Create A Login Page
08:12
Passwords For Login
03:02
Protecting Pages
08:35
Using Cookies - Theory
01:33
Using Cookies - Practice
04:42
Access Levels - Basic Restriction
05:30
Access Levels - Restrict Fields
02:51
Managing Users - Structure
03:41

Instructor Biography

O'Reilly Media , High Quality Training

O'Reilly spreads the knowledge of innovators through its technology books, online services, magazines, research, and tech conferences. Since 1978, O'Reilly has been a chronicler and catalyst of leading-edge development, homing in on the technology trends that really matter and galvanizing their adoption by amplifying "faint signals" from the alpha geeks who are creating the future. An active participant in the technology community, O'Reilly has a long history of advocacy, meme-making, and evangelism.

Reviews

Average Rating
4.4
Details
  1. 5 Stars
    192
  2. 4 Stars
    43
  3. 3 Stars
    16
  4. 2 Stars
    6
  5. 1 Stars
    21
    • Normunds Pauders

    Great course

    I like this course.:) It was intresting and great.:)

    • Frank DiMartino

    Basics but buggy

    This course helped me understand the basics of the php mySQL relationship. The code snippets were buggy and the instructor moved a little too fast at times while trying to explain basic fuctions.

    • Kyle Anunciacion

    My Review

    The video is too old. Xampp version too old. Used old os. Time consuming tutorial. He doesn't need to explain how to open an application by double cliking it.

    • Reinhard Mohr

    Excellent

    Very detailed yet comprehensive. The code snippets that are provided are extremely helpful. I could immediately use them in my own projects.

    • Daniel Wilson

    Very solid intro - great stuff!

    This guy's style is great. Hands on, good pacing, points you in good places to find more in-depth info, and you'll have something nice to show off to your nerd buddies at the end. Also, I like this guy's voice :D

Show more reviews

What you get with this course

30 day money back guarantee

Lifetime access

Available on desktop, iOS and Android

Certificate of completion

Join the biggest student community

5,900,000

Hours of video content

22,000,000

Course enrollment

6,500,000

Students

Ready to start learning?
Enroll for free now