Concatenating array rows php

Question

This may be a stupid question, so please go easy on me if so.

I have a range of queries (MySQL) returning multidimensional arrays.

I then use these array items to populate variables in a string in a foreach loop.

I then need this string to populate a javascript graph so the format of the data wants to be perfect. this idea works with 1 multidimensional array.

However. To do multiple graphs (e.g comparison line graph) I need to express all the data in the same row.

So what I need to be able to do is if possible merge row to row of the array, rather than add it to the end.

Ill show you my working:

foreach ($graph_month as $month) :
        $first .= ' { year: "'.$month['month'].'",';
        endforeach;

        foreach ($graph_data1 as $data) :
        $second1 .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;

        foreach ($graph_data2 as $data) :
        $second2 .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;

        foreach ($graph_data3 as $data) :
        $second3 .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;

        foreach ($graph_data4 as $data) :
        $second4 .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;

        foreach ($graph_data5 as $data) :
        $second5 .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;

So each of the foreach's is populating a little section of the javascript required, however I need to be able to concatenate all these rows on the right of each other.

e.g

a foreach that can produce:

$first.$second1.$second2.$second3.$second4.$second5

Is this possible, would it be possible to add [i] and [i++] to each variable.

Is the expected end result JSON?

iambriansreed
– iambriansreed

2012-09-06 14:16:48 +00:00
Commented Sep 6, 2012 at 14:16 — iambriansreed
– iambriansreed, Commented Sep 6, 2012 at 14:16

cassi.lup · Accepted Answer · 2012-09-06 14:24:22Z

To start with, you could eliminate the extra foreach lines by generating variables like this:

foreach ($graph_month as $month):

    for ($i = 1; $i <=5; $i++) {
        //$graph_data$i becomes $graph_data1, then $graph_data2 etc.
        foreach ($graph_data$i as $data) :
            $variable .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
        endforeach;
    }

// and so on
endforeach;

The outcome of this script is, as you requested, something of this shape:

{year: month, title: value title: value

We can tweak it a little like this:

foreach ($graph_month as $month):

    $variable .= ' { year: "'.$month['month'].'",';

    for ($i = 1; $i <=5; $i++) {
        //$graph_data$i becomes $graph_data1, then $graph_data2 etc.
        foreach ($graph_data$i as $data) :
            $variable .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
            if ($i != 5) {
                $variable .= ", ";
            }
        endforeach;
    }

    $variable .= 

// and so on
endforeach;

and it becomes:

{ year: month, 'title': 'value', 'title': 'value', ... }

Evert · Accepted Answer · 2012-09-06 14:17:31Z

1

You can put same variable:

foreach ($graph_month as $month) {
    $variable .= ' { year: "'.$month['month'].'",';
}

foreach ($graph_data1 as $data) {
    $variable .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
}

foreach ($graph_data2 as $data) {
    $variable .= ' "'.$data['title'].'": '.$data['totalValue'].' ';
}

// and so on

they will concatenate on every loop.

edited Sep 6, 2012 at 14:17

Evert

101k18 gold badges136 silver badges221 bronze badges

answered Sep 6, 2012 at 14:14

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Comments

Basith · Accepted Answer · 2012-09-06 14:17:25Z

0

You can use the for loop like this...

<?php 

for($i=0;$i<count($graph_month);$i++)
{
    $all_values1 = $graph_data1[$i]['title'] . $graph_data1[$i]['totalValue'];
    $all_values2 = $graph_data2[$i]['title'] . $graph_data2[$i]['totalValue'];
    $all_values3 = $graph_data3[$i]['title'] . $graph_data3[$i]['totalValue'];
    $all_values4 = $graph_data4[$i]['title'] . $graph_data4[$i]['totalValue'];
    $all_values5 = $graph_data5[$i]['title'] . $graph_data5[$i]['totalValue'];
}

?>

No need to run too may for loop. It will take some extra time to execute...

Try like this....

answered Sep 6, 2012 at 14:17

Basith

1,0757 silver badges22 bronze badges

Comments

mymotherland · Accepted Answer · 2012-09-06 14:19:09Z

0

Use Empty String

$string = '';

Then use this variable with every for loop

foreach($array1 as $value){
$string.= $value['some_data'];
}

foreach($array2 as $value){
$string.= $value['some_data'];
}

Use this $string as final result

answered Sep 6, 2012 at 14:19

mymotherland

8,24614 gold badges70 silver badges124 bronze badges

Comments

iambriansreed · Accepted Answer · 2012-09-06 14:27:22Z

Let PHP worry about the JSON formatting just build the object correctly.

<?php

$tojson = array(
     0 => array(),
     1 => array(),
     2 => array(),
     3 => array(),
     4 => array(),
     5 => array()
);

foreach($graph_month as $month)
    $tojson[0]['year'] = $month['month'];

foreach($graph_data1 as $data)
    $tojson[1][$data['title']] = $data['totalValue'];

foreach($graph_data2 as $data)
    $tojson[2][$data['title']] = $data['totalValue'];

foreach($graph_data3 as $data)
    $tojson[3][$data['title']] = $data['totalValue'];

foreach($graph_data4 as $data)
    $tojson[4][$data['title']] = $data['totalValue'];

foreach($graph_data5 as $data)
    $tojson[5][$data['title']] = $data['totalValue'];

$json = json_encode($tojson);

?>

Collectives™ on Stack Overflow

Concatenating array rows php

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related