Postingan lainnya

error mysqli_fetch_array() expects parameter 1 to be mysqli_resul

 <?php
session_start();
   require_once("koneksi.php");

if(@$_SESSION['admin'] || @$_SESSION['petugas']) {
?>

<html>
<head>

	<title>DreCinema</title>
		<link href="css/datapegawai.css" rel="stylesheet" type="text/css" media="screen">
</head>
<body>
<header>


    <nav class="navbar">
		<div class="container">
		<span class="toggle"></span>
		<a href="" class="logo">
			<img src="../home_op/pict/pilihan2.png" alt="Logo" class="img">


            <span>Penghasilan</span>
			<span>Admin</span>
			<span>DreCinema</span>
		</a>
			<ul class="menu">
				<li><a href="menu.php"><i class=""></i>  Home</a></li>
				<li><a href="tambah_data.php"><i class=""></i>  Tambah Data</a></li>
				<li><a href="datapegawai.php"><i class=""></i>  Data Petugas</a></li>
                <li><a href="penghasilan.php"><i class=""></i>  Penghasilan</a></li>

                <li><a href="logout.php"><i class=""></i>  Sign Out</a></li>

			</ul>
		</div>
	</nav>
</header>


<?php
include("koneksi.php");
?>
<center>

<h2 class="judul">Penghasilan Penjualan</h2>
<br><br>
<table class="posisi">
  <tr>
    <th>Judul Film</th>
    <th>Tanggal</th>
    <th>Kursi</th>
    <th>Uang</th>
      <th>Total</th>
  </tr>

<?php

$hasil=mysqli_query ($koneksi,"Select * From tb_pesan");

while ($data = mysqli_fetch_array ($hasil,MYSQLI_ASSOC)){
$id = $data['id'];

?>

        <tr>
        <td><?php echo $data['judul'];?></td>
        <td><?php echo $data['jam'];?></td>
        <td><?php echo $data['kursi'];?></td>
        <td><?php echo $data['harga'];?></td>
        </tr>

<?php
}
?>

    <tr>
    <td colspan="2" align="right">Jumlah</td>
    <td><?php

$jumlah = "SELECT SUM(nominal) AS harga FROM tb_pesan";
$hasil =mysqli_query($koneksi,$jumlah);
$t = mysqli_fetch_array($hasil);
echo "<b>" . number_format($t['harga']) . " </b>";
    ?>
        </td>

    </tr>

    </table>
</center>
</body>
</html>

    <?php
} else {
    header("location: ../loginpeg.php");
}
    ?>

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\tiketbioskop\home\penghasilan.php on line 85 0

php

@andre27

15 Kontribusi 0 Poin

Diperbarui 6 tahun yang lalu

3 Jawaban:

 while ($data = mysqli_fetch_array ($hasil)){

@Nandar

648 Kontribusi 204 Poin

Dipost 6 tahun yang lalu

Try this one, change the

 $t = mysqli_fetch_array($hasil);

to :

 while($t = mysqli_fetch_array($hasil)){
echo "<b>" . number_format($t['harga']) . " </b>";
}

@masiting

55 Kontribusi 18 Poin

Dipost 6 tahun yang lalu

Masalahnya Query nya Salah , fieldnya kan harga

  <td><?php echo $data['harga'];?></td>


$jumlah = "SELECT SUM(nominal) AS harga FROM tb_pesan";
echo "<b>" . number_format($t['harga']) . " </b>";

Ubah

$jumlah = "SELECT SUM(harga) AS nominal FROM tb_pesan";
echo "<b>" . number_format($t['nominal']) . " </b>";

Semoga Membantu.. (^_^)

@ciloxz

284 Kontribusi 139 Poin

Dipost 6 tahun yang lalu