Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Create a Members Only Blog using PHP, MySQL, & AJAX
Rating: 4.3 out of 5(797 ratings)
170,528 students

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
Last updated 4/2021
English
English [Auto],

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 section20 lectures1h 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

    Prepare your development environment by starting a local server, moving the perfect cup project into the web root, and configuring index.php with bootstrap, fonts, images, and scripts.

  • Index Page Overview3:05

    Update the index page to the perfect cup home branding by changing the main title, copy, author, and footer; remove the extra content box and implement a shared navigation file.

  • Home Page Mods4:35

    Update the home page title and copy to reflect the perfect cup. Extract the navigation into nav.php and include it with require_once for centralized updates.

  • About Page Mods7:33

    Modify the about page by updating titles, headers, text, and images, replace navigation with an include, embed a responsive YouTube video, and preview changes.

  • Blog Page Mods8:05

    Replace navigation with a PHP require, update the page title and footer, and turn each post into a read more button that opens a per-post modal with customized content.

  • MySQL Database Creation2:50

    Create a MySQL database and a members table via phpmyadmin for a members-only blog. Define id as auto_increment primary key and fname, lname, email, password as varchar with utf8_unicode_ci collation.

  • 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

    Implement a PHP validation and encryption flow: validate form inputs, hash passwords with password_hash, ensure unique emails, insert into the members table, and start a session to auto-login the user.

  • Login Authentication - Part 11:40

    Create a login authentication flow for a members-only blog, validating email and password, showing errors on failures, redirecting successful logins to the blog, and including logout and registration options.

  • Login Authentication - Part 25:40

    Repurpose the registration page into a login page, remove name fields, update button IDs, add login alert, and implement ajax login with a php check script that redirects on success.

  • Login Authentication - Part 32:53

    Validate user email and password against the members database, verify with password_verify, start a session, set login data, and return true or false to the login page.

  • Login Authentication - Part 43:17

    Enforce login authentication by checking the session at page start, redirecting unauthenticated users to the login page, and displaying a welcome message with the user's name and a logout link.

  • 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

    Create a contact page featuring an embedded Google map showing the address, display contact details, and a PHP and AJAX validated contact form that sends messages via PHP Mailer.

  • Contact Form - AJAX Integration4:33

    Enhance the contact form with id attributes and an error display, load jQuery, and implement an ajax submission to send_message.php, including client-side validation and success or error messaging.

  • 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

    Create a PHP form handler that validates contact form data, sanitizes input with mysqli_real_escape_string, and sends email via PHPMailer over SMTP, with optional database setup for future submissions.

  • 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