我正在嘗試使用輸入和提交按鈕在不同的 php 頁面中輸出搜索結果。它確實有效，但一次只顯示一個結果，因為所有結果只有一個占位符，有沒有辦法輸出多個相關結果并為每個結果提供自己的占位符？例如，我在數據庫中有三個名稱，如下所示，搜索win10應該會產生兩個結果，但它只輸出第一個。win7-haystackwin10-icelandwin10-road繼承人搜索php：<?php$arr = [];$searchq = "%{$_POST['search-input']}%";$stmt = $pdo->prepare("SELECT wallname FROM walldb WHERE wallname LIKE ?");$stmt->execute([$searchq]);while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $arr[] = $row;}foreach($arr as $value){ $val = implode('', $value); //echo ($val); //echo("<br><br>"); }$stmt = $pdo->prepare('SELECT * FROM walldb WHERE wallname = :val');$stmt->bindParam(':val', $val);$stmt->execute();while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $mlink = $row['mainlink']; $tlink = $row['thumbnail']; $dlink = $row['download']; $info = $row['info']; } /*echo ($mlink); echo("<br>"); echo ($tlink); echo("<br>"); echo ($dlink); echo("<br>"); echo ($info); */ $final = ("<li><a href="."$mlink"."data-lightbox='wallpaper1'><img class='searchicon' src="."$tlink"."></a><span>"."$val"."</span><img class='searchbutton1 s1' src='/images/info.png'><a id='wall1.download' href="."$dlink"."><img class='searchbutton2' src='/images/download.png'></a><ul class='searchmenu menu1'> <p>"."$info"."</p></ul></li>");?>繼承人的結果php： <form action= "" method= "post"> <a href="#"><img id="glass" src="/images/search.png" type= "submit" name="submit-search"></a><input id="search" name="search-input" type="search" placeholder="Search By Name" autocomplete="off"><a href="#"><img id="cancle" src="/images/cancle.png"></a> </form> <section id="result"><?php echo $final; ?></section>
1 回答
慕虎7371278
TA貢獻1802條經驗 獲得超4個贊
您將經歷兩次應該是相同的查詢結果集，并且兩次都丟棄了除上次迭代中的值之外的所有內容。嘗試這樣的事情：
$arr = [];
$searchq = "%{$_POST['search-input']}%";
$stmt = $pdo->prepare('SELECT * FROM walldb WHERE wallname LIKE ?');
$stmt->execute([$searchq]);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$mlink = $row['mainlink'];
$tlink = $row['thumbnail'];
$dlink = $row['download'];
$info = $row['info'];
// Generate the desired per-row output, saving it in an array for later use.
// Not clear what that should be, so this is a guess. Modify as needed.
$arr[] = '<li>' . $mlink . '<br>' . $tlink . '<br>' . $dlink . '<br>' . $info . '</li>';
}
$final = '<ul>' . implode('', $arr) . '</ul>';
- 1 回答
- 0 關注
- 137 瀏覽
添加回答
舉報
0/150
提交
取消