Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- print('Analisa');
- require("../config/connection.php");
- $sql="SELECT COUNT(tabggal) as jlh, tanggal from gempa group by mounth(tanggal)";
- print('Get All Data Row');
- $res = mysqli_query($sql) or die('Sql Sintaks Error...');
- $info = array();
- $i=0;
- printf("%10s %10s", "Tanggal", "Count");
- while($row=mysql_fetch_object($result)){
- $count = $row->jlh;
- $tanggal = $row->tanggal;
- $a = substr($tanggal, 5, 2);
- printf("%10s %10s<br>", $a, $count);
- $info_data = array();
- // Jika ingin mengambil substr dari tanggal 5,2
- $info_data[0] = $a;
- // Jika ingin mengambil tanggalnya saja
- // Hilangkan komentar di bawah
- // $info_data[0] = $tanggal;
- $info_data[0] = $count;
- print("cek info_data");
- print_r($info_data);
- print("<hr noshade style=\"border:1px solid red\"><br>");
- $info[$i] = $info_data;
- }
- print_r($info);
- ?>
Add Comment
Please, Sign In to add comment