我正在做產品過濾器應用程序，但出現(xiàn)此錯誤致命錯誤：未捕獲錯誤：調用未定義的方法 mysqli_stmt::fetchAll()這是我的代碼： <div class="list-group"> <h3>Grupe</h3> <div style="height: 180px; overflow-y: auto; overflow-x: hidden;"> <?php include_once("dbconfig.php"); $query = "SELECT DISTINCT(grupa) FROM slike ORDER BY podgrupa DESC"; $statement = $mysqli->prepare($query); $statement->execute(); $result = $statement->fetchAll(); foreach($result as $row) { ?> <div class="list-group-item checkbox"> <label><input type="checkbox" class="common_selector brand" value="<?php echo $row['grupa']; ?>" > <?php echo $row['grupa']; ?></label> </div> <?php } ?><!DOCTYPE html><html><head> <title></title></head><body> <?php$host="localhost";$port=3306;$socket="";$user="root";$password="";$dbname="slikezasajt";$mysqli = new mysqli($host, $user, $password, $dbname, $port, $socket) or die ('Could not connect to the database server' . mysqli_connect_error());//$mysqli->close();?></body></html>上面是我的 dbconfig 文件。
2 回答
Smart貓小萌
TA貢獻1911條經驗 獲得超7個贊
使用以下代碼更新您的代碼：
<div class="list-group">
<h3>Grupe</h3>
<div style="height: 180px; overflow-y: auto; overflow-x: hidden;">
<?php
include_once("dbconfig.php");
$query = "SELECT DISTINCT(grupa) FROM slike ORDER BY podgrupa DESC";
$statement = $mysqli->prepare($query);
$statement->execute();
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach($result as $rows =>$row)
{
?>
<div class="list-group-item checkbox">
<label><input type="checkbox" class="common_selector brand" value="<?php echo $row['grupa']; ?>" > <?php echo $row['grupa']; ?></label>
</div>
<?php
}
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<?php
$host="localhost";
$port=3306;
$socket="";
$user="root";
$password="";
$dbname="slikezasajt";
$mysqli = new mysqli($host, $user, $password, $dbname, $port, $socket)
or die ('Could not connect to the database server' . mysqli_connect_error());
//$mysqli->close();
?>
</body>
</html>
開滿天機
TA貢獻1786條經驗 獲得超13個贊
試試這個代碼。我已經測試過了，它在我的本地筆記本電腦上工作。
<?php
$host="localhost";
$port=3306;
$socket="";
$user="root";
$password="";
$dbname="slikezasajt";
$mysqli = new mysqli($host, $user, $password, $dbname, $port, $socket)
or die ('Could not connect to the database server' . mysqli_connect_error());
$query = "SELECT DISTINCT(grupa) FROM slike ORDER BY podgrupa DESC";
$statement = $mysqli->query($query);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<div class="list-group">
<h3>Grupe</h3>
<div style="height: 180px; overflow-y: auto; overflow-x: hidden;">
<?php
while($row = $statement->fetch_assoc())
{
?>
<div class="list-group-item checkbox">
<label><input type="checkbox" class="common_selector brand" value="<?php echo $row['grupa']; ?>" > <?php echo $row['grupa']; ?></label>
</div>
<?php
}
?>
</body>
</html>
- 2 回答
- 0 關注
- 175 瀏覽
添加回答
舉報
0/150
提交
取消