Advertisement
maskee

selisih date

May 16th, 2017
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.14 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "absensi";
  6.  
  7. $conn = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error());
  8.  
  9. $sql = "select * from absen where nama = '42'";
  10. $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees1");
  11. $totalData = mysqli_num_rows($query);
  12. $totalFiltered = $totalData;
  13. echo $totalFiltered;
  14.  
  15. $i = 0;
  16. $tottime = 0;
  17. while (($row=mysqli_fetch_array($query)) && ($i <= $totalFiltered) ) {
  18.     $nama = $row['nama'];
  19.     $tipe = $row['tipe'];
  20.     $jam[] = $row['jam'];
  21.     if ($tipe[$i] == "I") {
  22.         echo next($jam)."<br>";//menggunakan logika ini saya mendapatkan semua jam setelah curent jam, bukan 1 data setelah curent data.
  23.  
  24.  
  25.         //bila meneruskan logika ini bagaimana mendapatkan data row berikutnya(satu data selanjutnya) dari curent row?
  26.  
  27.         //noted : saya pernah baca di stackoverflow jika php versi 5... kebawah menggunakan logika ini maka akan mendapat 1 row berikutnya, tapi bila php versi 5 keatas logika ini akan menampilkan semua data dari current row.
  28.  
  29.         continue;  
  30.     }
  31.    
  32.        
  33. }
  34. //var_dump($nama);
  35.  
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement