php - Foreach overwrites previous records in multidimensional array -

-

i have multidimensional array, , want show array in tabular form like

+------+-----+--------+-------+-------+ | name | red | yellow | green | white | +------+-----+--------+-------+-------+ | abc  |   8 |      2 |     4 |     0 | | xyz  |   2 |      8 |     0 |     0 | +------+-----+--------+-------+-------+

the following array i've

[0] => array(         'label'=> 'red',         [value] => array         (                 [0] => array                 (                         [count] => 47                         [firstname] => syst                  )                 [1] => array                 (                         [count] => 2                         [firstname] => xyz                 )                  [2] => array                 (                         [count] => 8                         [firstname] => abc                 ) ) [1] => array(         'label'=> 'yellow',         [value] => array         (                 [0] => array                 (                         [count] => 4                         [firstname] => dim                 )                 [1] => array                 (                         [count] => 2                         [firstname] => abc                 )                 [2] => array                 (                         [count] => 8                         [firstname] => xyz                 )         )

and on have tired below code don't know whats problem code.

foreach($rows $row) {     echo '<th>'.$row->label.'</th></tr>';     $i = 1;     $final = [];     foreach($row->value $v){         $temp = [];         $temp[$v->firstname.' '.$v->lastname] = [];         $output = findkey($final, $v->firstname.' '.$v->lastname);         if($output){             $temp[$v->firstname.' '.$v->lastname]['count'] = $v->count ;             $temp[$v->firstname.' '.$v->lastname][$row->label.'_'.$row->color] =  $v->count ;         }         array_push($final,$temp);     } } print_r($rows); //die;

the print_r output have provided not consistent -- has been manipulated add label keys. print_r have output them [label], not "label", also, print_r not have output comma @ end of same line.

so, risk solution not work, because have not provided correct array, provide here solution based on following array:

$finalarr =  array(     array(         'label' => 'red',         'value' => array (                 array ("count" => 47, "firstname" => 'syst'),                 array ("count" => 2, "firstname" => 'xyz'),                 array ("count" => 8, "firstname" => 'abc')         )     ),     array(         'label' => 'yellow',         "value" => array (                 array ("count" => 4, "firstname" => 'dim'),                 array ("count" => 2, "firstname" => 'abc'),                 array ("count" => 8, "firstname" => 'xyz')         )     ) );

then solution this:

// collect unique list of "firstname" values $rowheaders = array(); foreach($finalarr $column) {     $rowheaders = array_merge($rowheaders, array_column($column["value"], "firstname")); } $rowheaders = array_unique($rowheaders); usort($rowheaders, 'strcasecmp');  // column headers $colheaders = array_column($finalarr, "label");  // create matrix: first column $matrix = array(array_merge(array("name"), $colheaders)); foreach($rowheaders $firstname) {     $matrix[] = array($firstname); } // ... , colour columns: foreach($finalarr $colindex => $column) {     $names = array_column($column["value"], "firstname");     foreach ($rowheaders $rowindex => $name) {         $matrix[$rowindex+1][] = in_array($name, $names) ? $column["value"][array_search($name, $names)]["count"] : 0;     } }  // convert matrix html table $html = ""; $td = "th"; foreach ($matrix $row) {     $html .= "<tr><$td>" . implode("</$td><$td>", $row) . "</$td></tr>\n";      $td = "td"; } $html = "<table border=1>\n$html</table>";  // output html: echo $html;

the output is:

<table border=1> <tr><th>name</th><th>red</th><th>yellow</th></tr> <tr><td>abc</td><td>8</td><td>2</td></tr> <tr><td>dim</td><td>0</td><td>4</td></tr> <tr><td>syst</td><td>47</td><td>0</td></tr> <tr><td>xyz</td><td>2</td><td>8</td></tr> </table>

which in browser renders as:

table output


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more

Python Pig Latin Translator -

-
so have been working on @ codecademy.com while trying learn python. don't know if blind , can't see why won't work or what. here's code won't let me use. function print variable if had typed in , print "empty" if didn't type anything. print "welcome english pig latin translator!" original = raw_input("what's name?") if len(original) > 0 print original else print "empty" if len(original) > 0 else the above lines contains syntax errors. try: if len(original) > 0: else: note added colons, ( : ).
Read more