Creating a simple newsletter signup using PHP and MySQL

Exporting a Mysql Table to Csv File Using phpMyAdmin

This lesson is exclusive to members

Questions

Course info

13 lessons / 1 hours

Overview

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 :)
Daniel Scott

Daniel Scott

Founder of Bring Your Own Laptop & Chief Instructor

instructor

I discovered the world of design as an art student when I stumbled upon a lab full of green & blue iMac G3’s. My initial curiosity around using the computer to create ‘art’ developed into a full-blown passion, eventually leading me to become a digital designer and founder of Bring Your Own Laptop.

Sharing and teaching are a huge part of who I am. As a certified Adobe instructor, I've had the honor of winning multiple Adobe teaching awards at their annual MAX conference. I see Bring Your Own Laptop as the supportive community I wished for when I was first starting out and intimidated by design. Through teaching, I hope to bring others along for the ride and empower my students to bring their stories, labors of love, and art into the world.
True to my Kiwi roots, I've lived in many places, and currently, I reside in Ireland with my wife and kids.

Downloads & Exercise files

Transcript

This video, we are going to export from our database  to our CSV file. Okay, now that we have some record saving  to our newsletters table, I guess, uh, the question is  what can we do with that data now that we have it saved? So we could use PHP to retrieve that data  and display it to a page,  but I'm not sure how useful that would be displaying a list  of people that have signed up to our newsletter. Also, it's kind of outta the scope of this tutorial. So what we are going to do is export this  to a CSV file,  and from there you can open it, uh, as a spreadsheet and,  and do whatever you like with that data. Or you could maybe upload it  to a email marketing service like MailChimp  and create a, um, a newsletter list.

So let's go ahead and look at how we can export this. If you click on the export button along this top navigation,  we can ignore this Export  Templates section Doesn't really apply to us. We do want to change the format to CSV  and basically we just hit the go button  and you can see down here that that's downloaded a CSV file. So let's click on that to open it. And here we go. Here are our newsletter signups saved  to a CSV file.
Bring Your Own Laptop
  • Powered by Marvin
  • Terms of use
  • Privacy policy
  • © Bring your Own Laptop Ltd 2025