In this tutorial, We will learn how to store jquery select2 multiple select values into a database using ajax in PHP. We will store multiple select value jquery select 2 with ajax PHP example.



<html lang="en">
        <title>jquery select2 ajax php example</title>
        <link rel="stylesheet" href="" integrity="sha256-aAr2Zpq8MZ+YA/D6JtRD3xtrwpEz2IqOS+pWD/7XKIw=" crossorigin="anonymous" />
        <script src="" integrity="sha256-OFRAJNoaD8L3Br5lglV7VyLRf0itmoBzWUoM+Sji4/8=" crossorigin="anonymous"></script>
        <script src=""></script>
        <link href="" rel="stylesheet" />
        <script src=""></script>
        <div class="row mt-5">
            <div class="col-md-6 offset-3 mt-5">
                <div class="card">
                    <div class="card-header bg-info text-white">
                        <h5>PHP Select2 Multiple Select Ajax Example</h5>
                    <div class="card-body" style="height: 300px;">
                        <div class="row mb-2">
                            <div class="data-response col-md-12" style="display: none;">
                                <div class="alert alert-success"></div>
                        <form method="POST">
                            <div class="form-group">
                                <label>Title :</label>
                                <input type="text" name="title" class="form-control">
                            <div class="form-group">
                                <label>Category :</label>
                                <select class="category form-control" name="category[]" multiple>
                                    <option value="1">Laravel</option>
                                    <option value="2">Jquery</option>
                                    <option value="3">PHP</option>
                                    <option value="4">React</option>
                                    <option value="5">Jquery ui</option>
                                    <option value="6">Android</option>
                                    <option value="7">React Native</option>
                                    <option value="8">Vue js</option>
                                    <option value="9">Bootstrap 4</option>
                            <div class="form-group">
                                <button class="btn btn-success store-data btn-sm">Save</button>
        <script type="text/javascript">
            $(document).ready(function () {
            $('body').on('click', '.store-data', function (e) {
                var title = $('input[name=title]').val();
                var category = $('.category').val();
                    method: 'POST',
                    url: '/selectPro.php',
                    data: {
                        title: title,
                        category: category,
                    success: function (data) {
                        $('.data-response').css('display', 'block');
                        // setTimeout(function() {}unction(){$('.alert-success').hide();}, 3000);


    define (DB_USER, "root");
    define (DB_PASSWORD, "root");
    define (DB_DATABASE, "new_blog");//Database Name
    define (DB_HOST, "localhost");
    $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);

    $title = $_POST['title'];
    $category = implode(', ', $_POST['category']);

    $sql = "INSERT INTO posts (title,category) VALUES ('$title', '$category')";
    $result = $mysqli->query($sql);

    echo 'Data Inserted Successfully'

Thanks, May this example will help you...