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.
263 reviews
WHAT'S INSIDE
  • Lifetime access to 157 lectures
  • 10+ hours of high quality content
  • A community of 53200+ students learning together!
  • 610+ discussions
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.

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

  • 183
  • 43
  • 12
  • 6
  • 19
AVERAGE RATING
NUMBER OF RATINGS
263

REVIEWS

  • Ray Leiter
    No indication as to what version of the various systems are required.

    I was using mySQL 5.6 and the examples had "mysql" function calls instead of "mysqli" calls! This kind of thing should be mentioned up-front!

  • Bishnu Mishra

    excellent course

  • Faoud Mohammed
    Pretty indept course

    Very good course but the should have started with html,css,n javascript. The guy is pretty clear when he speaks and I want to thank the authors for taking the time to make this course. Keep up the good work!!!

  • Ilana Rosenblum Guttman
    Thorough but needs to be updated

    The instructor is very thorough but needs to update the materials. The links to the quizzes and exercises no longer exist and lots of people are asking about them in the discussion board. I want to be able to check my work!Also the screenshot video is very blurry, and it doesn't help if I made the video larger. The resolution stinks.

  • Apisake Hongwitayakorn
    great course

    recommend to take this course, it's awesome