How to Insert Checkbox Value into database in PHP MySQL

By Super Admin | May 15, 2021 | PHP
Share : Whatsapp

https://www.fundaofwebit.com/post/how-to-insert-checkbox-values-into-database-in-php-mysql

Insert Checkbox Value into database in PHP MySQL


In this article, you will be learn that how to insert checkbox values into mysql database in php mysql, which the data will be fetch from input checkbox with form tag on submit and send the input checkbox values to mysql query, so it can will save or insert checkbox value in php mysql. 

Lets get started: (How to insert single checkbox value into database in php mysql)

Note: For better and detailed understanding. please watch out the Video above.

Step 1: Create a table named demo into your Database (MySQL) as follows:

CREATE TABLE `demo` (
    `id` int(11NOT NULL,
    `name` varchar(191NOT NULL,
    `agree` varchar(20NOT NULL
);


Step 2: Create a index.php file and paste the below html form design code:

<?php session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Funda of Web IT</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-md-8">

                <?php 
                    if(isset($_SESSION['status']))
                    {
                        ?>
                            <div class="alert alert-warning alert-dismissible fade show" role="alert">
                            <strong>Hey!</strong> <?php echo $_SESSION['status']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                            </div>
                        <?php
                         unset($_SESSION['status']);
                    }
                ?>

                <div class="card mt-5">
                    <div class="card-header">
                        <h4>How to Insert Checkbox value into Database in php</h4>
                    </div>
                    <div class="card-body">

                        <form action="code.php" method="POST">
                            <div class="form-group mb-3">
                                <label>Name</label>
                                <input type="text" name="name" class="form-control" />
                            </div>
                            <div class="form-group mb-3">
                                <input type="checkbox" name="agree" value="I agree to it" /> I agree to this terms and condition.
                            </div>
                            <div class="form-group mb-3">
                                <button type="submit" name="save_checkbox" class="btn btn-primary">Save Data</button>
                            </div>
                        </form>

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

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

Now, when you click on the Submit button, the <form> contains action="code.php" so, lets write the code:

Step 3: Create a code.php file and paste the below code to insert checkbox data in MySQL Database in php.

<?php
session_start();
$con = mysqli_connect("localhost","root","","phptutorials");

if(isset($_POST['save_checkbox']))
{
    $name = $_POST['name'];
    $agree = $_POST['agree'];

    $query = "INSERT INTO demo (name,agree) VALUES ('$name','$agree')";
    $query_run = mysqli_query($con$query);
    
    if($query_run)
    {
        $_SESSION['status'] = "Inserted Successfully";
        header("Location: index.php");
    }
    else
    {
        $_SESSION['status'] = "Not Inserted";
        header("Location: index.php");
    }
}
?>


Thanks for reading...