data_php

<?php
$server="localhost";
$user="root";
$pass="";
$db="rs2";

mysql_connect($server,$user,$pass) or die ("koneksi gagal");
mysql_select_db($db)or die ("DB tidak ditemukan");

?>
<table border="1">
<tr>
<th>ID</th>
<th>NAMA</th>
<th>JUMLAH</th>
</tr>

<?php
$q1 = mysql_query("SELECT * FROM data");
        while ($row= mysql_fetch_array($q1)){
            ?>
            <tr>
            <td><?php echo $row['id']?></td>
            <td><?php echo $row['nama']?></td>
            <td><?php echo $row['jumlah']?></td>
            </tr>
        <?php
        $jml[$row['id']] =$row['jumlah'] ;

        }
        ?>
</table>
<h2>data yang memiliki jumlah terbesar</h2>
<table border="1">
<tr>
<th>ID</th>
<th>NAMA</th>
<th>JUMLAH</th>
</tr>
        <?php
        $jml1 = json_encode($jml);
        $jml1 = json_decode($jml1,true);
        //echo "iki LOHHHHH = $jml1 </br>";
        $mx = max($jml1);

        $hasil=array_search($mx,$jml1);
        $q2 = mysql_query("SELECT * FROM data where id='$hasil'");
        while($row2= mysql_fetch_array($q2)){
            ?>
        <tr>
            <td><?php echo $row2['id']?></td>
            <td><?php echo $row2['nama']?></td>
            <td><?php echo $row2['jumlah']?></td>
            </tr>
            <?php
        }
?>
</table>