javascript - 如果先前的记录相同，则隐藏表上的结果

Question

我有一个问题，比如如果前一个记录像这样循环，如何隐藏结果

$s="SELECT * from tabel";
$qs=mysqli_query($conn, $s);
echo "<table>";
while($rs=mysqli_fetch_assoc($qs)) {
$tgl=date("d.m.y",strtotime($rs['tgl']));
$kode=$rs['kode'];
$desc=$rs['desc'];
echo "<tr><td>$tgl</td><td>$kode</td><td>$desc</td></tr>";
}
echo "</table>";

例如，上一条记录的日期与下一条记录的日期相同，如果表格上打印的值看起来是双倍的，则仅在更改或不同时才打印记录。当日期更改然后打印时，下一条记录的日期相同(不打印)。另外，如果代码发生更改或与之前的记录不同，则仅打印代码

这张图片和代码可以说明我的观点谢谢

Before

After

结果:

<table>
<tr>
<td>DATE</td>
<td>KODE</td>
<td>DESC</td>
</tr>
<tr>
<td>2019-11-20</td>
<td>ISO123</td>
<td>Test</td>
</tr>
<tr>
<td></td>
<td></td>
<td>Row</td>
</tr>
<tr>
<td></td>
<td>DEF00</td>
<td>Column</td>
</tr>
<tr>
<td>2019-11-21</td>
<td>CCV09</td>
<td>Change</td>
</tr>
<tr>
<td></td>
<td></td>
<td>Value</td>
</tr>
<tr>
<td></td>
<td>TRI124</td>
<td>Hide</td>
</tr>
<tr>
<td></td>
<td></td>
<td>Duplicate</td>
</tr>
</table>

Answer 1

尝试以下代码:

$prev_tg1 = $prev_kode = '';  //Create Placeholders.

while($rs=mysqli_fetch_assoc($qs)) {
    $tgl = date("d.m.y",strtotime($rs['tgl']));
    $kode = $rs['kode'];
    $desc = $rs['desc'];

    if( $prev_tg1 == $tg1 ) {  //Check same as previous
        $tg1 = '';              //set it to empty if same
    } else {
        $prev_tg1 = $tg1;      //Update the Placeholder
    }

    if( $prev_kode  == $kode ) {
        $kode = '';
    } else {
        $prev_kode  = $kode;
    }   
    echo "<tr><td>$tgl</td><td>$kode</td><td>$desc</td></tr>";
}