Beginner PHP and MySQL Tutorial
4.3 (2,791 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156,568 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Beginner PHP and MySQL Tutorial to your Wishlist.

Add to Wishlist

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.
4.3 (2,791 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156,568 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Price: Free
Includes:
  • 10.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
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.

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
156 Lectures
10:41:59
+
Intro to Beginners PHP
3 Lectures 08:02
Working Files - Download These First
00:01

Intro - What This Course Covers
01:42

What We Need
06:19
+
Getting Started
16 Lectures 42:40
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
+
Our First Look At MySQL And PHP
23 Lectures 01:44:03
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
+
Outputting And Processing Data
16 Lectures 01:03:37
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
+
Dealing With Variables
10 Lectures 45:19
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
+
Inserting And Using Database Data
12 Lectures 39:00
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
+
MySQL Joins
7 Lectures 37:00
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
+
PHP Errors And Security
16 Lectures 01:10:26
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

Managing Users - Create New
03:46

Audit Trails - Access Function
04:22

Audit Trails - Logging Logins
03:07

Errors And Security - Review
01:08
+
Building A Template Page
10 Lectures 41:56
PHP Templates
03:49

Building Our PHP Template CSS/HTML
05:23

Creating Template Menu
05:05

Create Template Login Script
04:45

Template Logout Script
04:28

CMS Switch Statement
03:49

Building Our CMS
04:29

Setting up our CMS Content
06:07

Complete CMS Module
02:16

Review And Exercise
01:45
+
PHP Functions
11 Lectures 58:06
Function Structure
06:40

Built In Functions Maths And Strings
07:43

Built In Functions Date And Time
04:05

Custom Functions
04:08

Format With Functions
03:18

Email Address Checking
07:41

Database Functions
04:34

Array Functions - sort And unique
05:22

Array Functions - search, slice And merge
07:09

Server Variables
04:17

Browser Detection
03:09
4 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
42,734 Reviews
715,312 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.