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.
Rating: 3.8 out of 5 (75 ratings)
6,293 students
English
English [Auto]
Creating a Simple Newsletter Signup Using PHP and MySQL
Rating: 3.8 out of 5 (75 ratings)
6,298 students
Simple PHP and MySQL database skills.

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.

Course content

1 section • 14 lectures • 56m total length
  • Introduction
    01:15
  • Things You Are Going to Need for This PHP Database Course
    00:56
  • Downloading and Setting Up Your Local Web Development Environment
    06:38
  • Setting up Xampp on Windows
    03:06
  • Creating a Database and Table With phpMyAdmin
    06:09
  • Adding a Website to XAMPP Server
    00:54
  • Adding a Form to Our Website Using Twitter Bootstrap
    03:33
  • PHP Basics to Handle a Form Submission
    10:40
  • Using PHP’s PDO Class to Connect to a Database
    05:49
  • Inserting Form Data Into a Database Table Using PHP
    04:26
  • Exporting a Mysql Table to Csv File Using phpMyAdmin
    01:44
  • Uploading Our PHP Project to a Bluehost Server
    08:16
  • HTML Form Validation Required and Email Attribute
    01:39
  • Where to Next
    01:08

Instructors

Freelance Website Developer
Malcolm Knott
  • 3.8 Instructor Rating
  • 75 Reviews
  • 6,293 Students
  • 1 Course

Hi,

I'm a freelance website developer from New Zealand. I mostly work with Laravel and Vue JS projects, although I have experience with tones of different programming languages, frameworks and CMS's. I'm just starting my course making journey and can't wait to share everything I have learnt over a career of making websites.

Adobe Certified Instructor & Adobe Certified Expert
Daniel Walter Scott
  • 4.7 Instructor Rating
  • 98,840 Reviews
  • 333,207 Students
  • 28 Courses

Sharing is who I am, and teaching is where I am at my best, because I've been on both sides of that equation, and getting to deliver useful training is my meaningful way to be a part of the creative community.

I've spent a long time watching others learn, and teach, to refine how I work with you to be efficient, useful and, most importantly, memorable. I want you to carry what I've shown you into a bright future.

I have a wife (a lovely Irish girl) and kids. I have lived and worked in many places (as Kiwis tend to do) – but most of my 14+ years of creating and teaching has had one overriding theme: bringing others along for the ride as we all try to change the world with our stories, our labours of love and our art.

I'm a certified Adobe instructor (ACI) in Ireland. I'm also an Adobe Certified Expert (ACE) and have completed the Adobe Certified Associate training (ACA). And I don't just do Adobe. Remember, media is a very broad term – digital blew out the borders, so we are all constantly learning.

I've been teaching for 14+ years. I come from being a media designer and content creator – so I understand exactly where you're at now. I've been there. I love this stuff. Print, digital publishing, web and video. I can see how it all connects. And I can see how we can share those connections.

I built Bring Your Own Laptop in Ireland, New Zealand, Australia & online. I have a great team working with me to keep BYOL at the top of Adobe and digital media training. I understand business, I have one – so I know how important it is to get it right and make it work for you.

Now my focus is on Udemy. It's my mission to bring you the best training for digital media on Udemy.

Daniel Walter Scott

Streamline your online course creation processes
Instructor HQ
  • 4.7 Instructor Rating
  • 98,402 Reviews
  • 317,548 Students
  • 26 Courses

instructorHQ aims to deliver consistently high quality courses from a range of experienced trainers. 

We also offer courses detailing the production techniques necessary to begin and grow into a experienced and successful trainer. 

“You can teach a student a lesson for a day; but if you can teach him to learn by creating curiosity, he will continue the learning process as long as he lives." - Clay P. Bedford