How to fetch data from array?

[mihirpatel83]

I have a field called extra_fields in a table......and its content is

[{"id":"2","value":"1"},{"id":"1","value":"1"},{"id":"3","value":""},{"id":"4","value":""},{"id":"5","value":""},{"id":"6","value":"<br \/>"},{"id":"7","value":"<br \/>"},{"id":"8","value":"<br \/>"},{"id":"9","value":"<br \/>"},{"id":"10","value":"1"}]

Now i want to check with if condition that if have value 1 or 0 with id :10.....
I just dont know how to access that....

Edit/Delete Message

[NogDog]

I think you want to [man]unserialize/man it, which will give you a normal PHP array you can the manipulate as normal.

[bradgrafelman]

Better yet, you should have a read through this thread.

Assuming by "table" you meant a table in a DBMS (such as MySQL), why use a database at all if you're just storing a bunch of JSON-encoded data? Might as well use a featureless flat file instead.

[NogDog]

Upon further review, that is JSON data, in which case you'd want to use [man]json_decode/man instead

<?php
$text = '[{"id":"2","value":"1"},{"id":"1","value":"1"},{"id":"3","value":""},{"id":"4","value":""},{"id":"5","value":""},{"id":"6","value":"<br \/>"},{"id":"7","value":"<br \/>"},{"id":"8","value":"<br \/>"},{"id":"9","value":"<br \/>"},{"id":"10","value":"1"}]';
$data = json_decode($text, true);
echo "<pre>";print_r($data);echo "</pre>";

[mihirpatel83]

Sorry guys for getting back late....

@: I am gng through the thread that u provided with....

@ : I tried below thing

code

$myArray = json_decode($item->extra_fields);
echo "<br/>O/P 1:".print_r($myArray);
echo "<br/>O/P 2:".$myArray;

Output

O/P 1:1
O/P 2:

[Note: Using true in json_ecode function as second paramter even the O/P 1 display blank ]

[mihirpatel83]

For better information i am dumping the item field and its value.....Hope it helps...

CODE

echo 'ITEM: <br/>';var_dump($item);
echo '<br/><br/> EXTRAFIELD : '; print_r($item->extra_fields);
$text = $item->extra_fields;
$data = json_decode($text);
echo '<br/> DECODED :';echo "<pre>";print_r($data);echo "</pre>";

OUTPUT

ITEM:
object(TableK2Item)#201 (39) { ["id"]=> string(2) "30" ["title"]=> string(15) "Good Practice 3" ["alias"]=> string(15) "good-practice-3" ["catid"]=> string(1) "6" ["published"]=> string(1) "1" ["introtext"]=> string(0) "" ["fulltext"]=> string(0) "" ["image_caption"]=> string(0) "" ["image_credits"]=> string(0) "" ["video"]=> NULL ["video_caption"]=> string(0) "" ["video_credits"]=> string(0) "" ["gallery"]=> NULL ["extra_fields"]=> string(677) "[{"id":"2","value":"1"},{"id":"1","value":"1"},{"id":"3","value":""},{"id":"4","value":""},{"id":"5","value":""},{"id":"6","value":"<br \/>"},{"id":"7","value":"<br \/>"},{"id":"8","value":"<br \/>"},{"id":"9","value":"<br \/>"},{"id":"10","value":"1"}]" ["extra_fields_search"]=> string(74) "Club 1 Germany <br /> <br /> <br /> <br /> Yes " ["created"]=> string(19) "2011-06-17 09:48:14" ["created_by"]=> string(2) "88" ["created_by_alias"]=> string(0) "" ["modified"]=> string(19) "2011-06-17 09:48:14" ["modified_by"]=> string(2) "88" ["publish_up"]=> string(19) "2011-06-17 00:00:00" ["publish_down"]=> string(5) "Never" ["checked_out"]=> string(2) "88" ["checked_out_time"]=> string(19) "2011-06-17 09:48:15" ["trash"]=> string(1) "0" ["access"]=> string(1) "2" ["ordering"]=> string(1) "4" ["featured"]=> string(1) "0" ["featured_ordering"]=> string(1) "0" ["hits"]=> string(1) "0" ["metadata"]=> string(0) "" ["metadesc"]=> string(0) "" ["metakey"]=> string(0) "" ["params"]=> string(0) "" ["plugins"]=> string(0) "" ["tbl"]=> string(11) "#__k2_items" ["tbl_key"]=> string(2) "id" ["db"]=> &object(JDatabaseMySQL)#11 (19) { ["name"]=> string(5) "mysql" ["nullDate"]=> string(19) "0000-00-00 00:00:00" ["nameQuote"]=> string(1) "`" ["sql"]=> string(93) "SELECT id AS value, name AS text FROM jos_groups WHERE id IN (0,1,2) OR id = '2' ORDER BY id" ["errorNum"]=> int(0) ["errorMsg"]=> string(0) "" ["table_prefix"]=> string(4) "jos" ["resource"]=> resource(24) of type (mysql link) ["cursor"]=> resource(139) of type (Unknown) ["debug"]=> int(0) ["limit"]=> int(0) ["offset"]=> int(0) ["ticker"]=> int(0) ["log"]=> array(0) { } ["utf"]=> bool(true) ["quoted"]=> array(0) { } ["hasQuoted"]=> bool(false) ["errors"]=> array(0) { } ["debug"]=> int(0) } ["errors"]=> array(0) { } }

EXTRAFIELD : [{"id":"2","value":"1"},{"id":"1","value":"1"},{"id":"3","value":""},{"id":"4","value":""},{"id":"5","value":""},{"id":"6","value":"<br \/>"},{"id":"7","value":"<br \/>"},{"id":"8","value":"<br \/>"},{"id":"9","value":"<br \/>"},{"id":"10","value":"1"}]
DECODED :