Hello, I'm using your plugin to create queries based on information I've already put inside the post (Mysql option), but some of the results look like this
a:1:{i:0;s:3:"910";}
I am not an engineer, but I understand that this is a JSON encoding, has this happened to you before? Any way to solve it?
That is related with saving these values in database. When you execute that query in phpMyAdmin you are probably getting same results with JSON values for that column?
wpDataTable is showing exact data like you execute query in phpMyAdmin. You can take a look at these posts how to return data that is saved in JSON format. Before you create table in wpDataTable from MySQL please check your query does it work in phpMyAdmin.
Hello, I'm using your plugin to create queries based on information I've already put inside the post (Mysql option), but some of the results look like this
a:1:{i:0;s:3:"910";}
I am not an engineer, but I understand that this is a JSON encoding, has this happened to you before? Any way to solve it?
url: http://spineda.co/CJYC-DEV/perfiles/
Hi Sebastian,
Thank you for your purchase/
That is related with saving these values in database. When you execute that query in phpMyAdmin you are probably getting same results with JSON values for that column?
Hi Milos, yes I getting same results with JSON values for that column
Hi Sebastian,
wpDataTable is showing exact data like you execute query in phpMyAdmin. You can take a look at these posts how to return data that is saved in JSON format. Before you create table in wpDataTable from MySQL please check your query does it work in phpMyAdmin.
https://dev.mysql.com/doc/refman/5.7/en/json.html
http://stackoverflow.com/questions/29137915/how-can-write-queries-in-mysql-that-can-parse-json-data-in-a-column