This is my first time using jQuery AJAX so bear with me. I am trying to create a like button for my website similar to the Facebook like button. A user must be logged on via Facebook which will pull their userid from my database. When a user clicks on the like button, it inserts a row into the database with the user info and the page info. If there is already an entry for the user and page, it will update the row.
My code runs perfectly fine on my localhost. I can click on the like button all day and the image will constantly change back and forth from like to unlike and back. The database updates every time as well with no problem.
When I upload this to my live server, the script runs perfectly fine as well to a point. Once my page finishes loading completely, the database no longer updates from the click. The images will change as usual and I will receive the alert('Success') but no changes are made to the actual database.
<?php
$tempstat = '1';
if ($stmt = $mysqli -> prepare("SELECT count(id)
FROM votes
WHERE businessid=? and status=? ")) {
$stmt -> bind_param('ss', $businessid, $tempstat);
$stmt -> execute();
$stmt->bind_result($likecount);
$stmt->fetch();
$stmt->close();
}
if ($likecount == '') { $likecount = 0; }
?>
<style>
#karmabar { padding-left: 4px; }
#counter { margin: 0 auto; text-align: center; width: 50px; height: 25px; background-image: url('/images/karma-counter.png'); }
p#counter { font-size: 12px; padding-top: 5px; }
.karma { margin: 0 auto; font-size: 16px; color: blue; text-align: center; padding: 5px; }
</style>
<?php
if(login_check($mysqli) == true) {
$userid = $_SESSION['userurl'];
if ($stmt = $mysqli -> prepare("SELECT status
FROM votes
WHERE userid=? and businessid=? ")) {
$stmt -> bind_param('ss', $userid, $businessid);
$stmt -> execute();
$stmt -> bind_result($like_status);
$stmt->fetch();
$stmt->close();
}
if ($like_status == '' or $like_status == NULL) { $like_status = '0'; }
?>
<script type="text/javascript">
$(document).ready(function() {
$('#like_post').click(function() {
$.ajax({
url: "/includes/like.php",
type: "GET",
data: 'userid=<?php echo $userid; ?>&businessid=<?php echo $businessid; ?>&like_status=1',
success: function() {
alert("Success");
},
error: function() {
alert("Something went wrong");
}
});
$('#counter').html(function(i, val) { return val*1+1 });
$('#like_post').hide();
$('#unlike_post').show();
});
$('#unlike_post').click(function() {
$.ajax({
url: "/includes/like.php",
type: "GET",
data: 'userid=<?php echo $userid; ?>&businessid=<?php echo $businessid; ?>&like_status=0',
success: function() {
alert("Success");
},
error: function() {
alert("Something went wrong");
}
});
$('#counter').html(function(i, val) { return val*1-1 });
$('#unlike_post').hide();
$('#like_post').show();
});
});
</script>
<div id="karmabar">
<table cellpadding="0px">
<?php if ($like_status == '0') { ?>
<tr><td><a href="javascript:;" id="unlike_post" class="hide"><img src="/images/karma-active.png" title="Undo Karma" /></a><a href="javascript:;" id="like_post"><img src="/images/karma-inactive.png" title="Spread Karma" /></a><td><p id="counter"><?php echo $likecount; ?></p></td></tr>
<?php } else { ?>
<tr><td><a href="javascript:;" id="unlike_post"><img src="/images/karma-active.png" title="Undo Karma" /></a><a href="javascript:;" id="like_post" class="hide"><img src="/images/karma-inactive.png" title="Spread Karma" /></a></td><td><p id="counter"><?php echo $likecount; ?></p></td></tr>
<?php } ?>
</table>
</div>
<?php } else { ?>
<div id="karmabar">
<table cellpadding="0px">
<tr><td><a href="#" onclick="alert('Login with Facebook to Spread Karma');" ><img src="/images/karma-inactive.png" title="Spread Karma" /></a><td><p id="counter"><?php echo $likecount; ?></p></td></tr>
</table>
</div>
$businessid and $userid are both defined higher up on the page.
like.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'].'/includes/db_connect.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/includes/functions.php';
$userid = $_GET['userid'];
$businessid = $_GET['businessid'];
$IP = $mysqli->real_escape_string(getClientIP());
$like_status = $_GET['like_status'];
if ($stmt = $mysqli -> prepare("SELECT count(id)
FROM votes
WHERE userid=? and businessid=? ")) {
$stmt -> bind_param('ss', $userid, $businessid);
$stmt -> execute();
$stmt ->bind_result($count);
$stmt ->fetch();
$stmt ->close();
}
if ($count == '1') {
if ($stmt = $mysqli -> prepare("UPDATE votes
SET ip=?, status=?
WHERE userid=? and businessid=? ")) {
$stmt -> bind_param('ssss', $IP, $like_status, $userid, $businessid);
$stmt -> execute();
$stmt -> close();
$mysqli -> close();
}
}
if ($count == '0') {
if ($stmt = $mysqli -> prepare("INSERT INTO votes (userid, businessid, ip, status)
VALUES ( ?, ?, ?, ? ) ")) {
$stmt -> bind_param('ssss', $userid, $businessid, $IP, $like_status );
$stmt -> execute();
$stmt -> close();
$mysqli -> close();
}
}
?>
I appreciate any help that you guys can give me. Like I said, I'm new to this kind of coding and looking for any pointers that you may have.
