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.
By finishing this course, you will take away the following:
- Utilize CRUD statements in SQL - Create, read, update and delete records in a database.
- Simple authentication and security - Logging in and out, handling unauthorized users and restricting access.
- Simple time and date manipulation - Displaying time and date postings and monitoring your posts.
- 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
Basic knowledge of HTML and CSS and PHP is highly recommended.
Complete Training Bundle
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: