hi Kyle,

I made some examples about multifiltering and column filtering for native php version of the library but it is very similar to this library.
you may wanna check these..

some online examples : (has no dependency on Codeigniter)
http://numberone.kodingen.com/datatables/examples/basic_init/
http://numberone.kodingen.com/datatables/examples/range_filtering/ //range filtering with where
http://numberone.kodingen.com/datatables/examples/range_filtering2/ //range filtering with filter
http://numberone.kodingen.com/datatables/examples/range_filtering_date/
http://numberone.kodingen.com/datatables/examples/multi_filtering/
http://numberone.kodingen.com/datatables/examples/range_filtering3

original post : http://datatables.net/forums/discussion/comment/22964#Comment_22964

Regards,
Yusuf

Hey,
I just want a really simple basic working example. But for some reason it doesn’t work.

The jQuery script:

The controller that outputs the json code

If you open the controller (localhost/mysite/home/getdatabyajax) you get this:

(Just some test database)

If you open the actual page you get the table, but it only shows “Processing…”.
Firebug shows me that the json code was loaded. Here is what I’m wondering: why is sEcho 0. Shouldn’t that be 1? If I manually change it to 1 the data is shown inside the table. If I understand it correctly, the value should get updatet everytime I update the table. Basically a draw count. So what is going wrong?
Another thing is: shouldn’t I only get the first 10 accounts, not all 14?

I’m working on this for far too long. Quite frustated right now :/
If anyone can help, I would appreciate it.
I pretty much followed this tutorial Ignited Datatables Tutorial on Vimeo

Thanks.

DiLer - I’m having the same exact problem. When I directly access my controller that produces the json I see the correct data output. I was also able to get it to work when I set bServerSide to false.

EDIT 2: I made two changes to get this to work.

First, set add “sServerMethod”: “POST” so your script looks something like:

Second, change Line 295 of the datatables library

From:

To:

I want to add a column by using add_column() function only under certain circumstances.

For example in a table with data, only if a user is the creator of the table’s row data to be able to edit it by showing a column like “Edit”, otherwise the column will be hidden or display nothing.

For now i am using this

And i would like the add_column to be added and shown only on certain rows based on a check that i will be doing if the user is the creator.

Is it possible somehow or do i have to edit the core of the datatables library?

Sport_Billy - 31 May 2012 07:28 AM

I want to add a column by using add_column() function only under certain circumstances.

For example in a table with data, only if a user is the creator of the table’s row data to be able to edit it by showing a column like “Edit”, otherwise the column will be hidden or display nothing.

For now i am using this

$this->datatables->select(SELECT VALUES);
            $this->datatables->from(TABLE);
            $this->datatables->where(CONDITION);
            $this->datatables->add_column('edit', '<a class="edit" href="$1">Edit</a>', 'id');
            return $this->datatables->generate(); 

And i would like the add_column to be added and shown only on certain rows based on a check that i will be doing if the user is the creator.

Is it possible somehow or do i have to edit the core of the datatables library?

OK i found a way, even if in my opinion is not the best one.

I am taking the output of the above function,
decoding using json_decode,
checking through other function for each desired json object ‘id’ if current user is its creator and if true then changing its ‘edit’ column value to the desired output,
then re-json_encode() and display the output.

There should be an easier way though.

laxdoctor - 30 May 2012 04:25 PM

DiLer - I’m having the same exact problem. When I directly access my controller that produces the json I see the correct data output. I was also able to get it to work when I set bServerSide to false.

EDIT 2: I made two changes to get this to work.

First, set add “sServerMethod”: “POST” so your script looks something like:

$(document).ready(function() {
 $('#test_table').dataTable( {
  "bProcessing": true,
  "bServerSide": true,
  "sServerMethod": "POST",
  "sAjaxSource": "/index.php/tables/listener"
 } );
} ); 

Second, change Line 295 of the datatables library

From:

if($sSearch != '') 

To:

if($sSearch != 0 && $sSearch != '') 

Oh man, thanks a lot!
At first it didn’t work, but I could figure out why. I enabled csrf protection in the config file. There is an issue with ajax and this option when set to TRUE.

The moment I disabled it, it worked. BUT I don’t want to disable it. So I googled for an hour or so and here is what I found:

http://unruhdesigns.com/blog/2012/03/a-simple-solution-to-codeigniter-csrf-protection-and-ajax
This pretty much explains the problem. I did not test the solution posted there, but it should work, too.

My solution was something I found here:
http://ellislab.com/forums/viewthread/214772/

This combined with some other stuff I found gave me this: (and it works!)

This works even with crsf_protection enabled.

So in the end I just changed the code as showed above and modified the datatables library as you mentionend.
I guess “sServerMethod”: “POST” and ajax(‘type’: ‘POST’) is pretty much the same?! That’s why I didn’t need it?!

Thanks again laxdoctor, you made my day (or year)

/edit
Ok the search does not work :/
Probably because of the modification of the datatables library…does anyone have a solution?

/edit2
Oh man I hope this is the right solution…
I found out that the sql queries are escaped wrong. Take a look at this:

This is what datatables does. But as you can see ‘somestring’ (the word I searched for) shouldn’t have the ‘’ around it. The query should be ...LIKE ‘%somestring%’ .... and not ...LIKE ‘%‘somestring’%’...

With that in mind I changed the datatables library back to normal. So line 295 is

again.
But I changed line 290 (I tested a lot of stuff, so maybe it’s a line above or under that, I’m not 100% sure).

The line is:

I changed it too

Now the string isn’t in quotes anymore and everything works fine. I hope this helps other people out there!

Sport_Billy - 31 May 2012 08:49 AM

Sport_Billy - 31 May 2012 07:28 AM

I want to add a column by using add_column() function only under certain circumstances.

For example in a table with data, only if a user is the creator of the table’s row data to be able to edit it by showing a column like “Edit”, otherwise the column will be hidden or display nothing.

For now i am using this

$this->datatables->select(SELECT VALUES);
            $this->datatables->from(TABLE);
            $this->datatables->where(CONDITION);
            $this->datatables->add_column('edit', '<a class="edit" href="$1">Edit</a>', 'id');
            return $this->datatables->generate(); 

And i would like the add_column to be added and shown only on certain rows based on a check that i will be doing if the user is the creator.

Is it possible somehow or do i have to edit the core of the datatables library?

OK i found a way, even if in my opinion is not the best one.

I am taking the output of the above function,
decoding using json_decode,
checking through other function for each desired json object ‘id’ if current user is its creator and if true then changing its ‘edit’ column value to the desired output,
then re-json_encode() and display the output.

There should be an easier way though.

make a helper function like this ..

Thank you very much ηυмвєяσηє !!!
The helper did exactly what i wanted

I am using an ajax source to load my data by setting “sAjaxSource” parameter and “bServerSide”: FALSE.
Data loads fine.

Now i am trying to set the parameter “bServerSide”: TRUE but it does not load and just shows “Loading data from server”.

What is the problem?
Should i set any other parameters?

In my controller i just ECHO the result of my Model:
Model:

Controller:

And here is my view’s js code:

hi,

actually you should not echo anything in the controller but instead do something like this

and then creat a view (raw_ajax.php in my example) with just

it should work a little better

have swing

I did rewrite one of my datatables view with mDataProp function for almost all columns using “aoColumns”. At the end I discovered that sorting a columns doesn’t work because Ignited Code is receiving ‘function’ for mDataProp. Is is possible to redefine that ‘function’ type by returning something from one of a few type of calls to mDataProp function?

I don’t like a solution with “aoColumnDefs” because I had to use “aTargets” with column numbers. mDataProp object approach is much better for my complicated and composed columns.

virtualgadjo - 13 June 2012 10:51 AM

hi,

actually you should not echo anything in the controller but instead do something like this

$data['result'] = $this->your_model->your_function();
$this->load->view('raw_ajax', $data); 

and then creat a view (raw_ajax.php in my example) with just

<?php echo $result; ?> 

it should work a little better

have swing

Hey thanks a lot for your reply.
I tryied what you suggested but still nothing displays if i set bServerSide: TRUE
If i set it to FALSE , everything works ok.

I converted two “mDataProp” columns from functions to ones as field names. Now Ignited Code makes a query with their names (field1 & field2) as filters:
WHERE (field1 LIKE ‘%’‘%’ OR field2 LIKE ‘%’‘%’ )

As there is no filter values the query returns no records instead of returning all records!?

echo prints result on the page as follows:
{“sEcho”:0,“iTotalRecords”:2,“iTotalDisplayRecords”:2,“aaData”:[[“1”,“23096720”,“MIHIR”,“mihir.parekh@abc.com”,“1”],[“2”,“12345”,“Mihir”,“abc@gmail.com”,“1”]],“sColumns”:“id,username,name,email,login_count”}

The table just displays processing…

My controller

My View

My Template initializing script

Please help me solve this issue

concat is not working on select