Jquery/Php help

nonamedude · **Posted:** Sun Apr 10, 2011 12:56 pm

Hey guys,

I recently started using jquery, and i have come across a problem for the project i am doing.

I am trying to imitate the rating system of youtube for my new site. This site is one that has articles

So once a user log ins, i want to be able to read the amount of thumbs up./down the user has for a particular article. So far, i have been able to get this to work. But the problem is, I dont know how this would be possible if there are several articles with a unique id for each of them.

This is what I have so far

The function that changes the image and increments the value

code:

$(document).ready(function()
{
var check = 0;
$('a#hello').one("click", function()
{

$.get(
"http://localhost/test/folder/includes/mqsql.php",
null,
function(data) {
// alert(data);
var value = data;
// $('#c').replaceWith(value);
$('#c').html(value);

}

);
$("#up").attr("src","images/thumbup_blue.png");
$("#down").attr("src","images/thumbdown_gray.png");

}

)
$('a#two').one("click", function()
{
$.get(
"http://localhost/test/folder/includes/mqsql2.php",
null,
function(data) {
// alert(data);
var value = data;
//$('#c').replaceWith(value);
$('#c').html(value);
// alert (value);

}
);
$("#down").attr("src","images/thumbdown_red.png");
$("#up").attr("src","images/thumbup_gray.png");
}
)
}

)

The php script that reads the mysql database

code:

<?php
require ("connect.php");
mysql_select_db("article_info") or die ("Could not select Database");
$extract = mysql_query("SELECT * FROM articles")or die ("Not working");
//$numrows = mysql_num_row($extract);
while ($row = mysql_fetch_assoc($extract)) {
$id = $row['id'];
$article = $row['article'];
$thumbsup= $row['thumbs_up'];
$thumbsdown = $row['thumbs_down'];
$date = $row['date_time'];
$username = $row['username'];

}

;
$thumbsup++;
mysql_query("UPDATE `article_info`.`articles` SET `thumbs_up` = $thumbsup");
echo $thumbsup;
//$Response = array( 'Id' => $id, 'Article' => $article,'ThumbsUp' => $thumbsup);

exit;

?>

And this is where it is being printed to

code:

nonamedude · **Posted:** Sun Apr 10, 2011 2:21 pm

*bump*

Tony · **Posted:** Sun Apr 10, 2011 2:38 pm

you can make a get request with arguments passed back to php

code:

$.get(
"http://localhost/test/folder/includes/mqsql.php?id=42",
...

make sure to do properly escape any such arguments.

nonamedude · **Posted:** Sun Apr 10, 2011 2:43 pm

Oh, i see what you mean, but how do I know which id to request, since the id is in php. Is there a way to pass the id from php to the jquery function?

Tony · **Posted:** Sun Apr 10, 2011 2:58 pm

Presumably you want the id of the current page you are on, right?

nonamedude · **Posted:** Sun Apr 10, 2011 4:28 pm

Not the id of the page i am on but the id what i clicked, for example, if an image has an id, when i click it, i want that id to be sent to jquery.

Tony · **Posted:** Sun Apr 10, 2011 4:45 pm

Right. Lets try it this way -- if the image to be clicked was just a regular link, it would still need to know the ID to go to the right page, correct? How would you "send" an id to that link tag?

nonamedude · **Posted:** Sun Apr 10, 2011 4:56 pm

I am not sure what you meant but,

$('#c').html(value);

The 'c' above is the id of the div that i am replacing the value in. If there are more than one divs, then the id has to be changed based on what the user selects. So i need to pass the id on to the function, cause right now, I have just written the c manually.

Amailer · **Posted:** Sun Apr 10, 2011 5:08 pm

Label each tag for which ID you want to get, with a common class and do something like

code:

then do something like:

code:

$('.common').bind('click', function () {
var myid = $(this).attr('id');
});

nonamedude · **Posted:** Sun Apr 10, 2011 5:17 pm

ahhhh i see, thanks a lot!!!

	Computer Science Canada Programming C, C++, Java, PHP, Ruby, Turing, VB Username: Password: Register
Wiki Blog Search Turing Chat Room Members