4.24 out of 5
4.24
8890 reviews on Udemy

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.
Instructor:
Infinite Skills
276,047 students enrolled
English [Auto]
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.

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.

Intro to Beginners PHP

1
Working Files - Download These First
2
Intro - What This Course Covers
3
What We Need

Getting Started

1
Introducing XAMPP
2
Downloading XAMPP
3
XAMPP - Installing
4
XAMPP - Setting Up
5
Setting Up A PHP Editor - bluefish
6
Introduction To bluefish
7
The bluefish Interface
8
bluefish Summary
9
Downloading PHP Snippets
10
PHP Comments
11
Our First PHP Page
12
Using PHP Snippets
13
Intro To MySQL Databases
14
Into To phpMyAdmin
15
External Helpful Resources
16
Exercises

Our First Look At MySQL And PHP

1
Connecting To A MySQL Database - Part 1
2
Connecting To A MySQL Database - Part 2
3
Our First MySQL Query - Part 1
4
Our First MySQL Query - Part 2
5
Creating A MySQL Database
6
Create MySQL Tables - Part 1
7
Create MySQL Tables - Part 2
8
Database Structure
9
Inserting Data in MySQL
10
Updating MySQL Tables
11
Updating MySQL Tables Example
12
MySQL Delete Command
13
Intro To Variables And Operators
14
Arithmetic Operators
15
Assignment Operators
16
Comparison Operators
17
Introduction To Arrays
18
Numeric Arrays
19
Associative Arrays
20
Multi-Dimensional Arrays
21
Creating And Working With Arrays
22
Creating Arrays From A Text File
23
Lesson Review

Outputting And Processing Data

1
Hiding Sensitive Data
2
Including Sensitive Data
3
PHP Echo And Quotes - Part 1
4
PHP Echo And Quotes - Part 2
5
Formatting Using sprintf
6
Outputting Tabular Data
7
Outputting Data And Time
8
Introduction To Loops
9
do...while Loops
10
Repetition - for Loops
11
Repetition - foreach Loops
12
MySQL Select
13
Formatting Outputted MySQL Data
14
MySQL Joins - Overview
15
MySQL Joins
16
MySQL Where And Order By

Dealing With Variables

1
Intro To Sending Variables
2
Using Variables With GET
3
Using Variables With POST
4
Inserting Sent Data In A Database
5
Updating A Database With Sent Data - Part 1
6
Updating A Database With Sent Data - Part 2
7
Redirection In PHP
8
Creating A List - Example
9
Styling The List - Example
10
What We Have Learned

Inserting And Using Database Data

1
Using One Page To Process Forms - Part 1
2
Using One Page To Process Forms - Part 2
3
Multi Part Forms
4
Save And Return POST and GET
5
Save And Return INSERT
6
Save And Return UPDATE
7
Normalization
8
Simple Drop Downs
9
Complex Drop Downs
10
Revised Form - The Code
11
Revised Form - The Result
12
Lesson Review

MySQL Joins

1
MySQL Join Types - Examples
2
MySQL Join Diagrams
3
Creating Nested Lists
4
MySQL Nested Processing
5
Styling Our Lists
6
Intro To Functions
7
Included Files

PHP Errors And Security

1
Introduction To Security And Errors
2
Error Types - Databases
3
PHP Error Types
4
Custom Error Testing
5
Create A Login Page
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.2
4.2 out of 5
8890 Ratings

Detailed Rating

Stars 5
3840
Stars 4
2914
Stars 3
1420
Stars 2
369
Stars 1
347
fd40239d409f6512ac07016546749743
30-Day Money-Back Guarantee

Includes

11 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
This website uses cookies and asks your personal data to enhance your browsing experience.