PHP-CRUD-2 : How to Insert data into database in php

Hie Guys, In this article we are going to insert data into database using bootstrap design form in php, where we are creating a table named student and store the records of it. so lets get started.

Step 1: Create a database phpcrud and in that create a table named student : 


CREATE TABLE student (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    fname VARCHAR(30) NOT NULL,
    lname VARCHAR(30) NOT NULL,
    contact VARCHAR(50) NOT NULL,
)


Step 2: Create a file named insertdata.php and we will use bootstrap to design the form and store data through that html form, where code given below:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <title>Document</title>
</head>
<body>
    <div class="container">
        <div class="jumbotron">
            <div class="row">
                <div class="col-md-12">
                  
                    <h2> PHP - CRUD : ADD Data </h2>
                    <hr>
                    <form action="" method="post">
                        <div class="form-group">
                            <label for=""> First Name </label>
                            <input type="text" name="fname" class="form-control" placeholder="Enter First Name" required>
                        </div>
                        <div class="form-group">
                            <label for=""> Last Name </label>
                            <input type="text" name="lname" class="form-control" placeholder="Enter Last Name" required>
                        </div>
                        <div class="form-group">
                            <label for=""> Contact </label>
                            <input type="text" name="contact" class="form-control" placeholder="Enter Contact" required>
                        </div>

                        <button type="submit" name="insert" class="btn btn-primary"> Save Data </button>

                        <a href="index.php" class="btn btn-danger"> BACK </a>
                    </form>
                      
                </div>
            </div>
        </div>
    </div>
</body>
</html>

The above code is about html form design which we have done by using Bootstrap and now to store the data into database paste the below code into same form named insertdata.php


<?php

$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection'phpcrud');

if(isset($_POST['insert']))
{
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
    $contact = $_POST['contact'];

    $query = "INSERT INTO student(`fname`,`lname`,`contact`) VALUES ('$fname','$lname','$contact')";
    $query_run = mysqli_query($connection$query);

    if($query_run)
    {
        echo '<script> alert("Data Saved"); </script>';
    }
    else
    {
        echo '<script> alert("Data Not Saved"); </script>';
    }
}

?>


Thats all Guys.. now you can store the Data into database in php.

© Copyright - 2018 - 2021 | All rights reserved at Funda of Web IT