PHP for Beginners

Build a Content Management System from Scratch with PHP and MySQL

mm
Dave Hollingworth
(1,145 reviews)
Take this course
1576856_1e49-1.jpg

Are you wanting to get into Web development, but are not sure where to start? 

So maybe you tried out some PHP and MySQL tutorials on Youtube, but found them too hard or outdated, and feel that you need a more comprehensive introduction.

Maybe you want to learn how to write PHP the right way.  Secure code, OOP ready, and maximising re-usability as well as finding out about PHP programming standards to adopt and adhere too?

Perhaps your boss or client threw you in the deep end with a PHP and MySQL project, and you need to get up to speed with PHP, fast.

Whatever the reason, this course is for you.

This course is going to teach you how to create web applications using PHP and MySQL.  Specifically, you will learn PHP and then create you own content management system (CMS) from scratch.

Why PHP?

PHP is the most popular website programming language in the world.  The combination of PHP and MySQL is used extensively to create web applications, and developers with these key skills are in high demand.  This course is going to teach you how to create web applications in PHP using the MySQL database.

What will you learn in this course?

You will learn  how to create a dynamic website using the most popular website programming language in the world, PHP.

Dave Hollingworth, your instructor will teach you the PHP programming language, and take you through the steps to build a working CMS in PHP and MySQL from scratch.

Along the way, you will learn how to secure your code, how to write reusable, more maintainable code using programming standards, and how to structure your code using object-oriented programming techniques.

Dave will teach you the theory and then put the theory into practice when building the CMS.

You will also learn how to 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, and more.

The course is very thorough, and goes through everything from installing a web server on your own computer, and editor to writing the code to create your web app.  Towards the end of the course you will even learn how to upload the code and make your code live on the internet (very useful if you already have your own Hosting account).  This is not necessary to complete the course though.

In summary, the course will teach you the core skills you need to know to become a productive PHP programmer.

Why this course?

Firstly, Dave has been creating web applications since 1999, when he created his first web application for a major insurance company.  In addition he has been teaching IT for many years.

As a result, you will be learning the best practices from an experienced developer.

Dave will teach you the theory but then show how to put those techniques into practice.  You will start building a CMS application from early on in the course and new techniques and theory are introduced as and when they’re needed to build the next part of the CMS.

New code is introduced one word or one line at a time, so you will never get bogged down or overwhelmed.

You will also learn real-world developer skills such as referring to and getting the most out of the documentation. This is an essential skill for developers to learn.

After completing this course, you will have the necessary skills to be able to create your own web applications with PHP and MySQL.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.    PHP developers are in high demand!

Your new job or consulting opportunity awaits!  

Why not get started today?

 Click the Signup button to sign up for the course!

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 199
  • Quizzes 33
  • Exercises 12
  • Duration 14 total hours
  • Skill level Beginner Level
  • Students 5860
  • Last Updated July, 2020

  • Introduction 01:32

    • Lecture
      Introduction: How to Get the Most Out of the Course 01:32

  • Software Installation and Setup 24:44

    • 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
      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

    • 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
      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 51:57

    • 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
      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:29

    • 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:06

    • 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
      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 08:26

    • Lecture
      Deployment: Publish your Code on a Live Server 06:00
    • Lecture
      Bonus - Please Watch! 00:48
    • 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.6
1,145 Average ratings
59%
32%
7%
2%
1%

  • 1 month ago

    Susan Mckeegan Hutchinson

    I am currently at university pursuing a degree. One of my course requirements was to develop a CMS application. Using this course, I was able to develop my own application in parallel to learning the material. I successfully created my own application and found this course instrumental.

  • 1 month ago

    Angela

    So far so good

  • 1 month ago

    Arpan Jitendra Khetani

    Extremely well taught , with using simple ways to explain...This has made me understand PHP so well... Thank you...

  • 1 month ago

    koketso Phahle

    I was able to follow the course right from the beginning to the end and i really enjoyed it

  • 1 month ago

    Thomas Hollywood

    Very interesting

  • 2 months ago

    Ivan Atanasov Andonov

    Great :)

  • 2 months ago

    Andre Di Carlo

    Instructor is very clear and deliberate in his explanations of everything. I appreciate his methodical approach

  • 2 months ago

    Nati Roth

    Very good espcially for beginners

  • 2 months ago

    Mak H

    A great course on PHP. This is good both for total beginners to programming and also those who are already have experience but want to learn PHP. I fall into the latter category. The instructor starts with the very basics so that students who completely new to programming can also understand. And goes on to show advanced topics. He also teaches some basic database (mariadb/mysql) and throughout the course, we work through a CMS project so that by the end of the course you have a good picture of how server side scripting works with PHP. This is great for me especially since I am thinking of getting into wordpress development.

  • 2 months ago

    Steve Smith

    Easy to follow and meeting my expectations so far!

Take this course
Take this course

Related Courses

Leave A Reply

Your email address will not be published. Required fields are marked *