1 回答

TA貢獻(xiàn)1788條經(jīng)驗(yàn) 獲得超4個(gè)贊
您不應(yīng)在 while 循環(huán)之外聲明結(jié)果獲取數(shù)組。刪除它$rowmitra = mysqli_fetch_array($mitra);并嘗試使用 mysqli_fetch_assoc 來(lái)獲取數(shù)據(jù)庫(kù)列名。
<?php
$mitra = $koneksi->query("SELECT * FROM `mitra`");
$i = 1;
//I think the problem starts here
if (mysqli_num_rows($mitra) > 0) {
while ($rowmitra = mysqli_fetch_assoc($mitra)) {
echo '<tr>';
echo "<th scope='row'>".$i."</th>";
echo "<td>".$rowmitra['id_mitra']."</td>";
echo "<td>".$i."</td>";
echo "<td>".$rowmitra['mitra']."</td>";
echo '<td><img width="200px" class="shadow-sm" src="image/logo/'.$rowmitra["logo"].'"></td>';
echo '<td><a href="edit-mitra.php?id='.$rowmitra["id_mitra"].'"><button>EDIT</button></a></td>';
echo "</tr>";
$i = $i + 1;
}
}
?>
- 1 回答
- 0 關(guān)注
- 148 瀏覽
添加回答
舉報(bào)