我正在嘗試獲取某個(gè)地區(qū)的項(xiàng)目列表。我想要區(qū)域名稱作為標(biāo)題然后該區(qū)域中的所有項(xiàng)目都在下表中，即標(biāo)題 - Region1表 - Region1 項(xiàng)目標(biāo)題 - Region2表 - Region2 項(xiàng)目標(biāo)題 - Region3表 - Region3 項(xiàng)目標(biāo)題 - Region4表 - Region4 項(xiàng)目我可以輸出：標(biāo)題標(biāo)題標(biāo)題如果我使用 LIKE 'Actual Region Name'，我可以在表中輸出區(qū)域詳細(xì)信息我想使用 LIKE $region 輸出，所以我不需要為每個(gè)“實(shí)際區(qū)域名稱”編寫新語句。2 SELECT 查詢：$region = mysqli_query($conn,"SELECT DISTINCT region FROM country") or die($conn->error);$result = mysqli_query($conn,"SELECT * FROM country WHERE region LIKE '$region'") or die($conn->error);輸出 1這將每個(gè)區(qū)域輸出為地區(qū)名稱$i = 0;while($row = $region->fetch_assoc()){ if ($i == 0) { foreach ($row as $value) { echo "<p>" . $value . "</p>"; } }}輸出 2這將輸出所有區(qū)域數(shù)據(jù)并將其放入表格中。echo "This is table Build";echo "<table border='1'>";$i = 0;while($row = $result->fetch_assoc()){ if ($i == 0) { $i++; echo "<tr>"; foreach ($row as $key => $value) { echo "<th>" . $key . "</th>"; } echo "</tr>"; } echo "<tr>"; foreach ($row as $value) { echo "<td>" . $value . "</td>"; } echo "</tr>";}echo "</table>";mysqli_close($conn);?>OUTPUT 1 和 OUTPUT 2 分別工作。我不能讓他們一起工作
1 回答
慕森王
TA貢獻(xiàn)1777條經(jīng)驗(yàn) 獲得超3個(gè)贊
您可以region從查詢中獲取所有名稱，然后將其傳遞給您next query并打印record與該查詢相關(guān)的所有名稱，即：
<?php
$region = mysqli_query($conn,"SELECT DISTINCT region FROM country") or die($conn->error);
if($region->num_rows > 0)
{ {
while($row = $region->fetch_assoc())
{
//printing region name
echo "<p>" . $row['region'] . "</p>";
//only those row will be retrieve which belong to current region name
$result = mysqli_query($conn,"SELECT * FROM country WHERE region LIKE '$row['region']'") or die($conn->error);
//printing table
echo "This is table Build";
echo "<table border='1'>";
$i = 0;
while($row1 = $result->fetch_assoc())
{
if ($i == 0) {
$i++;
echo "<tr>";
foreach ($row1 as $key => $value) {
echo "<th>" . $key . "</th>";
}
echo "</tr>";
}
echo "<tr>";
foreach ($row1 as $value) {
echo "<td>" . $value . "</td>";
}
echo "</tr>";
}
echo "</table>";
}
}
mysqli_close($conn);
?>
- 1 回答
- 0 關(guān)注
- 138 瀏覽
添加回答
舉報(bào)
0/150
提交
取消