I'm having trouble getting this AJAX code to update my database. The code is a image that onClick
will run the command to update the database
HTML:
<a>
<img class = "heart"
src = "images/heart.png"
onClick = "favUpdate(0,1)"
onMouseover = "this.src='images/heart_mo.png'"
onMouseout = "this.src='images/heart.png'"/>
</a>
Javascript code:
function favUpdate(fav_up, id_up) {
$.ajax({
type: 'post',
url: 'includes/fav_update.php',
data: {favorite: fav_up, id: id_up},
success: function(output) {
alert('success, server says '
+ output
+ 'Variables passed are '+fav_up+' '+id_up);
},
error: function() {
alert('something went wrong, Favorite update failed');
}
});
}
PHP code:
<?php
require_once('../Connections/main.php');
$fav_update = mysql_real_escape_string($_POST['favorite']);
$fav_id = mysql_real_escape_string($_POST['id']);
$query = "UPDATE projects SET favorite = $fav_update WHERE id = $fav_id";
mysql_query($query, $main);
?>
main.php
<?php
$hostname_main = "localhost";
$database_main = "test";
$username_main = "root";
$password_main = "";
$main = mysql_pconnect($hostname_main, $username_main, $password_main) or trigger_error(mysql_error(),E_USER_ERROR);
?>
Does anyone know why it's not updating the database and why the "option" isn't getting data for the variable?