我是 PHP 新手，所以這可能是我錯(cuò)過(guò)的明顯事情。我試圖制作一個(gè)按鈕來(lái)增加數(shù)據(jù)庫(kù)中的值：<?php $alist = mysqli_query($conn, "SELECT * FROM `posts` ORDER BY `posts`.`id` DESC"); $results = mysqli_num_rows($alist); if ($results > 0){ while($row = mysqli_fetch_array($alist)) { echo $row['uid']. " says: ".$row['postText']." <button onclick=".mysqli_query($conn, "UPDATE `posts` SET `postLikes` = postLikes+1 WHERE uid = ".$row['uid'])." name='likebtn'>??</button>".$row['postLikes']."<br>"; } } ?>制作按鈕的部分位于第 6 行，我只是想找到如何使用按鈕 mysqli_query單擊， 我已經(jīng)嘗試過(guò)：“https://stackoverflow.com/questions/3862462/php-mysql-run -query-on-button-press-click”但沒(méi)有結(jié)果提前致謝
2 回答
ABOUTYOU
TA貢獻(xiàn)1812條經(jīng)驗(yàn) 獲得超5個(gè)贊
如果您當(dāng)前的頁(yè)面名為first.php，請(qǐng)放入按鈕內(nèi)
<button><a href="first.php?p=like"></a></button>
<?php
if ( isset($_GET['p']) && $_GET['p']=="like") {
do your query
}
?>
如果你不想重新加載那么你需要ajax，
慕妹3242003
TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超6個(gè)贊
你這里有語(yǔ)法錯(cuò)誤 echo $row['uid']. " says: ".$row['postText']." <button onclick=".mysqli_query($conn, "UPDATE posts SET postLikes = postLikes+1 WHERE uid = ".$row['uid'])." name='likebtn'>??</button>".$row['postLikes']."<br>";
你可以這樣做
$q = mysqli_query($conn, "UPDATE posts SET postLikes = postLikes+1 WHERE uid = ".$row['uid']);
echo $row['uid']. " says: ".$row['postText']." <button onclick=".$q." name='likebtn'>??</button>".$row['postLikes']."<br>";
- 2 回答
- 0 關(guān)注
- 181 瀏覽
添加回答
舉報(bào)
0/150
提交
取消