How to save a table contents in a database using ajax php

Question

I have a jquery script that is producing content to a table and i was wondering how to save all the added rows on that table to a database at once using ajax and php.

Btw im using dataTable.

example table: http://i38.photobucket.com/albums/e149/eloginko/table_zps20bbecb1.png

This is how my table do: http://jsfiddle.net/4GP2h/104/

my script:

$("#dialog-confirm").dialog({
    resizable: false,
    height: 140,
    modal: true,
    autoOpen: false,
    buttons: {
        "Close": function () {
            $(this).dialog("close");
        }
    }
});
var dataSet;
try{
    dataSet = JSON.parse(localStorage.getItem('dataSet')) || [];
} catch (err) {
    dataSet = [];
}
$('#myTable').dataTable({
    "data": [],
        "columns": [{
        "title": "Name"
    }, {
        "title": "Age"
    }, {
        "title": "Gender"
    }, {
        "title": "Action"
    }],
        "bStateSave": true,
        "stateSave": true,
        "bPaginate": false,
        "bLengthChange": false,
        "bFilter": false,
        "bInfo": false,
        "bAutoWidth": false
});
oTable = $('#myTable').DataTable();
for (var i = 0; i < dataSet.length; i++) {
    oTable.row.add(dataSet[i]).draw();
}

$('#Save').click(function () {
    if ($('#name').val() == '' || $('#age').val() == '' || $("input[name='gender']:checked").val() == undefined) {
        $("#dialog-confirm").dialog("open");

    } else {

        var data = [
            $('#name').val(),
            $('#age').val(),
            $("[name='gender']:checked").val(),
            "<button class='delete'>Delete</button>"
        ];
        oTable.row.add(data).draw();
        dataSet.push(data);
        localStorage.setItem('dataSet', JSON.stringify(dataSet));      
    }
});

$(document).on('click', '.delete', function () {
    var row = $(this).closest('tr');
    oTable.row(row).remove().draw();
    var rowElements = row.find("td");
    for (var i = 0; i < dataSet.length; i++) {
        var equals = true;
        for (var j = 0; j < 3; j++) {
            if (dataSet[i][j] != rowElements[j].innerHTML) {
                equals = false;
                break;
            }
        }
        if (equals) {
            dataSet.splice(i, 1);
            break;
        }
    }
    localStorage.setItem('dataSet', JSON.stringify(dataSet));
});

Just send the whole table array over to PHP script --- http://stackoverflow.com/questions/2013728/passing-javascript-array-to-php-through-jquery-ajax -- and then read it - split it --and do whatever — Tasos, Jul 20 '14 at 15:42

score 0 · Answer 1 · answered Nov 19 '14 at 14:01

Add a form tag to your code:

<form id='myform'>
    <div id="dialog-confirm" title="Error">
        <p><span class="ui-icon ui-icon-alert" style="float:left; margin:0 7px 0px 0;"></span>Please fill all the required fields!</p>
    </div>

    <br />
    <br />Name:
    <input type="text" name="name" id="name" />
    <br />Age:
    <input type="text" name="age" id="age" />
    <br />Gender:
    <input type="radio" name="gender" value="Male" />Male
    <br />
    <input type="radio" name="gender" value="Female" />Female
    <br />
    <button id="Save" name="Save">Save</button>
    <div class="container well">
        <table id="myTable" class="table table-striped table-bordered" cellspacing="0" width="100%">
            <tr>
                <td>
                    Line 1 Edit
                </td>
                <td>
                    <input type='text' name='line1' />
                </td>
            </tr>
            <tr>
                <td>
                    Line 2 Edit
                </td>
                <td>
                    <input type='text' name='line2' />
                </td>
            </tr>
        </table>
    </div>
</form>

Then you can use jquery to send it to your server var formdata = $("#myform").serialize()

formdata will have the data from the form into the variable ready for a post or get request. Then use $.post("myurl?" + formdata, function(response_from_server){alert(response_from_server);})

How to save a table contents in a database using ajax php

1 Answers1