在帖子下方點擊了一個贊按鈕。如果點擊它會變成橙色,否則它是綠色的。我無法切換顏色。如何使用 AJAX 請求從 MySQL 數(shù)據(jù)庫中查詢數(shù)據(jù)?我嘗試使用 jQuery 來使用 toggle 屬性修改 css 文件。我還嘗試查詢數(shù)據(jù)庫以查看用戶是否喜歡該帖子并將該結果設置為要在 AJAX 函數(shù)(數(shù)據(jù))中使用的變量。注意。為簡化演示而刪除了防止黑客攻擊的代碼。索引 php 文件: <?php $userid = session_id(); $query = "SELECT * FROM posts"; $result = mysqli_query($con,$query); while($row = mysqli_fetch_array($result)){ $postid = $row['id']; $title = $row['title']; $content = $row['content']; // Checking user status $status_query = "SELECT count(*) as type FROM likes WHERE userid='".$userid. "'" . "and postid=".$postid; $status_result = mysqli_query($con,$status_query); $status_row = mysqli_fetch_array($status_result); $type = $status_row['type']; // Count post total likes and unlikes $like_query = "SELECT COUNT(*) AS cntLikes FROM likes WHERE postid=".$postid; $like_result = mysqli_query($con,$like_query); $like_row = mysqli_fetch_array($like_result); $total_likes = $like_row['cntLikes']; ?> <div class="post"> <h1><?php echo $title; ?></h1> <div class="post-text"> <?php echo $content; ?> </div> <div class="post-action"> <input type="button" value="Like" id="like_<?php echo $postid . "_" . $userid; ?>" class="like" style="<?php if($type == 1){ echo "color: #ffa449;"; } ?>" /> (<span id="likes_<?php echo $postid . "_" . $userid; ?>"><?php echo $total_likes; ?></span>) </div> </div> <?php } ?> </div></body>阿賈克斯 jQuery:$(".like").click(function(){ var id = this.id; // Getting Button id var split_id = id.split("_"); var postid = split_id[1]; var userid = split_id[2]; } });});
1 回答

江戶川亂折騰
TA貢獻1851條經(jīng)驗 獲得超5個贊
修改了 jQuery 文件如下。jQuery 之前沒有點擊正確的標簽。我也在使用 Safari,需要清除緩存以查看對頁面的修改。哎呀。新手。
$("#like_" + postid + "_" + userid).text(likes);
if(type == 1){
$("#likes_" + postid + "_" + userid).css("color","#ffa449");
}
if(type == 0){
$("#likes_" + postid + "_" + userid).css("color","lightseagreen");
}
到:
$("#likes_" + postid + "_" + userid).text(likes);
if(type == 1){
$("#like_" + postid + "_" + userid).css("color","lightseagreen");
}
if(type == 0){
$("#like_" + postid + "_" + userid).css("color","#ffa449");
}
- 1 回答
- 0 關注
- 248 瀏覽
添加回答
舉報
0/150
提交
取消