Can I get a little help on this php/javascript voting code?
This is a continuation of this question: Move div based on user voting
I first posted the question as an unregistered user, and then later registered, so I couldn't edit or add to my original q开发者_开发百科uestion...
Justin Johnson really helped me out with the code, but I'm still having a problem trying to figure out how to integrate the vote.php page.
Instead of redoing the question here, I'm hoping someone will see this, take a look at the above question (I added more in an "answer further down" and 1) help me resolve it and 2) bump up Justin's work-because I can't do it anymore because of the registration thing...
Thanks! Joel
MySQL:
CREATE TABLE song (
song_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
vote INT NOT NULL DEFAULT 0,
PRIMARY KEY(song_id)
);
JavaScript:
$(function() {
var listContainer = $("#daily-songs"),
songs = [];
var songSort = function(a, b) {
return +b.vote.text() - +a.vote.text();
};
var submitVote = function(song, delta) {
$.post("vote.php",
{
id: song.node.attr("id").match(/\d+$/)[0],
delta: delta,
},
function(data) {
if ( data != 'success' ) { alert(data); }
}
);
$.each(songs.sort(songSort), function() {
listContainer.append(this.node);
});
};
listContainer.find("li").each(function() {
var $this = $(this);
var song = {
node: $this,
vote: $this.find(".votes")
};
$this.find(".vote-up").click(function() {
submitVote(song, 1);
});
$this.find(".vote-down").click(function() {
submitVote(song, -1);
});
songs.push(song);
});
});
PHP:
<?php
$song_id = !empty($_POST['id']) ? (int)$_POST['id'] : 0;
$delta = !empty($_POST['delta']) ? (int)$_POST['delta'] : 0;
if (!$song_id || !$delta || !is_int($song_id) || !is_int($delta)) {
die("Invalid parameters");
}
// Make sure the voting value is within the valid range.
if ($delta != -1 && $delta != 1) {
exit("Invalid delta");
}
// Check to see if user has already voted for this song
session_start();
if (isset($_SESSION['voted'])) {
exit("You already voted!");
}
// If they haven't voted yet, connect to the database
// YOU NEED TO CHANGE THIS INFOMATION TO WHATEVER APPLYS TO YOU.
$dsn = 'mysql:dbname=testdb;host=127.0.0.1';
$user = 'dbuser';
$password = 'dbpass';
try {
$dbh = new PDO($dsn, $user, $password);
}
catch (PDOException $e) {
exit('Connection failed: ' . $e->getMessage());
}
// If the database connection is succesful, update song entry
// UPDATE daily_song SET votes=votes+$delta WHERE daily_song_id=$songId
$sth = $dbh->prepare('UPDATE song SET votes = votes + :delta WHERE song_id = :song_id');
$sth->bindParam(':delta', $delta);
$sth->bindParam(':song_id', $song_id);
if (!$sth->execute()) {
exit("Unable to update votes");
}
exit("success");
精彩评论