PHP for Beginners

Build a Content Management System from Scratch with PHP and MySQL

Instructor

Dave Hollingworth

Requirements

Access to a computer running Windows, Mac OS X or Linux.

What you will learn

Learn how to create a dynamic website using the most popular website programming language
Build a working CMS in PHP and MySQL from scratch
Learn how to secure your code
Learn how to write reusable, more maintainable code using programming standards
Learn how to structure your code using object-oriented programming techniques
Learn the theory but then put it into practice in a CMS project
Style your site using Bootstrap
How to integrate third-party code into your site
How to store data in a relational database and use this from PHP code
Learn all aspects of a basic web application in PHP: login, CRUD operations, sending emails, uploading files, Ajax

Who should attend

Anyone wanting to learn both the PHP language and how to create web applications

Is available on google app?

Yes

Is available on ios?

Yes

Course Features

Lectures 203
Quizzes 33
Exercises 12
Duration 14 total hours
Skill level Beginner Level
Students 21420
Last Updated November, 2024

Introduction 01:32
- Lecture
  Introduction: How to Get the Most Out of the Course 01:32
Software Installation and Setup 24:56
- Lecture
  Recommended Software Overview 02:39
- Lecture
  Install XAMPP on Windows 04:34
- Lecture
  Install XAMPP on MAC OS X 05:30
- Lecture
  Install XAMPP on Ubuntu Linux 03:49
- Lecture
  Addendum: Visual Studio Code now the recommended editor 00:12
- Lecture
  Install Atom on Windows 02:24
- Lecture
  Install Atom on MAC OS X 03:24
- Lecture
  Install Atom on Ubuntu Linux 02:24
Variables 25:26
- Lecture
  Write Your First PHP Code: Display a Message in Your Web Browser 03:58
- Lecture
  Variables in PHP: What They are, How to Create Them, and How to Name Them 04:16
- Lecture
  Basic Variable Types: Strings and Numbers 04:58
- Lecture
  Basic Variable Types: Boolean and Null 03:02
- Lecture
  Perform Operations on Variables: Operators 05:36
- Lecture
  Strings: Using Single or Double Quotes and Variable Interpolation 03:36
- Quiz
  PHP concepts, variables and operators 9 questions
- Quiz
  Variables and Operators 1 question
Arrays 21:24
- Lecture
  Introduction to Arrays: Create an Array and Access its Elements 05:04
- Lecture
  Assign Manual Array Indexes and Create Associative Arrays 03:39
- Lecture
  Create and Access Multidimensional Arrays 06:46
- Lecture
  Process Each Element of an Array: foreach Loops 03:24
- Lecture
  Process the value and index of each array element using a foreach loop 02:31
- Quiz
  Arrays 7 questions
- Quiz
  Arrays 1 question
Control structures 23:08
- Lecture
  Run Code Conditionally: the if Construct 05:30
- Lecture
  Compare One Value to another: Comparison Operators 04:29
- Lecture
  Run Code Multiple Times Based on a Condition: While Loops 03:02
- Lecture
  Run Code a Specific Number Of Times: For Loops 04:12
- Lecture
  Add More Conditions to an If Statement Using Elseif 02:43
- Lecture
  Perform Different Actions Based on Different Conditions: The Switch Statement 03:12
- Quiz
  Control structures and comparison operators 8 questions
- Quiz
  Control structures and comparison operators 1 question
An Introduction to HTML 36:27
- Lecture
  The Language of Web Pages: an Introduction To Html 05:50
- Lecture
  Use Head and Body Elements to Structure An Html Document 05:36
- Lecture
  Structure the Content of your Page Using Heading and Paragraph Elements 02:54
- Lecture
  Give Text Emphasis or Importance Using the em and Strong Elements 03:19
- Lecture
  Display Ordered and Unordered Lists of Items 03:55
- Lecture
  Insert Images Into an Html Document 05:32
- Lecture
  Add a Link from One Page to Another Using a Hyperlink 04:17
- Lecture
  Add Semantic Structure to The Body of an Html Document 05:04
- Quiz
  HTML 9 questions
- Quiz
  HTML basics 1 question
Mixing PHP and HTML 22:22
- Lecture
  Create Dynamic Content: Mixing HTML and PHP 07:05
- Lecture
  Use PHP Control Structures Mixed with HTML 04:32
- Lecture
  Make HTML More Readable: Use Whitespace and Comments 04:49
- Lecture
  Addendum: changes to the available resources in the following video 00:16
- Lecture
  Make PHP Easier To Maintain: Use Comments and Coding Standards 05:40
- Quiz
  Mixing PHP and HTML 7 questions
- Quiz
  Mixing PHP and HTML 1 question
An Introduction to Databases 47:01
- Lecture
  Where to Store Data in a Dynamic Website: An Introduction to Databases 03:33
- Lecture
  Access the Database Server Using phpMyAdmin And Create a Database 07:52
- Lecture
  Use Tables to Store Structured Data in a Database 08:55
- Lecture
  Select Some Data from The Database: An Introduction to Sql 06:00
- Lecture
  Using Indexes: Make Queries Faster and Order the Result Set 06:08
- Lecture
  Connect to the Database from PHP 04:55
- Lecture
  Query the Database from PHP And Get the Results 05:20
- Lecture
  Combine PHP and HTML to Show a Formatted List of Articles 04:18
- Quiz
  Databases 7 questions
- Quiz
  Databases - connecting and selecting data 1 question
Multiple Pages in PHP 26:19
- Lecture
  Add a New Page to Show a Single Article 03:23
- Lecture
  Passing Data in the URL: Send the Article ID Using the Query String 05:35
- Lecture
  Avoid SQL Injection: Validate the ID Passed in from the Query String 05:03
- Lecture
  Don't Repeat Yourself: Extract Repeated Code to a Separate File 07:29
- Lecture
  Addendum: changes to the code in the following video 00:19
- Lecture
  Organise and Secure Access to the Included Files 04:30
- Quiz
  Multiple pages in PHP 6 questions
- Quiz
  Multiple pages in PHP 1 question
An Introduction to HTML Forms 52:11
- Lecture
  Getting Data From the User: An Introduction to Forms in HTML 05:22
- Lecture
  Change the Method the Form Uses to Send its Data: get vs post 05:20
- Lecture
  Addendum: datetime and datetime-local input types 00:14
- Lecture
  Get Different Types of Data from the User: Basic Input Types 05:07
- Lecture
  Access Data from the form on the Server 05:16
- Lecture
  Add a Multi-line Text Control: the textarea Element 02:28
- Lecture
  Present a Fixed List of Options: the Select Element 03:57
- Lecture
  Toggle an Option on or off: checkboxes 04:02
- Lecture
  Select only one Option from a List: Radio Buttons 02:58
- Lecture
  Add an Accessible Caption to Each Input: the Label Element 05:35
- Lecture
  Make the Form Easier to Use: fieldsets and placeholders 02:48
- Lecture
  Common form Control Attributes: readonly, disabled and autofocus 02:41
- Lecture
  Validate Input Using HTML5 form Validation 06:23
- Quiz
  Forms in HTML 11 questions
- Quiz
  HTML Forms 1 question
Inserting Data Into the Database from PHP 24:42
- Lecture
  Addendum: the datetime-local input type 00:13
- Lecture
  Add a Form to Insert a New Article 03:11
- Lecture
  Insert Data Into the Database: The SQL INSERT INTO Statement 04:37
- Lecture
  Insert a New Article Into the Database and Get the ID of the New Record 04:13
- Lecture
  How SQL Injection Attacks Work 06:12
- Lecture
  Avoid SQL Injection Attacks: Escape Input 02:08
- Lecture
  Avoid SQL Injection Attacks: Use Prepared Statements 04:08
- Quiz
  Inserting data into the database 5 questions
- Quiz
  Databases - inserting data 1 question
An Introduction to Functions and Validation in PHP 37:17
- Lecture
  Functions: Define and Call a Function in PHP 07:02
- Lecture
  Create a Function to Connect to the Database 03:56
- Lecture
  Validate the Form Data and redisplay the Form with Error Messages if Invalid 04:19
- Lecture
  Maintain Previously-supplied Data When redisplaying an Invalid Form 04:40
- Lecture
  Avoid Cross-site Scripting (XSS) Attacks: Escape Untrusted Content 05:02
- Lecture
  Insert NULL if the Publication Date is Empty 01:38
- Lecture
  Validate the Publication Date is a Valid Date and Time 05:22
- Lecture
  Redirect to the Article Page After Inserting a New Article 05:18
- Quiz
  Functions 5 questions
- Quiz
  Functions in PHP 1 question
Editing Data in the Database from PHP 25:40
- Lecture
  Editing Existing Articles: Create a Function to Get a Single Article 06:05
- Lecture
  Add a Form for Editing an Existing Article 04:21
- Lecture
  Add a Validation Function and Validate the Form Data 05:38
- Lecture
  Change Existing Data in the Database: The SQL UPDATE Statement 02:38
- Lecture
  Update an Existing Article in the Database 04:04
- Lecture
  Create a Function to Redirect to Another URL 02:54
- Quiz
  Databases - updating data using MySQLi 1 question
Deleting Data from the Database from PHP 14:19
- Lecture
  Delete Existing Data in the Database: The SQL DELETE Statement 01:45
- Lecture
  Delete an Existing Article in the Database 03:18
- Lecture
  Use the POST Request Method to Delete the Article 02:20
- Lecture
  Get Confirmation from the User Before Deleting the Article 02:41
- Lecture
  Improve Database Performance: Only use SELECT * when Necessary 04:15
- Quiz
  Updating and deleting data in the database 4 questions
Using Sessions to Log in and Restrict Access 30:04
- Lecture
  Make the Web Browser Remember you Between Visits: An Introduction to Sessions 05:28
- Lecture
  Store Data in the Browser: Cookies in PHP 06:03
- Lecture
  Store a Value in the Session to Log in and Log out a User 04:58
- Lecture
  Add a Login form and Process the User's Login Credentials 04:18
- Lecture
  Completely Destroy the Session on Logout and Redirect Back to the Index Page 03:20
- Lecture
  Increase Security: Prevent Session Fixation Attacks 01:56
- Lecture
  Restrict Access to a Page to a Logged-in User Only 04:01
- Quiz
  Sessions and cookies 6 questions
An Introduction to Object-Oriented PHP 39:08
- Lecture
  Classes and Objects: An Introduction to Object-Oriented PHP 04:23
- Lecture
  Object Attributes: Adding Properties to a Class 03:45
- Lecture
  Object Functions: Adding Methods to a Class 03:26
- Lecture
  Object Initialisation: the Constructor Method 02:33
- Lecture
  Control Access: Public and Private visibility of Properties and Methods 02:43
- Lecture
  Public Properties vs Getter and Setter Methods 03:48
- Lecture
  Static Properties and Methods 03:46
- Lecture
  Constants: Using Define and const to Create Constant Values 03:47
- Lecture
  Inheritance: Using the Extends Keyword to reuse Code and reduce Repetition 04:03
- Lecture
  Overriding Methods and Using the Parent Keyword to Call the Parent Class Code 02:52
- Lecture
  Control Access: Protected Visibility of Properties and Methods 04:02
- Quiz
  Object-oriented PHP 10 questions
- Quiz
  Object-Oriented PHP 1 question
PDO: PHP Data Objects 44:54
- Lecture
  Add a Database Class and Connect to the Database Using PHP Data Objects (PDO) 05:32
- Lecture
  Queries in PDO: Change the Index Page to Use the New Database Class 02:13
- Lecture
  Catch Database Errors Using Exceptions and try ... catch Blocks 05:15
- Lecture
  Prepared Statements with Named Parameters in PDO: view an Individual Article 05:50
- Lecture
  Create an Article Class and Use it on the Index and Article Pages 03:38
- Lecture
  Fetch the Database Record as an Object Instead of an Array 02:43
- Lecture
  Update the Article Record Using PDO 05:38
- Lecture
  Move the Validation Function to the Article Class 04:47
- Lecture
  Delete the Article Record Using PDO 03:02
- Lecture
  Insert a new Article Record Using PDO and get the ID of the New Record 06:16
Authentication Using the Database 18:09
- Lecture
  Create a User Class and a Method to Authenticate a User 02:37
- Lecture
  Create a Table to Store User Data in the Database 02:21
- Lecture
  Authenticate the User with Data from the Database 04:40
- Lecture
  Store Passwords Securely: PHP Password Hashing Functions 06:23
- Lecture
  Store the Password as a Hash in the Database and Verify it on Login 02:08
- Quiz
  PDO and password hashing 6 questions
Class Autoloading 17:35
- Lecture
  Convert the auth Include into a Class 03:12
- Lecture
  Convert the url Include into a Class 02:45
- Lecture
  Autoloading Classes: Require Class Files Automatically 03:47
- Lecture
  Add an Initialisation Script Including an Autoloader 04:04
- Lecture
  Returning a Value Using Require: Add a Script to get the Database Connection 03:47
Site Administration 33:18
- Lecture
  Move all Authentication-related Code to the Auth Class 03:53
- Lecture
  Create an Admin Index and Load Classes Relative to the site root Directory 06:45
- Lecture
  Displaying Tabular Data in HTML: Tables 06:49
- Lecture
  Display the Admin List of Articles in a Table and Restrict Access to the Page 02:58
- Lecture
  Add Sitewide Navigation Links 05:04
- Lecture
  Move the Edit and Delete Article Scripts to the admin Area 04:40
- Lecture
  Move the New Article Script to the admin Area 03:09
- Quiz
  Autoloading classes and requiring files 4 questions
Pagination 29:40
- Lecture
  Pagination: Split Database Results up Into Pages 03:06
- Lecture
  Add a Method to the Article Class to get a Single Page of Article Records 02:42
- Lecture
  Add a Paginator Class and Calculate the offset and Limit from the Page Number 03:37
- Lecture
  Get the Page Number from the Query String 03:34
- Lecture
  Validate the Page Number using the filter_var Function 03:54
- Lecture
  Add Previous and Next Pagination Links 03:35
- Lecture
  Calculate the Total Number of Records and Pages 04:12
- Lecture
  Add Pagination to the admin Index and Create Shared Pagination Links 05:00
- Quiz
  Tables and pagination 5 questions
Uploading Files 42:39
- Lecture
  Uploading Files: Add a Form to Upload an Article Image 04:58
- Lecture
  Handle the Upload Error Code 03:04
- Lecture
  Restrict the Size of all Uploaded Files using PHP Configuration Settings 06:24
- Lecture
  Restrict the Size of an Uploaded File in an Individual Form 01:40
- Lecture
  Restrict the Type of an Uploaded File 04:05
- Lecture
  Create a Folder for Uploads and Move the Uploaded File into it 04:19
- Lecture
  Sanitise the Uploaded Filename as a Security Precaution 03:01
- Lecture
  Don't Overwrite Existing Files in the Uploads Folder 03:04
- Lecture
  Save the Filename to the Article Record in the Database 03:29
- Lecture
  Display the Uploaded Image if an Article has one 01:59
- Lecture
  Delete the Previous image File when an Article Image is Updated 02:21
- Lecture
  Add an Option to Delete an Article's Image file 04:15
- Quiz
  Uploading files 7 questions
Database Relationships 22:03
- Lecture
  Database Relationships: Create a Table and Data for Categories 02:25
- Lecture
  One-to-one Relationships Between Tables 03:47
- Lecture
  One-to-many Relationships Between Tables 02:00
- Lecture
  Joins: Selecting Data from Multiple, Related Tables at Once 04:06
- Lecture
  Relationship Constraints 03:59
- Lecture
  Many-to-many Relationships Between Tables 05:46
Using Relationships: Article Categories 45:07
- Lecture
  Show an Article's Categories on the Individual Article Page 06:10
- Lecture
  Get an Article's Categories in an Object Method 03:13
- Lecture
  Add a Category Class and form Inputs to edit an Article's Categories 05:36
- Lecture
  Insert Article Categories while Avoiding Duplicate Records in the Join Table 07:39
- Lecture
  Insert Article Categories more Efficiently using a Single Query 04:18
- Lecture
  Delete Article Category Records if Unchecked in the Form 04:19
- Lecture
  Add Categories When Inserting a new Article Record 04:26
- Lecture
  Pagination and Joins: Show Categories in the Index Page 09:26
- Quiz
  Database relationships 5 questions
JavaScript and PHP 39:13
- Lecture
  Execute Code in the Browser: An Introduction to JavaScript 06:10
- Lecture
  Using the jQuery Library 05:22
- Lecture
  Add jQuery and a Custom Script file to the CMS 02:57
- Lecture
  Add Delete Confirmation Using JavaScript and POST 07:23
- Lecture
  Client-side form Validation Using the jQuery Validation Plugin 05:38
- Lecture
  An Introduction to Ajax with PHP 06:13
- Lecture
  Use JSON to Safely Encode Structured Data in an Ajax Request 05:30
- Quiz
  JavaScript and PHP 8 questions
Dates and Times 21:08
- Lecture
  Only Show an Individual Article if it's been Published 03:18
- Lecture
  Only Show Published Articles on the Index Page 03:40
- Lecture
  Use the DateTime Class and the Time Element to Show the Published Date and Time 04:05
- Lecture
  Show the Published Date and Time of Articles in the admin Area 02:19
- Lecture
  Publish Unpublished Articles Using an Ajax Request 07:46
An Introduction to CSS 22:01
- Lecture
  Add Styling and Formatting to HTML: an Introduction to CSS 05:54
- Lecture
  Using CSS Frameworks: Bootstrap et al 02:59
- Lecture
  Add a General Layout and Style the Navigation Links 03:10
- Lecture
  Add Styling and Layout to Forms and Tables 02:40
- Lecture
  Add a Custom Stylesheet and Style the List of Articles 03:22
- Lecture
  Add a Date and Time Picker Plugin to make Selecting Dates and Times Easier 03:56
- Quiz
  CSS basics 4 questions
Sending Emails from PHP 19:54
- Lecture
  Add a Contact Page for Sending an Email 02:48
- Lecture
  Validate the Submitted Contact Form 04:27
- Lecture
  Get Access to a Mail Server 02:50
- Lecture
  How to Send Email from PHP: the Mail Function and PHPMailer 05:34
- Lecture
  Bonus - Please Watch! 00:48
- Lecture
  Send Email from the Contact Page Using PHPMailer 03:27
Configuration and Error Handling 22:26
- Lecture
  Extract Environment-dependent Settings out into a Single Configuration File 05:03
- Lecture
  Deny Direct Access to the config file from a Browser 02:31
- Lecture
  Handing Errors and Exceptions: user-defined Handling Functions 05:35
- Lecture
  Display Error and Exception Details Depending on the Environment 04:53
- Lecture
  HTTP Status Codes and Handling Ajax Errors 04:24
- Quiz
  Sending emails and error handling 3 questions
Conclusion 07:38
- Lecture
  Deployment: Publish your Code on a Live Server 06:00
- Lecture
  Conclusion: Where to go from Here 01:38
Extra Information - Source code, and other stuff 15:27
- Lecture
  Source Code for all Lectures 10:38
- Lecture
  Bonus Lecture and Information 04:49

Dave Hollingworth

IT Trainer Hi, I'm Dave Hollingworth. I'm an IT trainer and web application developer. I've been programming for over thirty years, and teaching IT since 1999. I've developed enterprise-level applications on platforms… View Profile

Tim Buchalka's Learn Programming Academy

Professional Programmers and Teachers - 323,000+ students The Learn Programming Academy was created by Tim Buchalka, a software developer with 35 years experience, who is also an instructor on Udemy, with over 335,000 students in his courses… View Profile

Student Feedback

4.5

3,932 Average ratings

59%

31%

2 days ago
Kristof Van Steenkiste
Ik ben echt blij dat ik deze cursus kan volgen, alles word heel gedetailleerd uitgelegd, ik heb het wel op x1,5 speed gezet zodat het toch iets sneller gaat maar dat ligt volledig aan mij
3 weeks ago
Kenneth Ato Abban
cool
3 weeks ago
Cristos Filippopoulos
The instructor is very knowledgeable about what he is teaching, and he explains everything to detail
2 months ago
Darren Clift
Good course. Exercises are challenging. Would be nice to have more coding resources
2 months ago
Jorge Luis Román Lizárraga
I have been following and watching his YouTube videos for a long time, but taking a complete course with this great teacher is exceptional. My knowledge curve will grow dramatically with this great knowledge.
2 months ago
Ugyen Dorji
Yes because the system I am using right now is php base.
2 months ago
Jideofor Ezenwanne
Excellent Teaching
2 months ago
Prince Das
Concept of this course is amazing
3 months ago
Giovanny Maya
Easy to follow through
3 months ago
Noor Mohammed abdikadir
the course is well prepared

Programming Languages

PHP for Beginners

Build a Content Management System from Scratch with PHP and MySQL

Requirements

What you will learn

Who should attend

Is available on google app?

Is available on ios?

Course Features

Introduction 01:32

Software Installation and Setup 24:56

Variables 25:26

Arrays 21:24

Control structures 23:08

An Introduction to HTML 36:27

Mixing PHP and HTML 22:22

An Introduction to Databases 47:01

Multiple Pages in PHP 26:19

An Introduction to HTML Forms 52:11

Inserting Data Into the Database from PHP 24:42

An Introduction to Functions and Validation in PHP 37:17

Editing Data in the Database from PHP 25:40

Deleting Data from the Database from PHP 14:19

Using Sessions to Log in and Restrict Access 30:04

An Introduction to Object-Oriented PHP 39:08

PDO: PHP Data Objects 44:54

Authentication Using the Database 18:09

Class Autoloading 17:35

Site Administration 33:18

Pagination 29:40

Uploading Files 42:39

Database Relationships 22:03

Using Relationships: Article Categories 45:07

JavaScript and PHP 39:13

Dates and Times 21:08

An Introduction to CSS 22:01

Sending Emails from PHP 19:54

Configuration and Error Handling 22:26

Conclusion 07:38

Extra Information - Source code, and other stuff 15:27

Student Feedback

Related Courses

17 Comments

Leave A Reply Cancel reply

Modal title