PHP 101 question

See json_decode in PHP manual.

Will probably need to loop over data and do whatever you need to with it after decoded.

What's with the parens around this? Is this supposed to be an object an array?

fylzero

It is copy and paste from the output of print_r

jldrw

I actually ran json_encode to create that result. Maybe I haven't posed the question clearly. Basically, I want json, but I need to append values in my array, so that [product_code] is unique throughout the array, when product_code repeats, and there are different json values associated with it, the values will aggregate, like this.

[0] => [{first json bs}, {second json bs}, {third json bs}]

So here's my solution. PS I'm not going to tag myself as best answer so please chime in if you guys know a better way.

>>>DB::statement("
create table blah_blah_blah                                        
    (id int(11),                                                                     
    product_code varchar(255),                                                     
    json_bs text)                                                                      
");

then also in tinker

>>>for($i = 0; $i < count($json_bs); $i++){                                       
    DB::table('blah_blah_blah')->insert(array('id' => $i, 'product_code' => $json_bs[$i]['product_code'], 'json_bs' => $json_bs[$i][0]));                                    
}

Now I have a table in SQL and I'm going to use data manipulation language to sort this mess.

I'm sure there is a better way to do this, but I don't know it.

edited later... here's the magic SQL. Hope it helps someone.

mysql> create table very_blah 
                    select 
                        product_code, 
                        group_concat(distinct json_bs separator ', ') as json_bs 
                    from blah_blah_blah 
group by product_code;