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

                                                                                                                                                                                                        • 204
                                                                                                                                                                                                        • 48
                                                                                                                                                                                                        • 12
                                                                                                                                                                                                        • 6
                                                                                                                                                                                                        • 18
                                                                                                                                                                                                        AVERAGE RATING
                                                                                                                                                                                                        NUMBER OF RATINGS
                                                                                                                                                                                                        288

                                                                                                                                                                                                        REVIEWS

                                                                                                                                                                                                        • 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

                                                                                                                                                                                                        • Will Johnson
                                                                                                                                                                                                          Easy to follow and understand

                                                                                                                                                                                                          I found this in 2011 but have only now started it. Wish I had started it then, this is easy to follow and very informative. Appreciate the instructor's pace and explanation style.

                                                                                                                                                                                                        • Safwan Shahar

                                                                                                                                                                                                          good clear voice and clearly explained step by step,157 lectures in total