我需要建立一个像fmylife.com中那样的适度系统。基本上,我遇到的问题是使用Ajax(无需刷新页面)将MySQL查询加载到div中。MySQL查询
$sql = mysql_query(“SELECT * FROM posts WHERE active =’0’” LIMIT 1) or die (mysql_error()); $row = mysql_fetch_array($sql);
的HTML
<div class=”post-body”><?php echo $row[‘sitepost’];?></div>
当按“是”或“否”按钮时,应重新加载该数据。提前致谢。
@mgraph已关闭,但如果要在按钮上执行此操作,请单击
在 post.php中 :
//$UserOption will be Yes/No for button clicks or empty string for first load of the page $UserOption = $_REQUEST['UserClicked']; //Id will be set if a vote has been clicked or empty string if it's the first load $Id = $_REQUEST['Id']; //(Do something with $UserOption) $sql = mysql_query("SELECT * FROM posts WHERE active ='0' LIMIT 1") or die (mysql_error()); $row = mysql_fetch_array($sql); echo $row['sitepost'];
JS :
<script type="text/javascript"> $(document).ready(function(){ update(null,null); }) function update(Id, Vote) { $(".post-body").eq(0).load("post.php?UserClicked=" + Vote + "&Id=" + Id); } </script>
HTML :
<div class="post-body"></div> <button type="button" onclick="update(1, 'Yes');">Yes</button> <button type="button" onclick="update(1, 'No');">No</button> <button type="button" onclick="update(2, 'Yes');">Yes</button> <button type="button" onclick="update(2, 'No');">No</button>
备用HTML / JS
<script type="text/javascript"> $(document).ready(function(){ $("#yes").click(function(){ update('Yes'); }) $("#no").click(function(){ update('No'); }) update(); }) function update(Vote) { $(".post-body").eq(0).load("post.php?UserClicked=" + Vote); } </script> <div class="post-body"></div> <button id="yes" type="button">Yes</button> <button id="no" type="button">No</button>