Inserting form data into MySQL table using PHP

Current Location：Home > Learning > DATABASE > MySQL >

PostgreSQL MySQL Redis MongoDB

Inserting form data into MySQL table using PHP

Author：JIYIK Last Updated：2025/04/25 Views：

This article will show you how to send data from an HTML form to a table in a database.

To do this, we will use the following steps:

First, we'll create a basic HTML form to collect data.
We will then use POSTthe method to send the data from our HTML form to a table in our database.

sample tutorialWe have a table called in our database parkinglot1. Here is what the table looks like:

Update Table

Suppose we have a new entry to add to the table. Our new entry is as follows, BrandNamefor Ferrari, OwnersNamefor Alex, RegistrationNumberfor KJG564R.

How do we approach this problem? The first step is to create an HTML form to collect new data.

Create an HTML form to collect data

We will have three slots for inputting data and a submit button in our HTML form. We do not need to include CarIDthe slots because PHP will automatically update the entries.

<!DOCTYPE html>
<html lang="en">

<head>
    <title>Form- Store Data</title>
</head>

<body>
<center>

<h1>This Form is For Storing Data for OUR Database</h1>

<form action="includes/insert.php" method="POST">

<p>
 <label for="CarID">Car ID:</label>
 <input type="text" name="CarID" id="CarID">
</p>

<p>
 <label for="BrandName">Brand Name:</label>
 <input type="text" name="BrandName" id="BrandName">
</p>

<p>
<label for="OwnersName">Owners Name:</label>
<input type="text" name="OwnersName" id="OwnersName">
</p>

<p>
 <label for="RegistrationNumber">Registration Number:</label>
 <input type="text" name="RegistrationNumber" id="RegistrationNum">
</p>

 <input type="submit" value="Submit">

</form>
</center>
</body>
</html>

Output:

Our forms

Now we can write the code to send data to our database.

Use `POST`the method to send data from an HTML form to a table in a PHP database

<?php
$user = 'root';
$pass = '';
$db = 'sample tutorial';
//Replace 'sample tutorial' with the name of your database

$con = mysqli_connect("localhost", $user, $pass, $db);

if ($con->connect_error) {
  die("Connection failed: " . $con->connect_error);

}

  $CarID = $_POST['CarID'];
  $BrandName = $_POST['BrandName'];
  $OwnersName = $_POST['OwnersName'];
  $RegistrationNumber = $_POST['RegistrationNumber'];

  $sql = "INSERT INTO parkinglot1 (CarID,BrandName,OwnersName, RegistrationNumber)
     VALUES ('$CarID','$BrandName','$OwnersName', '$RegistrationNumber')";
     mysqli_query($con, $sql);

     header("Location: ../form.php"); // Return to where our form is stored
?>

header()The function will return our HTML form, where we can fill in the values we want to insert, like this:

Fill out the form

After submitting the data, the updated form should look like this:

Updated database tables

Previous：Optimizing tables and databases in MySQL

Next：Finding error logs in MySQL

For reprinting, please send an email to 1244347461@qq.com for approval. After obtaining the author's consent, kindly include the source as a link.

Article URL：

JIYIK CN >