Newsletter Signup using PHP, MySQL, Ajax and Bootstrap 5

Name: Newsletter Signup using PHP, MySQL, Ajax and Bootstrap 5
Rating: 4.7 (64 reviews)

In this course, a newsletter form data will be saved into the MySQL database using PHP, PDO and Ajax

Created byMd Morshedul Arefin

Last updated 10/2021

English

English [Auto],

What you'll learn

Signup form validation technique
Creating database and tables using xampp server
Database connection using pdo and php
Validating and inserting data into database using ajax
Email sending technique using phpmailer
Email verification logic
Exporting data as csv format
Uploading the project in web server using cpanel
Creating database, users, email addresses in web server using cpanel

Course content

5 sections • 16 lectures • 1h 59m total length

Course introduction3:35
This is just an intro video lecture. I have told in short about the course.
Installing and using XAMPP server1:23
Installing and using code editor1:38
I have shown how to download and install sublime text editor. Also, how to install new package.

Validating and Inserting form data into database using ajax38:49
Sending email to the subscriber for email verification15:33
Learn how to implement newsletter signup using PHP, MySQL, Ajax and Bootstrap 5, and send subscriber verification emails with a PSP Mailer library, including a verification link and token.
Verifying the subscription10:02
Verify the subscriber by checking the verification link token against the email in the subscribers table, then set the token to blank and mark the account as active.
Fixing the success message issue with phpmailer3:00
This lecture demonstrates fixing the phpmailer success message not displaying during newsletter signup by debugging, testing with a new email, and confirming the subscription message, including spam folder guidance.
Exporting the data as CSV format3:09
Trigger the export link to download a csv file via a php export script, exporting active subscribers with fields like id, email, and name.

Exporting the database as SQL format0:34
Export the database as SQL format from the web server and import it into the project folder to set up the database.
Login to cpanel and upload the files as zip1:51
Creating database and import the SQL file1:41
Create a database and a user, grant privileges, then import the local server database and link it to the website project folder for the newsletter signup.
Creating email address and getting SMTP information1:33
Create a new email account, generate a password, and access web mail to obtain SMTP information for newsletter signup workflows.
Change config file and SMTP info to test the application5:08
Configure the PHP, MySQL, Ajax and Bootstrap 5 setup for testing by editing the config and SMTP details, validating the newsletter signup flow.

Requirements

Basic understanding of HTML, CSS
Basic understanding of PHP
Intermediate Computer Skill
Ability to install xampp or any local server on PC
Basic understanding of database queries

Description

In this course, I have shown the subscriber newsletter signup process using php, mysql, ajax and bootstrap 5. There are a lot of beginner students who do not understand how to perform the task of email confirmation. This tutorial will greatly help those. Not only this, after completing this course, a php developer can build something new, for example, he can make a registration system with email verification using the same concept and logic. Also, as I have used the ajax to save information and to send email, that will help a lot of beginner and intermediate programmers to use the code on their projects.

After completing the main development process, I have shown how to upload the complete projects into web server. The server was cpanel based shared server. Using cpanel, I have shown how to upload files, create database and tables, how to create email address and how to use the SMTP information from the server to send emails.

In this course, I have added an export database system as CSV format. So in a real life application, a person can collect all the emails he get from subscribers, export that list and can use in any email marketing campaign or other purposes.

Who this course is for:

Beginner web developers wanting to learn php in more details
Students who already know about php, mysql and other stuff, but now wanting to learn more advanced skill

Newsletter Signup using PHP, MySQL, Ajax and Bootstrap 5

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 7min

Creating Layout1 lecture • 19min

Database and Table2 lectures • 13min

Developing the application5 lectures • 1hr 11min

Uploading project into web server5 lectures • 11min

Requirements

Description

Who this course is for: