You can learn anything on Udemy. Start today with one of our 10,000+ online courses

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.
271 reviews
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills courses are taught by experts who have a true passion for teaching.

WHAT'S INSIDE
  • Lifetime access to 157 lectures
  • 10+ hours of high quality content
  • A community of 63600+ students learning together!
  • 670+ discussions
SHARE

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.
271 reviews
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.

    • 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.
    • 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
  • 1
    Working Files - Download These First
    Text
  • 2
    Intro - What This Course Covers
    01:42
  • 3
    What We Need
    06:19
  • 4
    How to obtain your Certificate of Completion for this Infinite Skills course.
    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
  • 5
    Introducing XAMPP
    00:39
  • 6
    Downloading XAMPP
    00:59
  • 7
    XAMPP - Installing
    01:55
  • 8
    XAMPP - Setting Up
    02:19
  • 9
    Setting Up A PHP Editor - bluefish
    02:34
  • 10
    Introduction To bluefish
    02:49
  • 11
    The bluefish Interface
    03:13
  • 12
    bluefish Summary
    00:36
  • 13
    Downloading PHP Snippets
    02:31
  • 14
    PHP Comments
    04:19
  • 15
    Our First PHP Page
    05:01
  • 16
    Using PHP Snippets
    05:22
  • 17
    Intro To MySQL Databases
    03:14
  • 18
    Into To phpMyAdmin
    05:20
  • 19
    External Helpful Resources
    00:42
  • 20
    Exercises
    01:07
  • SECTION 3:
    Our First Look At MySQL And PHP
  • 21
    Connecting To A MySQL Database - Part 1
    06:00
  • 22
    Connecting To A MySQL Database - Part 2
    02:59
  • 23
    Our First MySQL Query - Part 1
    06:21
  • 24
    Our First MySQL Query - Part 2
    05:09
  • 25
    Creating A MySQL Database
    04:08
  • 26
    Create MySQL Tables - Part 1
    03:37
  • 27
    Create MySQL Tables - Part 2
    05:16
  • 28
    Database Structure
    05:40
  • 29
    Inserting Data in MySQL
    05:46
  • 30
    Updating MySQL Tables
    02:39
  • 31
    Updating MySQL Tables Example
    03:04
  • 32
    MySQL Delete Command
    06:44
  • 33
    Intro To Variables And Operators
    04:05
  • 34
    Arithmetic Operators
    03:38
  • 35
    Assignment Operators
    05:24
  • 36
    Comparison Operators
    04:14
  • 37
    Introduction To Arrays
    03:18
  • 38
    Numeric Arrays
    02:24
  • 39
    Associative Arrays
    04:08
  • 40
    Multi-Dimensional Arrays
    06:29
  • 41
    Creating And Working With Arrays
    04:20
  • 42
    Creating Arrays From A Text File
    07:18
  • 43
    Lesson Review
    01:22
  • SECTION 4:
    Outputting And Processing Data
  • 44
    Hiding Sensitive Data
    01:57
  • 45
    Including Sensitive Data
    04:04
  • 46
    PHP Echo And Quotes - Part 1
    05:13
  • 47
    PHP Echo And Quotes - Part 2
    04:53
  • 48
    Formatting Using sprintf
    05:49
  • 49
    Outputting Tabular Data
    04:58
  • 50
    Outputting Data And Time
    05:31
  • 51
    Introduction To Loops
    02:21
  • 52
    do...while Loops
    01:51
  • 53
    Repetition - for Loops
    01:55
  • 54
    Repetition - foreach Loops
    04:07
  • 55
    MySQL Select
    04:31
  • 56
    Formatting Outputted MySQL Data
    02:03
  • 57
    MySQL Joins - Overview
    03:58
  • 58
    MySQL Joins
    03:31
  • 59
    MySQL Where And Order By
    06:55
  • SECTION 5:
    Dealing With Variables
  • 60
    Intro To Sending Variables
    01:47
  • 61
    Using Variables With GET
    07:57
  • 62
    Using Variables With POST
    03:27
  • 63
    Inserting Sent Data In A Database
    07:13
  • 64
    Updating A Database With Sent Data - Part 1
    03:14
  • 65
    Updating A Database With Sent Data - Part 2
    05:11
  • 66
    Redirection In PHP
    04:02
  • 67
    Creating A List - Example
    06:32
  • 68
    Styling The List - Example
    04:48
  • 69
    What We Have Learned
    01:08
  • SECTION 6:
    Inserting And Using Database Data
  • 70
    Using One Page To Process Forms - Part 1
    02:07
  • 71
    Using One Page To Process Forms - Part 2
    04:08
  • 72
    Multi Part Forms
    03:58
  • 73
    Save And Return POST and GET
    02:58
  • 74
    Save And Return INSERT
    01:50
  • 75
    Save And Return UPDATE
    03:02
  • 76
    Normalization
    04:01
  • 77
    Simple Drop Downs
    04:19
  • 78
    Complex Drop Downs
    03:58
  • 79
    Revised Form - The Code
    04:54
  • 80
    Revised Form - The Result
    02:50
  • 81
    Lesson Review
    00:55
  • SECTION 7:
    MySQL Joins
  • 82
    MySQL Join Types - Examples
    05:57
  • 83
    MySQL Join Diagrams
    01:44
  • 84
    Creating Nested Lists
    04:34
  • 85
    MySQL Nested Processing
    03:32
  • 86
    Styling Our Lists
    05:11
  • 87
    Intro To Functions
    07:34
  • 88
    Included Files
    08:28
  • SECTION 8:
    PHP Errors And Security
  • 89
    Introduction To Security And Errors
    01:25
  • 90
    Error Types - Databases
    08:25
  • 91
    PHP Error Types
    06:41
  • 92
    Custom Error Testing
    03:26
  • 93
    Create A Login Page
    08:12
  • 94
    Passwords For Login
    03:02
  • 95
    Protecting Pages
    08:35
  • 96
    Using Cookies - Theory
    01:33
  • 97
    Using Cookies - Practice
    04:42
  • 98
    Access Levels - Basic Restriction
    05:30
  • 99
    Access Levels - Restrict Fields
    02:51
  • 100
    Managing Users - Structure
    03:41

RATING

  • 188
  • 43
  • 13
  • 6
  • 21
AVERAGE RATING
NUMBER OF RATINGS
271

REVIEWS

  • Brigitte Breindl
    free should really mean free!!!

    how can you list this course as "free" while that's true only for the first 26 of 157 lectures - after that, you have to pay for the rest !?!?!?!?

  • Pavan Kumar A G
    Course is super duper awesome one

    This is what i like, complete end to end and comprehensive explanation. What not ? with complete source coder and snippets. Awesome . To me all code worked well and legible also. Believe it or not, using this tutorial i built a web app for my internal team to manager few stuffs. Thanks a lot.

  • Brian Riley
    "Free" course not completely free?

    I worked through this course, correcting for changes in tools and resources. Dealt with the authors quirks in using 2-3 minute "Lectures" that rely heavily on Bluefish editor to use the snippet feature, constant "delete everything we just went over and start a new file", or "lets do the same 5 things over and over and over again". put up with these quirks and others only to find that after Lecture 142 of 157 you receive a message "Thanks for previewing the free portion of this course, please go to this site and pay me money to get the rest". If it's not all free, don't list it as free, and if no one wants to pay for it they will ignore it and go on to another course.

  • Heriberto Munoz
    Best Foundation Course

    Anyone starting with PHP and MySQL should start with this course. The resources are tremendous and a strong lift in getting you jumping into a future of developing.

  • Paulo Roberto Menezes
    Lots of Snippets

    The course brings good subjects, but they are all predefined. I think if it was raw from the start it would be better.

  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion