Connect jquery dataTables (with CRUD functions) to mysql

Question

I'm beginer to web development and I find on net something really usefull jquery datatables but now I have a problem becouse I know just javascript and jquery, so I have a problem How to connect datatable to mysql and how to send request and recieve response from server.

Here is the demo: https://editor.datatables.net/release/DataTables/extras/Editor/examples/bootstrap.html

So how I can connect this code example with my mysql dataBase?

Is there any tutorial step by step or something like that?

I need to do request and response ... I see in example file dataTables.php but this file is not in documentation...

I need some example with basic CRUD function and how to connect dataTable with mysql database... — MikiMrki
– MikiMrki, Commented Jan 22, 2014 at 16:14
did you look at this? datatables.net/release-datatables/examples/data_sources/… — Sionnach733
– Sionnach733, Commented Jan 22, 2014 at 16:30

RMBL21 · Accepted Answer · 2014-01-22 16:48:24Z

1

The best way to do this is using ajax.

You can request the items using datatables and fill the table with a json response.

Here's an example

                  $('#yourTable').dataTable(
                    {

                        "bDestroy" : true,
                        "iDisplayLength" : 20,
                        "sAjaxDataProp" : "",
                        "bPaginate": false,
                        "bInfo": false,
                        "sAjaxSource" : "foo.php (Json to fill the table)"
                        "aoColumns" : [ {
                            "mData" : "person.age"
                        }, {
                            "mData" : "person.name"
                        }, 
                           {
                            "mData" : "person.id",
                        }, 
                           {
                            "mData" : "time",
                        }]
                    });

mData are basically your table columns, and datatables will fill each of those mData colums with the json you designated.

You can read documentation on how mData works here:

http://datatables.net/usage/columns > Scroll to mData

Here is an example on how to get the mysql data from php for datatables.

http://datatables.net/examples/data_sources/server_side.html

For a basic implementation you just need the queries.

Hope it helps!

answered Jan 22, 2014 at 16:48

RMBL21

1066 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

MikiMrki Over a year ago

yes but I want to get data from mysql database and not to send request on every search... just to send request on read, add, delete ... o this example on every search I send request... this is not really usefull

MikiMrki Over a year ago

ok, I just want to catch full table and do the basic CRUD (create , read, update, delete) functions

RMBL21 Over a year ago

Alright, you basically want to be able to do all the basic CRUD functions from the datatable?

MikiMrki Over a year ago

yes, just crud function and search function to not call database

MikiMrki Over a year ago

I try to use this plugin: editor.datatables.net/purchase but this plugin cost 70 euros ... so I dont want to pay them for basic crud functions...

|

Collectives™ on Stack Overflow

Connect jquery dataTables (with CRUD functions) to mysql

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related