In this self-paced course you learn how to build dynamic websites with PHP and MySQL. This course provides you with hands-on practices using PHP with MySQL scripting language for web development. Web developers will learn the fundamentals of PHP and MySQL by finishing a big hands-on project step-by-step. Specifically, this self-paced course follows a detailed project on back-end web development in PHP and MySQL. We will be teaching basic Create, Read, Update or Delete (CRUD) functionalities, authentication, and security. Things like, setting up your server, creating the public HTML Pages, creating the database and it’s tables, and adding users to the database.

Learning Objectives

By finishing this course, you will take away the following:

1.  Utilize CRUD statements in SQL – Create, read, update and delete records in a database.
2.  Simple authentication and security – Logging in and out, handling unauthorized users and restricting access.
3.  Simple time and date manipulation – Displaying time and date postings and monitoring your posts.
4.  Displaying public and private data – Simply display information for logged-in users only and for the public

Topics and Subtopics

Here is the course outline:

1- Setting up your server

2- Creating the public HTML Pages

3- Creating the database and it’s tables

4- Adding users to the database

5- User log-in: Authentication

6- Setting up the home page for Logged-in users and Logging-out

7- Testing Page Security

8- Adding data to the list – User Access Only

9- Displaying data in the home page

10- Editing Data

11- Deleting data

12- Displaying public data

13- De-briefing and Summary

Requirements

Basic knowledge of HTML and CSS and PHP is highly recommended.

Related Courses

• Web Design with WordPress
• Intro to Joomla CMS
• Introduction to Drupal CMS
• Learn Node.JS, Express.JS and MongoDB
• Learn PHP Programming

Complete Training Bundle

If you are serious about learning web design and development, you should enroll in our Web Design and Development Training Bundle. This bundle covers all essential and practical topics related to web development. For $290 monthly subscription, you can have access to 300+ hours of hands-on project-based training covering all courses related to web development like JavaScript, PHP, JavaScript frameworks like React or Angular and many more. Click here to learn more.

Private Tutoring Classes

To take skills you learn from this course to the next level, taking the following tutoring classes are highly recommended. It is also a great opportunity to discuss your questions and problems related to this course with an experienced instructor:

• Web design and development tutoring sessions- Weekly and monthly plans
• PHP, MySQL and PHP Object-Oriented Programming- Private tutoring sessions

What Is Next?

After finishing this course, you can enroll in any of following classes:

• Learn PHP and MySQL coding by examples- Intermediate Level
• Intro to PHP OOP
• Web Design with Bootstrap
• Intro to Angular.JS Framework
• Intro to React.JS Framework
• Vue.JS Framework
• Introduction to Database Design
• Learn SQL Programming by Examples
• Introduction to Linux OS

Recommended Free Courses

If you are new to the IT or programming, we suggest the following free courses:

• IT Career Roadmap Explained
• Intro to Cybersecurity
• Introduction to Cloud Technology