Creating a Simple Newsletter Signup Using PHP and MySQL
- Basic understanding of HTML and CSS.
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.
- 00:56Things You Are Going to Need for This PHP Database Course
- 06:38Downloading and Setting Up Your Local Web Development Environment
- 03:06Setting up Xampp on Windows
- 06:09Creating a Database and Table With phpMyAdmin
- 00:54Adding a Website to XAMPP Server
- 03:33Adding a Form to Our Website Using Twitter Bootstrap
- 10:40PHP Basics to Handle a Form Submission
- 05:49Using PHP’s PDO Class to Connect to a Database
- 04:26Inserting Form Data Into a Database Table Using PHP
- 01:44Exporting a Mysql Table to Csv File Using phpMyAdmin
- 08:16Uploading Our PHP Project to a Bluehost Server
- 01:39HTML Form Validation Required and Email Attribute
- 01:08Where to Next
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.
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
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