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



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:



What Is Next?

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



Recommended Free Courses

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


Select a pricing plan and sign up

$90

Paid Course

2 payments of $59/month

Paid Course

4 payments of $39/month

Paid Course