Create a Members Only Blog using PHP, MySQL, & AJAX

Name: Create a Members Only Blog using PHP, MySQL, & AJAX
Rating: 4.3 (797 reviews)

Create a Database Driven Blog with Authentication, Validated Contact Forms, & Session Variables using PHP, MYSQL, & AJAX

Created byYouAccel Training

Last updated 4/2021

English

What you'll learn

Creating Dynamic Web Pages in PHP
Creating a MySQL Database to store Member Data
Creating PHP & AJAX Validated Member Registration Forms
Creating PHP & AJAX Validated Member Login Authentication
Working with Session Variables – Login/Logout Functionality
Developing Validated Contact Forms for Web to Email Transmission via SMTP
PhpMailer Integration to facilitate Email Transmission
Uploading the Project from a Local Testbed to a Production Server

Course content

1 section • 20 lectures • 1h 49m total length

Introduction & Overview6:47
Develop a four-page site using PHP, MySQL, and AJAX, featuring a members-only blog with registration, authentication, and AJAX-validated forms, plus a responsive Bootstrap layout.
Project Setup3:20
Index Page Overview3:05
Home Page Mods4:35
About Page Mods7:33
Blog Page Mods8:05
MySQL Database Creation2:50
Creating a Registration Form7:48
Build a php and mysql registration form with ajax validation, collecting first name, last name, email, and password, inserting to the database and enabling login to access the blog.
Registration Status using JavaScript and AJAX7:55
Use JavaScript and Ajax to submit registration data to a PHP script and display live success or error messages without refreshing, validating first name, last name, email, and password.
PHP Validation - Encryption - Session10:42
Login Authentication - Part 11:40
Login Authentication - Part 25:40
Login Authentication - Part 32:53
Login Authentication - Part 43:17
Logout - Terminate Session3:06
Terminate the user session by unsetting login variables, redirect to index.php with logout=true, and display a logout confirmation alert when the URL parameter is present, then test the login flow.
Contact Page - Google Maps API5:34
Contact Form - AJAX Integration4:33
PHPMailer Installation2:45
Install and prepare the PHPMailer library for sending emails in a PHP project by downloading, extracting, renaming, and placing the folder in your project directory.
PHP Form Validation and Email Transmission7:06
Production Server Migration10:42
Migrate a members-only blog to a live production server by uploading files, importing the database, updating the connection strings, and testing login, registration, and the contact form.

Requirements

Basic Computer Skills

Description

Course: Create a Members Only Blog using PHP, MySQL, & AJAX
Create a Database Driven Blog with Authentication, Validated Contact Forms, & Session Variables using PHP, MYSQL, & AJAX

This course offers a hands-on approach in learning how to develop web applications using PHP, MySQL, and AJAX.

Students will develop a blog with MySQL database integration. The project aims to cover the following key concepts:

Creating Dynamic Web Pages in PHP
Creating a MySQL Database to store Member Data.
Creating PHP & AJAX Validated Member Registration Forms
Creating PHP & AJAX Validated Member Login Authentication
Working with Session Variables – Login/Logout Functionality
Developing Validated Contact Forms for Web to Email Transmission via SMTP
PhpMailer Integration to facilitate Email Transmission
Uploading the Project from a Local Testbed to a Production Server

The concepts explored in this course will help students learn the essential skills necessary to develop web applications of any size and complexity.

What you'll learn - Overview:

Creating Dynamic Web Pages in PHP
Creating a MySQL Database to store Member Data
Creating PHP & AJAX Validated Member Registration Forms
Creating PHP & AJAX Validated Member Login Authentication
Working with Session Variables – Login/Logout Functionality
Developing Validated Contact Forms for Web to Email Transmission via SMTP
PhpMailer Integration to facilitate Email Transmission
Uploading the Project from a Local Testbed to a Production Server

Key Concepts:

Login Authentication
Database Development
AJAX Integration
PHPMailer
Form Development
Form Validation and Email Transmission

Who this course is for:

Students interested in learning how to Build Web Applications
Students interested in Learning how to code in PHP
Students interested in building their own Blog
Students interested in Creating Contact forms with PHP & AJAX form Validation
Students interested in Building User Authenticated Login Forms
Students interested in learning how to Install and Configure PhpMailer
Students interested in learning how to store User Data into MySQL Tables