I need to make a moderate system like the one in fmylife.com. Basically the problem I have is loading the MySQL query using Ajax (without page refreshing) in to a div. MySQL query
$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>
this data should be reloaded when pressing "yes" or "no" buttons. thanks in advance.
@mgraph is close but if you want to do this on a button click
in 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>
Alternate 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>
mysqli_ functions instead of mysql_ they're better maintained and allow "Parameterised Queries" which are important to prevent SQL Injection attacksin post.php:
$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(){
$("#yes").click(function(){
$(".post-body").eq(0).load("post.php");
})
})
</script>
HTML:
<div id="yes">YES</div>
<div class="post-body"></div>
