How to Insert data into database in php mysql

Insert data into database in php mysql


In this tutorial, you will learn how to insert data into database in php mysql, where we will create a form, database connection and finally the processing code to save your data in MySQL Database.

Let's create a table named as students in database as given below:

CREATE TABLE `students` (
    id int NOT NULL AUTO_INCREMENT,
    fullname varchar(55) NOT NULL,
    course varchar(55) NOT NULL,
    email varchar(55) NOT NULL,
    PRIMARY KEY (id)
)  ENGINE=InnoDB DEFAULT CHARSET=latin1;


So guys, Lets get started to insert data in database in php mysql:

Step 1: Create a file named dbconfig.php to give the database connection in php.

<?php
    $host = "localhost";
    $username = "your_username";
    $password = "your_password";
    $database = "your_database_name";

    // Create DB Connection
    $conn = mysqli_connect($host, $username, $password, $database);

    // Check connection
    if (!$conn) {
        die("Connection failed: " . mysqli_connect_error());
    }
?>


Step 2: Create a file named student.php to make a HTML FORM. Also we will be using bootstrap v5 to design the FORM.

<!DOCTYPE html>
<html lang="en">
<head>
    <title>Insert Data in PHP MySQL</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet" />
</head>
<body>
   
    <div class="container mt-5">
        <div class="row justify-content-center">
            <div class="col-md-6">
                <div class="card shadow">
                    <div class="card-header">
                        <h4>Insert data into database in PHP MySQL</h4>
                    </div>
                    <div class="card-body">

                        <form action="code.php" method="POST">

                            <div class="mb-3">
                                <label>Full Name</label>
                                <input type="text" name="fullname" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label>Course</label>
                                <input type="text" name="course" class="form-control" required>
                            </div>
                            <div class="mb-3">
                                <label>Email ID</label>
                                <input type="email" name="email" class="form-control" required>
                            </div>
                         
                            <div class="mb-3">
                                <hr/>
                                <button type="submit" name="insert_buttton" class="btn btn-primary">Insert Data</button>
                            </div>

                        </form>

                    </div>
                </div>
            </div>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>


Step 3: Create a file named code.php to write the code to save data into database in php mysql.

<?php
    include_once 'dbconfig.php';

    if(isset($_POST['insert_buttton']))
    {    
        $fullname = $_POST['fullname'];
        $course = $_POST['course'];
        $email = $_POST['email'];

        $query = "INSERT INTO students (fullname,course,email) VALUES ('$fullname','$course','$email')";
        $result = mysqli_query($conn, $query);
        if($result)
        {
            echo "Data Inserted Successfully!";
        }
        else
        {
            echo "Data Not Inserted!. Error: " . $sql . "" . mysqli_error($conn);
        }
    }
?>


That's it. We successfully stored the Data.

Thanks for reading.