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:
<ul>
<li>How to create a form in HTML</li>
<li>Different types of input controls for different types of data</li>
<li>How to validate the form data in PHP</li>
<li>Different techniques for saving the data to a MySQL database</li>
<li>How to do all this securely and safely.</li>
</ul>
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.

Introduction

Set Up Your Development Environment: Install Recommended Software

Create an HTML File and View it in the Browser

Add a Form with a Simple Text Input and Associated Label

Add Different Types of Controls for Entering Text

Add a CSS Style Sheet to Easily Add Formatting to the Form

Add a Control to Select a Value from a Drop-down List

Add Controls to Select One Value From a Range of Options

Add a Control to Choose Between Two Mutually Exclusive Options

Add a Button and Attributes to Send the Form's Data to the Server

Add a File to Process the Submitted Form Data and Change How it's Sent

Change the Values Sent from the Select, Radio and Checkbox Inputs

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

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

Filter the Checkbox Input and Optionally Filter the Values into an Array

Validate the Form Data and Output a Validation Message if Invalid

Validate the Form using Client-Side Validation in the Browser

Create a Database to Store the Data from the Form

Create a Table in the Database to Store Ticket Records

Connect to the Database from PHP

Insert a New Record into the Database from PHP

Manually Escape String Values to Avoid an SQL Injection Attack

Use a Prepared Statement to Insert a New Record

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

Your Class Project: Create a Form and Save the Form Data to a Database

Conclusion

source-code.zip

An Introduction to PHP and MySQL

Dave Hollingworth gave you 1 free month of Skillshare

Get 1 free month of Skillshare

An Introduction to PHP and MySQL

Creative Learning Made Easy

Company

Work With Us

Teach with Us

Shop

Mobile