Beginner PHP and MySQL Tutorial

Learn PHP and MySQL and start developing web apps like a pro!

4.23 (10548 reviews)
Udemy
platform
English
language
Programming Languages
category
instructor
Beginner PHP and MySQL Tutorial
334,676
students
10.5 hours
content
Jan 2017
last update
FREE
regular price

What you will 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.

Description

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. 


Learn PHP and MySQL and start developing web apps like a pro! Learn PHP and MySQL and start developing web apps like a pro!

Content

Intro to Beginners PHP

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

Getting Started

Introducing XAMPP
Downloading XAMPP
XAMPP - Installing
XAMPP - Setting Up
Setting Up A PHP Editor - bluefish
Introduction To bluefish
The bluefish Interface
bluefish Summary
Downloading PHP Snippets
PHP Comments
Our First PHP Page
Using PHP Snippets
Intro To MySQL Databases
Into To phpMyAdmin
External Helpful Resources
Exercises

Our First Look At MySQL And PHP

Connecting To A MySQL Database - Part 1
Connecting To A MySQL Database - Part 2
Our First MySQL Query - Part 1
Our First MySQL Query - Part 2
Creating A MySQL Database
Create MySQL Tables - Part 1
Create MySQL Tables - Part 2
Database Structure
Inserting Data in MySQL
Updating MySQL Tables
Updating MySQL Tables Example
MySQL Delete Command
Intro To Variables And Operators
Arithmetic Operators
Assignment Operators
Comparison Operators
Introduction To Arrays
Numeric Arrays
Associative Arrays
Multi-Dimensional Arrays
Creating And Working With Arrays
Creating Arrays From A Text File
Lesson Review

Outputting And Processing Data

Hiding Sensitive Data
Including Sensitive Data
PHP Echo And Quotes - Part 1
PHP Echo And Quotes - Part 2
Formatting Using sprintf
Outputting Tabular Data
Outputting Data And Time
Introduction To Loops
do...while Loops
Repetition - for Loops
Repetition - foreach Loops
MySQL Select
Formatting Outputted MySQL Data
MySQL Joins - Overview
MySQL Joins
MySQL Where And Order By

Dealing With Variables

Intro To Sending Variables
Using Variables With GET
Using Variables With POST
Inserting Sent Data In A Database
Updating A Database With Sent Data - Part 1
Updating A Database With Sent Data - Part 2
Redirection In PHP
Creating A List - Example
Styling The List - Example
What We Have Learned

Inserting And Using Database Data

Using One Page To Process Forms - Part 1
Using One Page To Process Forms - Part 2
Multi Part Forms
Save And Return POST and GET
Save And Return INSERT
Save And Return UPDATE
Normalization
Simple Drop Downs
Complex Drop Downs
Revised Form - The Code
Revised Form - The Result
Lesson Review

MySQL Joins

MySQL Join Types - Examples
MySQL Join Diagrams
Creating Nested Lists
MySQL Nested Processing
Styling Our Lists
Intro To Functions
Included Files

PHP Errors And Security

Introduction To Security And Errors
Error Types - Databases
PHP Error Types
Custom Error Testing
Create A Login Page
Passwords For Login
Protecting Pages
Using Cookies - Theory
Using Cookies - Practice
Access Levels - Basic Restriction
Access Levels - Restrict Fields
Managing Users - Structure
Managing Users - Create New
Audit Trails - Access Function
Audit Trails - Logging Logins
Errors And Security - Review

Building A Template Page

PHP Templates
Building Our PHP Template CSS/HTML
Creating Template Menu
Create Template Login Script
Template Logout Script
CMS Switch Statement
Building Our CMS
Setting up our CMS Content
Complete CMS Module
Review And Exercise

PHP Functions

Function Structure
Built In Functions Maths And Strings
Built In Functions Date And Time
Custom Functions
Format With Functions
Email Address Checking
Database Functions
Array Functions - sort And unique
Array Functions - search, slice And merge
Server Variables
Browser Detection

Using External Files, And Images

Reading Text Files
Writing Text Files
Working With Image Files - exif
Creating Image Files With GD Library
Managing Images With GD Library
Resizing Images With PHP
Uploading Files - Overview
Uploading Files - In Action
Remote File Parsing

Email With PHP

Email With PHP And MySQL
Sendmail SMTP Server
Sendmail mail Function
PHP mail CC And BCC
HTML email Content
Email Out - Hiding SMTP Address
Email Out - Embedded Form
Logging Sent Email

Real Life PHP Introduction

Real Life Introduction
Building PHP Tools - Button Maker
Building PHP Tools - Embedded Tool
Managing Deletions - Suspension Fields
Managing Deletions - Suspend Record
Managing Deletions - Restore Records
OO Programming - A Caveat
OO Programming Model - DB Connection
OO Programming - DB Examples
CMS Open Source
CMS Joomla
CRM Download And Extract
CRM vTiger Install
CRM Modifying vTiger

About The Author

About The Author

Reviews

Dominic
November 5, 2023
I'm always liked the idea of building websites and defaulted to using frontend frameworks to design however, I am learning my first language so I will be better equipped for the coding world
Snehil
July 24, 2023
As this video is too old, some of the information since then has changed which is little confusing. Also specifying the version of the XAMPP would be beneficial as the latest version is little different than the one used in the video
Glen
July 8, 2023
Course are good explanation and with a good pace, it come with a lot of examples. The course is very long and some functions are deprecated.
Sarah
January 10, 2023
The instructor is good, it's just that the course is so old, the syntax is deprecated. When I went to connect the database, I got the error "localhost is currently unable to handle this request; HTTP ERROR 500" in Chrome. I could look up the current syntax, but I figured that the whole course would be full of stuff like this, and decided to call it quits at that point.
Ankit
December 5, 2022
Did not tell what to do in case of chrome and windows 10 second how to resolve the error. I have to visit youtube to sort this then what's the purpose of having this course
Dan
September 28, 2022
A well knowledgeable tutor and well planned course connect. I've learned very essential concepts about MySQL and PHP languages in this course and woud like to ba a subscriber.
Raghu
July 14, 2022
A lot of the course is dependent on snippets that are no longer available. Udemy should have archived such a course or made it free as it is deprecated and no longer relevant to the newer versions. It is more Udemy's fault that they still made this available as a paid course when most of the content is obsolete and there is no alternative.
Peter
June 27, 2022
Examples work as they should. Only issue is a trojan tied to the download of bluefish prevents a full download and causes me not to get color assistance with my cod.
Armando
June 18, 2022
Curso muito antigo. Bom para dar uma vista de olhos e aprender algumas informações importantes. Mas pode ser uma experiência enriquecedora tentar implementar a parte prática do curso e perceber como as tecnologias usadas evoluíram.
Lon
May 5, 2022
This is 12 years old but I'm finding it a good refresher as well as learning some new things I did not know. Very informative with basic examples that aren't confusing but communicate how php works.
David
April 10, 2022
This course should be removed from the Udemy catalogue. The accompanying website and its resource no longer exist. This makes it difficult to follow the course as it refers to these resources extensively. Rather find a current course if you wish to learn PHP. Apart from that, the PHP and MySQL commands used in this course have been deprecated and no longer work. Avoid this course.
Maris
February 5, 2022
The webpages are very outdated, some of the pages shown don't exist anymore. However you can complete most of the steps needed so far.
Punit
November 21, 2021
Training is great. Instructor is very well versed with explaining nuances of programming and how to build a workable program.
Ozzy
November 15, 2021
The examples for the course do not resemble the current version of XAMPP but is close enough to understand. I would have liked that the course has a more current version of the app to go over.
Tommy
November 13, 2021
The instruction is very thorough with description of abbreviated words so there is no misunderstanding to what it means. The cadence is slow and I think I'd still be comfortable with 1.5X. I'm very disappointed that the links to examples and additional help are no longer available. That is a big downfall even though I'm learning I can not recommend this course.

Charts

Price

Beginner PHP and MySQL Tutorial - Price chart

Rating

Beginner PHP and MySQL Tutorial - Ratings chart

Enrollment distribution

Beginner PHP and MySQL Tutorial - Distribution chart

Related Topics

9711
udemy ID
9/16/2011
course created date
8/15/2019
course indexed date
Bot
course submited by