Save Data to a MySQL Database using PHP

Focused View

Dave Hollingworth

1:11:31

11 View

01. Introduction.mp4

02:12

02. Set Up Your Development Environment Install Recommended Software.mp4

01:24

03. Create an HTML File and View it in the Browser.mp4

02:17

04. Add a Form with a Simple Text Input and Associated Label.mp4

03:10

05. Add Different Types of Controls for Entering Text.mp4

02:49

06. Add a CSS Style Sheet to Easily Add Formatting to the Form.mp4

01:30

07. Add a Control to Select a Value from a Drop-down List.mp4

01:35

08. Add Controls to Select One Value From a Range of Options.mp4

03:25

09. Add a Control to Choose Between Two Mutually Exclusive Options.mp4

01:06

10. Add a Button and Attributes to Send the Forms Data to the Server.mp4

02:28

11. Add a File to Process the Submitted Form Data and Change How its Sent.mp4

02:50

12. Change the Values Sent from the Select, Radio and Checkbox Inputs.mp4

03:10

13. Avoid Errors if a Value is not Part of the Form Data.mp4

02:17

14. Apply a Filter to the Form Values, Validating the Data Type and Range.mp4

03:32

15. Filter the Checkbox Input and Optionally Filter the Values into an Array.mp4

03:45

16. Validate the Form Data and Output a Validation Message if Invalid.mp4

04:58

17. Validate the Form using Client-Side Validation in the Browser.mp4

03:22

18. Create a Database to Store the Data from the Form.mp4

01:49

19. Create a Table in the Database to Store Ticket Records.mp4

01:28

20. Connect to the Database from PHP.mp4

03:21

21. Insert a New Record into the Database from PHP.mp4

04:36

22. Manually Escape String Values to Avoid an SQL Injection Attack.mp4

03:47

23. Use a Prepared Statement to Insert a New Record.mp4

04:23

24. Use the Post-Redirect-Get Pattern to Avoid Duplicate Form Submissions.mp4

03:53

25. Your Class Project Create a Form and Save the Form Data to a Database.mp4

01:22

26. Conclusion.mp4

01:02

source-code.zip.zip

Description

Getting data from a form in a web browser into a database on the server is a key skill for any web developer. In this class you'll learn how to create a form in HTML, how to validate the data in PHP, and how to save it to a MySQL database.

In short, specific lessons, you'll learn:

How to create a form in HTML
Different types of input controls for different types of data
How to validate the form data in PHP
Different techniques for saving the data to a MySQL database
How to do all this securely and safely.

This class is for beginners to web development that need to learn one of the fundamental skills when creating a website - getting data from a visitor to your website into a database on the server.

In the class project you'll be creating your own form in HTML, processing the data from that form in PHP, and saving it to a MySQL database.

Basic knowledge of HTML, PHP and SQL are recommended, but all the code shown in the videos is explained in full, along with links to relevant documentation when necessary.

In addition, all the source code shown in the videos is available to download. Plus, if you need help from me directly, you can ask a question in the discussion section.

What You'll Learn?

Technology
Web Development
HTML
Php
SQL
Form Validation
PHP Development

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PHP

MySQL

Database Programming

Dave Hollingworth

Instructor's Courses

Hi, I'm Dave Hollingworth. I'm an IT trainer and web application developer. I've been writing code and teaching IT for over twenty years.

I've developed enterprise-level applications on platforms ranging from mainframes to mobiles: from my first web application, a quotes system created for a major insurance company back in 1999 - the first of its type in the sector - to interactive learning management systems for online language learning.

I've taught courses ranging from basic use of email to advanced web application development, both online and in-person.

I'm passionate about technology, and love teaching it! I believe it's possible to explain even the most complex subjects in a simple, straightforward way that doesn't confuse the student.

I look forward to welcoming you onto one of my courses!

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.