我该如何修复此警告：mysqli_fetch_array（）期望参数1为mysqli_result，给定布尔值 [英] How can I fix this warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

问题描述

请某人帮助我。我很紧急。我无法解决这个问题。





这是我的结果表格



<？php

session_start（）;

？>







< meta charset =utf-8>

< meta name =viewportcontent =width = device-width，initial-scale = 1>

切换导航









合作支付报告管理系统

• Halaman utama
  
  
• Daftar Koperasi
  
  
• Daftar Lembaga Pengarah
  
  
• Senarai Koperasi
  
  
• Senarai Lembaga Pengarah
  
  
• Senarai Kakitangan
  
  
• Laporan bayaran
  
  
• Keluar
  
  

< h3 class =panel-title> Laporan Bayaran

Nama Koperasi：





--Nama Koperasi--

<？php

//第一个cari无法连接ke数据库

include_once（./includes / dbconnection.php）;



$ sql =SELECT * FROM coop01;

$ result = mysqli_query（$ conn，$ sql）;



while（$ coop = mysqli_fetch_array（$ result））{

$ c_id = $ coop ['coopId'];

$ c_name = $ coop ['coopName'];



echo

。$ c_name。



;

}



？>

Jenis Carian：


< br>

--Sila Pilih--

Resit

Baucer

Invois Jualan

Invois Belian

Tarikh：

/ *样式搜索字段* /

form.example输入[type = text] {

padding：8px;

font-size：15px;

border：1px solid grey;

float：left;

宽度：80％;

背景：＃f1f1f1;

}



/ *样式提交按钮* /

form.example按钮{

float：left;

宽度：20％;

填充：10px;

背景：＃2196F3;

颜色：白色;

字体大小：17px;

border：1px solid grey;

border-left：none; / *防止双边框* /

光标：指针;

}



form.example按钮：悬停{

背景：＃0b7dda;

}



/ * Clear floats * /

form.example :: after {

content：;

clear：both;

display：table;

}



我尝试过：



这是我提交按钮搜索后的结果











< meta charset =utf-8>

< meta name =viewportcontent =width = device-width，initial-scale = 1> ;

切换导航









合作支付报告管理系统

<？php



session_start（）;



//第一cari fail untuk连接ke数据库

include_once（./includes/dbconnection.php）;



if（isset（$ _ POST [ 'submit']））{$ / $ $ $ $ $ n $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ ['jenis2']）;

$ tarikh = mysqli_real_escape_string（$ conn，$ _POST ['tarikh']）;



if（ $ jenis2 =='Resit'）{

？>















<？php

$ sql =SELECT *来自收据WHERE RecDate ='。$ tarikh。'AND cooperasiId ='。$ namakoperasi。';

$ result = mysqli_query（$ conn，$ sql）;



while（$ receipt = mysqli_fetch_array（$ result））{

$ resitdate = $ receipt ['RecDate'];

$ resitno = $ receipt ['RecNo'];

$ resitnama = $ receipt ['coopName'];

$ resitamaun = $ receipt ['Recamount'];

$ resitakaun = $收据['Recakaun'];



echo



;

}

？>

Akaun

Tarikh	No Resit	Nama Koperasi	Jumlah（RM）
$ resitdate。	。$ resitno。	。$ resitnama。	。$ resitamaun。	。$ resitakaun。

<？php

}否则{

if（$ jenis2 =='Baucer'）{

？>

















<？php

$ sql =SELECT * FROM baucer WHERE cooperasiId ='。$ namakoperasi 。'和BauDate ='。$ tarikh。';

$ result = mysqli_query（$ conn，$ sql）;



while（$ baucer = mysqli_fetch_array（$ result））{

$ baucerdate = $ baucer ['BauDate'];

$ baucerno = $ baucer ['BauNo' ];

$ baucernama = $ baucer ['coopName'];

$ baucerakaun = $ baucer ['BauAkaun'];

$ bauceramaun = $ baucer ['BauAmaun'];

$ baucernocek = $ baucer ['Baunocek'];



echo



;

}

？>

Nama Koperasi Jumlah（RM）

Tarikh	No Baucer		Nota / No cek
$ baucerdate。	。$ baucerno。	。$ baucernama。	$ baucerakaun。	。$ bauceramaun。	。$ baucernocek。

<？php

} else {

if（$ jenis2 =='InvoisJualan'）{

？>













<？php



$ sql =SELECT coop01.coopId，coop01.coopName，invoisjualan.i_j_No，invoisjualan.i_j_date，invoisjualan.i_j_jumlah ，

invoisjualan.i_j_nota，invoisjualan.coopId，invoisjualan.staffUsername



FROM invoisjualan

LEFT JOIN coop01 ON invoisjualan.coopId = coop01.coopId



WHERE i_j_date ='。$ tarikh。'和coopId ='。$ namakoperasi。'

;



$ result = mysqli_query（$ conn，$ sql）;



while（$ invoisjualan = mysqli_fetch_array（$ result））{

$ noinvj = $ invoisjualan ['noinvj'];

$ tarikhinvj = $ invoisjualan ['tarikhinvj'] ;

$ amauninvj = $ invoisjualan ['amauninvj'];

$ notainvj = $ invoisjualan ['notainvj'];

$ namakoperasi = $ invoisjualan ['namakoperasi'];



echo



;







}

？>

Tarikh	No Invois	Nama Koperasi	Jumlah（RM）< /次>	诺塔
$ noinvj。	。$ tarikhinvj。	$ amauninvj。	。$ notainvj。	。$ namakoperasi。

<？php

} else {

if（$ jenis2 =='InvoisBelian'）{

？>













<？php

$ sql =SELECT * FROM invoisbelian WHERE cooperasiId ='。$ namakoperasi。'和BauDate ='。$ tarikh 。';

$ result = mysqli_query（$ conn， $ sql）;



while（$ invoisbelian = mysqli_fetch_array（$ result））{

$ invbdate = $ invoisbelian ['invbdate'] ;

$ invbno = $ invoisbelian ['invbNo'];

$ invbnama = $ invoisbelian ['coopName'];

$ invbamaun = $ invoisbelian ['invbamaun'];

$ invbnote = $ invoisbelian ['invbnote'];



echo



;

}

？>

Tarikh	No Invois	Nama Koperasi	Jumlah（RM）
$ invbdate。	。$ invbno。	。$ invbnama。	。$ invbamaun。	。$ invbnote。

<？php



}

}

}

}



}



？>

解决方案

sql =SELECT * FROM coop01;

result = mysqli_query（

conn，

please someone help me . im in urgent situation. i cant solved this.


this is my result form

<?php
session_start();
?>



<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">

Toggle navigation




COOPERATIVE PAYMENT REPORT MANAGEMENT SYSTEM

• Halaman utama
  
• Daftar Koperasi
  
• Daftar Lembaga Pengarah
  
• Senarai Koperasi
  
• Senarai Lembaga Pengarah
  
• Senarai Kakitangan
  
• Laporan bayaran
  
• Keluar
  

Laporan Bayaran

Nama Koperasi :



--Nama Koperasi--
<?php
//First cari fail untuk connection ke database
include_once ("./includes/dbconnection.php");

$sql = "SELECT * FROM coop01";
$result = mysqli_query($conn, $sql);

while ($coop = mysqli_fetch_array($result)) {
$c_id = $coop['coopId'];
$c_name = $coop['coopName'];

echo "
".$c_name."

";
}

?>

Jenis Carian :



--Sila Pilih--
Resit
Baucer
Invois Jualan
Invois Belian

Tarikh:

/* Style the search field */
form.example input[type=text] {
padding: 8px;
font-size: 15px;
border: 1px solid grey;
float: left;
width: 80%;
background: #f1f1f1;
}

/* Style the submit button */
form.example button {
float: left;
width: 20%;
padding: 10px;
background: #2196F3;
color: white;
font-size: 17px;
border: 1px solid grey;
border-left: none; /* Prevent double borders */
cursor: pointer;
}

form.example button:hover {
background: #0b7dda;
}

/* Clear floats */
form.example::after {
content: "";
clear: both;
display: table;
}

What I have tried:

this i my outcome after submit button search





<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">

Toggle navigation




COOPERATIVE PAYMENT REPORT MANAGEMENT SYSTEM

<?php

session_start();

//First cari fail untuk connection ke database
include_once ("./includes/dbconnection.php");

if (isset($_POST['submit'])){
$namakoperasi = mysqli_real_escape_string($conn, $_POST['namakoperasi']);
$jenis2 = mysqli_real_escape_string($conn, $_POST['jenis2']);
$tarikh = mysqli_real_escape_string($conn, $_POST['tarikh']);

if ($jenis2 == 'Resit') {
?>







<?php
$sql = "SELECT * FROM receipt WHERE RecDate = '".$tarikh."' AND cooperasiId = '".$namakoperasi."' ";
$result = mysqli_query($conn, $sql);

while ($receipt = mysqli_fetch_array($result)) {
$resitdate = $receipt['RecDate'];
$resitno = $receipt['RecNo'];
$resitnama = $receipt['coopName'];
$resitamaun= $receipt['Recamount'];
$resitakaun= $receipt['Recakaun'];

echo "

";
}
?>

Tarikh	No Resit	Nama Koperasi	Jumlah (RM)	Akaun
".$resitdate."	".$resitno."	".$resitnama."	".$resitamaun."	".$resitakaun."

<?php
} else {
if ($jenis2 == 'Baucer') {
?>








<?php
$sql = "SELECT * FROM baucer WHERE cooperasiId = '".$namakoperasi."' and BauDate = '".$tarikh."'";
$result = mysqli_query($conn, $sql);

while ($baucer = mysqli_fetch_array($result)) {
$baucerdate = $baucer['BauDate'];
$baucerno = $baucer['BauNo'];
$baucernama = $baucer['coopName'];
$baucerakaun = $baucer['BauAkaun'];
$bauceramaun= $baucer['BauAmaun'];
$baucernocek= $baucer['Baunocek'];

echo "

";
}
?>

Tarikh	No Baucer	Nama Koperasi	Akaun	Jumlah (RM)	Nota/No cek
".$baucerdate."	".$baucerno."	".$baucernama."	".$baucerakaun."	".$bauceramaun."	".$baucernocek."

<?php
} else {
if ($jenis2 == 'InvoisJualan') {
?>






<?php

$sql = "SELECT coop01.coopId, coop01.coopName, invoisjualan.i_j_No, invoisjualan.i_j_date, invoisjualan.i_j_jumlah,
invoisjualan.i_j_nota, invoisjualan.coopId, invoisjualan.staffUsername

FROM invoisjualan
LEFT JOIN coop01 ON invoisjualan.coopId = coop01.coopId

WHERE i_j_date = '.$tarikh.' AND coopId = '.$namakoperasi.'
";

$result = mysqli_query($conn, $sql);

while ($invoisjualan = mysqli_fetch_array($result)) {
$noinvj = $invoisjualan['noinvj'];
$tarikhinvj = $invoisjualan['tarikhinvj'];
$amauninvj = $invoisjualan['amauninvj'];
$notainvj= $invoisjualan['notainvj'];
$namakoperasi = $invoisjualan['namakoperasi'];

echo "

";



}
?>

Tarikh	No Invois	Nama Koperasi	Jumlah (RM)	Nota
".$noinvj."	".$tarikhinvj."	".$amauninvj."	".$notainvj."	".$namakoperasi."

<?php
} else {
if ($jenis2 == 'InvoisBelian') {
?>






<?php
$sql = "SELECT * FROM invoisbelian WHERE cooperasiId = '".$namakoperasi."' and BauDate = '".$tarikh."' ";
$result = mysqli_query($conn, $sql);

while ($invoisbelian = mysqli_fetch_array($result)) {
$invbdate = $invoisbelian['invbdate'];
$invbno = $invoisbelian['invbNo'];
$invbnama = $invoisbelian['coopName'];
$invbamaun= $invoisbelian['invbamaun'];
$invbnote= $invoisbelian['invbnote'];

echo "

";
}
?>

Tarikh	No Invois	Nama Koperasi	Jumlah (RM)	Nota
".$invbdate."	".$invbno."	".$invbnama."	".$invbamaun."	".$invbnote."

<?php

}
}
}
}

}

?>

解决方案

sql = "SELECT * FROM coop01";

result = mysqli_query(

conn,

这篇关于我该如何修复此警告：mysqli_fetch_array（）期望参数1为mysqli_result，给定布尔值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！