Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Creating a Simple Newsletter Signup Using PHP and MySQL
Rating: 4.5 out of 5(266 ratings)
15,526 students

Creating a Simple Newsletter Signup Using PHP and MySQL

In this course we are going to add a newsletter signup form that saves to a database.
Created byMalcolm Knott, Daniel Walter Scott
Last updated 6/2020
English

What you'll learn

  • Simple PHP and MySQL database skills.

Course content

1 section • 14 lectures • 56m total length

  • Introduction1:15
  • Things You Are Going to Need for This PHP Database Course0:56

    These are the apps we'll be using on this tutorial, if you haven't already please download and install.


    Google Chrome - https://www.google.com/chrome/

    VS Code - https://code.visualstudio.com/download

    Xampp - https://www.apachefriends.org/index.html

  • Downloading and Setting Up Your Local Web Development Environment6:38

    Downloading, installing and setting up Google Chrome, VS Code and XAMPP.

    We also talk why you need a server running on your computer and the difference between frontend and backend code.

  • Setting up Xampp on Windows3:06

    In this video we get started with Xampp on Windows.

  • Creating a Database and Table With phpMyAdmin6:09

    In this video we create a database using phpMyAdmin.

    We add the newsletters table to our new database.

    We also quickly talk about the different data types that we need to use.

  • Adding a Website to XAMPP Server0:54

    We add an example website from Daniel at Bring Your Own Laptop to our XAMPP server.

  • Adding a Form to Our Website Using Twitter Bootstrap3:33

    In this video we see how quick and easy it is to add a form to our website using twitter bootstrap.

  • PHP Basics to Handle a Form Submission10:40

    Adding some PHP to our website to handle the form submission, we also go over some PHP basics.


    Links:

    Echo - https://www.php.net/manual/en/function.echo.php

    $_GET - https://www.php.net/manual/en/reserved.variables.get.php

    $_POST - https://www.php.net/manual/en/reserved.variables.post.php

    Variables - https://www.php.net/manual/en/language.variables.variable.php

    Array - https://www.php.net/manual/en/language.types.array.php

    Print_r - https://www.php.net/manual/en/function.print-r.php

    Isset - https://www.php.net/manual/en/function.isset.php

    Pre tag - https://www.w3schools.com/tags/tag_pre.asp

  • Using PHP’s PDO Class to Connect to a Database5:49

    In this video we add the PHP required to connect to our database.


    Links:

    https://www.php.net/manual/en/pdo.connections.php

  • Inserting Form Data Into a Database Table Using PHP4:26

    In this video we get our form data ready to be inserted into our newsletters table and write the mysql query that inserts a new newsletter record.


    Links:

    https://www.php.net/manual/en/function.date.php

  • Exporting a Mysql Table to Csv File Using phpMyAdmin1:44

    In this tutorial we are exporting the contents of our newsletters mysql table to a csv file.

  • Uploading Our PHP Project to a Bluehost Server8:16

    Releasing our PHP project to the wild, and test that it works in the real world. We'll need to upload it to a Bluehost server, create a new database and make a few updates to our code.

  • HTML Form Validation Required and Email Attribute1:39

    We forgot about what happens if someone submits the form with empty feilds, we add some form validation to stop that happening.


    Links:

    https://developer.mozilla.org/en-US/docs/Learn/HTML/Forms/Form_validation

  • Where to Next1:08

    That brings us to the end of this course, where to next?


    https://twitter.com/KnottMalcolm

Requirements

  • Basic understanding of HTML and CSS.

Description

Hi, In this course we are going to add a newsletter sign up form that will save our new subscribers to a database.

To do this we are going to be using a backend programming language called PHP and a MySQL database.Don’t worry if that doesn’t make any sense to you, we will be going over all of the basics and walking you through it step by step.

This course does however assume you have a basic understanding of html and css, and that you know how to push any updates up to a server and make them live.

If you don’t have that experience then I can recommend this course by Daniel Scott, it starts at the very beginning and will easy get you up to speed so you can start taking the next steps like working with PHP and databases.

So if you’re ready to get started with our PHP database project … then sign up to the course and lets get started :)

Who this course is for:

  • Beginner web developers wanting to learn PHP and MySQL.

Report abuse