Hi there,

i am trying to get a wpdatatable with a serialized php array to work but it doesnt.

I am always getting the "Table in data source has no rows." error.

This works fine:

$return_array[] = array(
'vdepot_id' => '1', // Set the ID
'Title' => 'test', // Set the title
'Content preview with link' => 'testcontent'
);

echo serialize( $return_array );

But when trying to create the array with a while loop it doesn't work:

while($row = mysqli_fetch_array($resultvdepots)) {
   $vdepotsarray[] = array(
   'vdepot_id' => $row['virtuellesdepot_id'],
   'vdepot_name' => $row['virtuellesdepot_name']
   );
}

echo serialize( $vdepotsarray );

The serialized output is this and it seems correct for me:

a:2:{i:0;a:2:{s:9:"vdepot_id";s:1:"5";s:11:"vdepot_name";s:24:"Langfristig (Fonds etc.)";}i:1;a:2:{s:9:"vdepot_id";s:1:"6";s:11:"vdepot_name";s:16:"Trading System 1";}}

why is wpdatatables not able to read this output?

Regards,

Michael

Hi,

unserializing works with a validator and there are no erros in the server log. This is the result of the unserialize function.

array (
  0 => 
  array (
    'vdepot_id' => '1',
    'vdepot_name' => 'Langfristig (Fonds etc.)',
  ),
  1 => 
  array (
    'vdepot_id' => '8',
    'vdepot_name' => 'Test',
  ),
)

i guess it has something to do with index array vs associative array...

Regards,

Michael

Hi Bogdan,

thanks, now the issue came to my mind. The Problem is that i have the "user_id" in my SQL Selection.

I am getting the user_id with the following code.

//access the wordpress functions
require_once('wp-load.php');

$user_id = get_current_user_id();  

--> It seems that this won't work when wpdatatables is trying to access the php file when serialized php array is chosen as the input data source type.

Is there a way to get this to work? I need to use the user_id for the sql selection for sure.

Regards,

Michael