Advertisement
arijulianto

merge-table.php

Nov 26th, 2018
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. <?php
  2. // db output
  3. $data = array(
  4.     array(
  5.         'no' =>1,
  6.         'jur' => 'maju',
  7.         'kel' => 'ada',
  8.     ),
  9.     array(
  10.         'no' =>1.1,
  11.         'jur' => 'maju',
  12.         'kel' => 'ada',
  13.     ),
  14.     array(
  15.         'no' =>2,
  16.         'jur' => 'maju',
  17.         'kel' => 'ada',
  18.     ),
  19.     array(
  20.         'no' =>3,
  21.         'jur' => 'mundur',
  22.         'kel' => 'ada',
  23.     ),
  24.     array(
  25.         'no' =>4,
  26.         'jur' => 'naik',
  27.         'kel' => 'ada',
  28.     ),
  29.     array(
  30.         'no' =>4.1,
  31.         'jur' => 'naik',
  32.         'kel' => 'ada',
  33.     ),
  34.     array(
  35.         'no' =>5,
  36.         'jur' => 'turun',
  37.         'kel' => 'ada',
  38.     ),
  39.     array(
  40.         'no' =>6,
  41.         'jur' => 'turun',
  42.         'kel' => 'ada',
  43.     ),
  44.     array(
  45.         'no' =>6.1,
  46.         'jur' => 'turun',
  47.         'kel' => 'ada',
  48.     ),
  49. );
  50. // array merge
  51. $mer = array();
  52. foreach($data as $i=>$m){
  53.     $i++;
  54.     $mer[$m['jur']][$i] = $m['jur'];
  55. }
  56.  
  57. //echo '<pre>';print_r($mer);echo'</pre>';
  58.  
  59. echo '<table border=1><tr><th>no</th><th>jur</th><th>kel</th></tr>',"\n";
  60. foreach($data as $row){
  61.     echo '<tr>',"\n";
  62.     echo '  <td>',$row['no'],'</td>',"\n";
  63.     if((!$jur || $row['jur']!=$jur)){
  64.         if(count($mer[$row['jur']])>1)
  65.             echo '  <td rowspan=',count($mer[$row['jur']]),'>',$row['jur'],'</td>',"\n";
  66.         else
  67.             echo '  <td>',$row['jur'],'</td>',"\n";
  68.     }
  69.     echo '  <td>',$row['kel'],'</td>',"\n";
  70.     echo '</tr>',"\n";
  71.     $jur = $row['jur'];
  72. }
  73. echo '</table>';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement