Postingan lainnya
Fatal error: Uncaught TypeError: mysqli_fetch_array()
Masalah:
Fatal error: Uncaught TypeError: mysqli_fetch_array(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp3\htdocs\absensi2\petugas_piket\tablehadir.php:55 Stack trace: #0 C:\xampp3\htdocs\absensi2\petugas_piket\tablehadir.php(55): mysqli_fetch_array(false) #1 {main} thrown in C:\xampp3\htdocs\absensi2\petugas_piket\tablehadir.php on line 55
Code:
$no=1; while ($data=mysqli_fetch_array($query_tampil)) {
Full Code:
<?php
include '../db/koneksi.php';
include 'akses.php';
include '../layout/header.php';
//deklarasi variable absen
//pencarian data
if(isset($_GET['carinama'])){
$cari_nama_guru=$_GET['carinama'];
$cari_bulan_guru=$_GET['bulan'];
$query_tampil=mysqli_query($konek,"select * from kehadiran_guru where nama like '%$cari_nama_guru%' ORDER BY nama");
}else {
// query tampil
$query_tampil=mysqli_query($konek,"SELECT * FROM kehadiran_guru ORDER BY nama ASC");
}
//end pencarian data
?>
<div id="content">
<div id="content-header">
<div id="breadcrumb"> <a href="http://localhost/absensi2/<?php echo $_SESSION['akses']; ?>/" title="Go to Home" class="tip-bottom"><i class="icon-home"></i> Home</a>
<a href="http://localhost/absensi2/petugas_piket/Hadir" class="tip-bottom">Kehadiran Guru</a> </div>
<h1>Kehadiran Guru</h1>
</div>
<div class="container-fluid">
<hr>
<div class="row-fluid">
<div class="span12">
<div class="widget-box">
<div class="widget-title"> <span class="icon"><i class="icon-th"></i></span>
<h5>Data table</h5>
</div>
<div class="widget-content nopadding">
<table class="table table-bordered data-table">
<thead>
<tr>
<th>no</th>
<th>NIP</th>
<th>nama</th>
<th>tanggal</th>
<th>jam datang</th>
<th>Hapus</th>
</tr>
</thead>
<tbody>
<?php
$query_tampil=mysqli_query($konek,"select * from kehadiran_guru ORDER BY nama");
$no=1; while ($data=mysqli_fetch_array($query_tampil)) {
$nip=strtoupper($data['nip']);
?>
<tr class="gradeX">
<td><?php echo $no; ?></td>
<td><?php echo $data['nip']; ?></td>
<td><?php echo $data['nama']; ?></td>
<td><?php echo $data['tanggal']; ?></td>
<td><?php echo $data['jam']; ?></td>
<td><a href="http://localhost/absensi2/petugas_piket/hadir/hapus/<?PHP echo $data['id']?>"class="btn btn-danger">Hapus</a></td>
</tr>
<?php $no++; } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
<?php include '../layout/footer.php'; ?>
Mohon Bantu Untuk Masalah Ini
1 Jawaban:
<div>Halo, bantu jawab ya,<br>Coba dicek lagi penulisan nama tabel atau kolomnya, pastikan penulisannya sudah sesuai.<br>Ohh iya, saran saya ketika menggunakan fungsi mysqli_query , gunakan juga mysqli_error untuk mengetahui jika kita melakukan kesalahan penulisan pada query.<br>Contohnya seperti ini :</div><pre>$query_tampil=mysqli_query($konek,"SELECT * FROM kehadiran_guru ORDER BY nama") or die(mysqli_error($konek));</pre><div><br>Silahkan pelajari di halaman dokumentasi resminya berikut <a href="https://www.php.net/manual/en/mysqli.error.php">https://www.php.net/manual/en/mysqli.error.php</a><br>Semoga terbantu.</div>