Postingan lainnya
ini kenapa gan,
1.mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\phpbayar\laporan.php on line 30
2.Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\phpbayar\laporan.php on line 54
$q =mysqli_query($con, "SELECT * from kelas,sum(jumlah) FROM pembayaran WHERE tgl_bayar BETWEEN '$tgl1' AND '$tgl2' GROUP BY kelas");
echo '
Rekap Pembayaran '.$tgl1.' sampai '.$tgl2.'
'; echo ' Cetak';
} else { $tgl = date("Y/m/d"); $q =mysqli_query($con, "SELECT * from kelas,sum(jumlah) FROM pembayaran WHERE tgl_bayar='$tgl' GROUP BY kelas"); echo '
Rekap Pembayaran '.$tgl.'
'; }
$sql = mysqli_query($q);
echo '
'; echo '
'; ?>
Mulai
Hingga
Tampilkan
'; echo '#KelasJumlah';
$total = 0; $no=1; while(list($kls,$jml) = mysqli_fetch_array($sql)){ echo ''.$no.''.$kls.''.$jml.''; $total += $jml; $no++; }
3 Jawaban:
Bro. Tolong masukkan ke tag [Code] biar gampang bacanya.
<pre> $q =mysqli_query($con, "SELECT * from kelas,sum(jumlah) FROM pembayaran WHERE tgl_bayar='$tgl' GROUP BY kelas"); $sql = mysqli_query($q); </pre>
Kenapa mysqli_query anda masukkan ke dalam mysqli_query lagi
<pre> while(list($kls,$jml) = mysqli_fetch_array($sql)){ </pre>
mysqli_fetch_array membutuhkan 2 parameter
<pre> mysqli_fetch_array(param1, param2) </pre>
<a href='https://www.w3schools.com/php/func_mysqli_fetch_array.asp '>https://www.w3schools.com/php/func_mysqli_fetch_array.asp </a>
Jawaban Terpilih
kenapa querynya di panggil 2 kali?
<pre> $q =mysqli_query($con, "SELECT * from kelas,sum(jumlah) FROM pembayaran WHERE tgl_bayar BETWEEN '$tgl1' AND '$tgl2' GROUP BY kelas"); </pre>
<pre> $sql = mysqli_query($q); </pre>
kalau mau gini aja.
<pre> $sql = $q; </pre>
Oke suhu. Makasih., sangat mebantu Terima Kasih