[Plugin: dbview] PHP snippet to a list of record in multidimensional array

Ok. I understand the problem. Will get back to you tomorrow. I think we need to have a row level php snippet. It would be easy to add the functionality but it needs to be simple to use.

Do you want to filter particular records? It’s not possible to filter records using anything other than the SQL where clause.

But if you just want to show a particular field, the snippet is
`return $value[$xyz][2];
where $xyz is ‘Griffin’ or ‘Brown’.

Do you want to represent your record above as 1 row or as 3 rows? Can you show me what result you are looking for?

Hi John,

We want to show the following values as result:
Megan
Junior

I’m using:return $value[$Griffin][2];
but i cann’t get what i want.

Instead, i received the following warning:
Warning: Illegal string offset ‘data’ in …\wp-content\plugins\dbview\DBViewTable.class.php(153) : runtime-created function on line 1
{“success”:true,”messages”:[“Note: this query has not been saved.<\/span>”,”1 rows found.<\/span>”],”updates”:[{“selector”:”.dbview”,”html”:”

project 1<\/h2>\r\n\r\n
1 item<\/span><\/th><\/tr>
data<\/th><\/tr>
return $value[$Griffin][2];<\/th><\/tr><\/thead>\r\n
:<\/td><\/tr><\/tbody>\r\n<\/table style=’width:98%’>”}],”_ajax_nonce”:”86a4ef1147″}

Kindly assist.

Thank you.

If you create a table using

create table familyguy (tree varchar(300));
insert table familyguy values('a:3:{s:7:"Griffin";a:3:{i:0;s:5:"Peter";i:1;s:4:"Lois";i:2;s:5:"Megan";}s:8:"Quagmire";a:1:{i:0;s:5:"Glenn";}s:5:"Brown";a:3:{i:0;s:9:"Cleveland";i:1;s:7:"Loretta";i:2;s:6:"Junior";}}');

then using
select tree, tree as tree1 from familyguy
with the PHP snippet

$o = unserialize($value);
$res = array();
if (is_array($o))
  foreach($o as $v)
  {
    $res[] = $v[2] ;
  } ;
return implode("<br/>", $res);

You get in one cell in a table

Megan

Junior

Are we closer?