javascript – Implementing a like/dislike counter with php and jquery

I have a comics website, and I\’d like to keep track of how many people click like and dislike for a single comic id… I\’d like to store the value in my database, and also report it back out to the browser.

This is my non-working solution:

viewcomic.php:

    <script type=\"text/javascript\">
    function likeCounter(choice) {    
       var site = $(\"#site\").val();
       var imgid = $(\"#imgid\").val();
       $.get(\"./scripts/likecounter.php\", {_choice : choice, _site : site, _id : imgid},
            function(returned_data) {
                $(\"#choice\").html(returned_data);
            }
        );
}
</script>
       //Changed to try and work with buttons
   <button id=\"like\" onClick=\"likeCounter(this.id)\">Like</button>
   <button id=\"dislike\" onClick=\"likeCounter(this.id)\">Dislike</button>
   <input id=\"site\" type=\"hidden\" value=\"<?php echo $site; ?>\">
   <input id=\"imgid\" type=\"hidden\" value=\"<?php echo $imgid; ?>\">

<br />
Likes: <span id=\"choice\"></span>

likecounter.php

<?php 
include \'dbconnect.php\';

$site = $_GET[\'_site\'];
$imgid = $_GET[\'_id\'];
$input = $_GET[\'_choice\'];

if ($site == \"artwork\") {
   $table = \"comics\";
}
else {
   $table = \"artwork\";
}

$likes = $mysqli->query(\"SELECT like FROM $table WHERE id = $imgid\");
$dislikes = $mysqli->query(\"SELECT dislike FROM $table WHERE id = $imgid\");


if ($input == \"like\") {
   $sql = \"UPDATE $table SET like = like + 1 WHERE id = $imgid\";
   $mysqli->query($sql);
   $likes++;

else if ($input == \"dislike\") {
   $sql = \"UPDATE $table SET like = dislike + 1 WHERE id = $imgid\";
   $mysqli->query($sql);
   $dislikes++;
}   
mysqli_close($mysqli);

echo \"Likes: \" . $likes . \", Dislikes: \" . $dislikes;

?>

It\’s not incrementing the database value, and it\’s not reporting out a value to the browser. Any suggestions?

Thanks!

Rating: 2 out of 5 based on 3 ratings

Posts Related to javascript - Implementing a like/dislike counter with php and jquery

• Aug 11th, 2012 count - How can I make a PHP counter? Saturday PM 12:25:04


• Nov 12th, 2012 jquery - fastest way to find element position using javascript? Monday PM 17:28:22


• Jul 24th, 2012 php - JSON: Charset and getting key/value Tuesday AM 04:55:05


• Jul 26th, 2012 Javascript hit counter for a website Thursday PM 15:28:17


• Aug 11th, 2012 javascript - Interpolate or "tween" between two values (but not animating) Saturday AM 03:19:45


• Jul 24th, 2012 sql server - Retrieving values from a PHP page, outside a form, to query MSSQL? Tuesday AM 06:24:38


• Jul 12th, 2012 javascript - Loop calling an asynchronous function Thursday AM 00:31:55


• Jul 19th, 2012 Implementing CSS variables in HTML page Thursday AM 08:45:51


• Jul 23rd, 2012 Asynchronous map/reduce in Javascript/JQuery Monday AM 06:00:33


• Jul 23rd, 2012 Smooth Transitions between div tags on click in CSS or Javascript in a single HTML Page Monday PM 14:40:49

The post javascript – Implementing a like/dislike counter with php and jquery appeared first on Javascript ASK.

via Javascript ASK http://javascriptask.phpfogapp.com/javascript-implementing-a-likedislike-counter-with-php-and-jquery.html