PHP and MySQL voting system with jQuery

Question

You can see my fiddle of what i'm doing here: fiddle

In vote_up.php I insert the vote into MySQL and replaces the link with 2 messages:

"successful" or "error"

But the problem now is, I don't need to change the link, I must update the 2 boxes showing a new question without reloading the page.

This is before I vote: Before voting up

And after I vote: After voting up

What i need when they click up(Aceptar) is it changes the question instead of showing that I voted. Thanks.

Ok, i found something interesting: --$("#mod-question").html('new question'); -- Now what i must find is how to do the php and sql selects for the new question. — Jorge Bellido
– Jorge Bellido, Commented Sep 5, 2011 at 9:17

Vince V. · Accepted Answer · 2011-09-05 09:25:05Z

1

You need a backend that gives the information back in a format (like JSON or XML) and then parse it into the page. When they click the vote link there happens a ajax request to vote. And the response of this ajax request is your new question.

Then you parse the request, replace your old question with the new one. And replace your ajax request URL with the new ID of the new question. (so you can vote always again)

answered Sep 5, 2011 at 9:25

Vince V.

3,1413 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Jorge Bellido Over a year ago

So i must write all the page $("#mod-question").html('here'); with each div replaced. Or ""And the response of this ajax request is your new question."" do you mean all the question and html code must be there? I'm sorry, no jquery developer :( Totally lost. Thanks

Vince V. Over a year ago

I'm no jQuery dev either :) But what I would do is to give each element that needs to be replaced an ID or class and replace the contents of each element. (div with the question you just replace the text, the anchor to vote just replace the href etc. etc.) This is a good practice, because if you want to change your layout, you just need to assign the classes (or ID's) to the new elements and your script still works.

Jorge Bellido Over a year ago

Thanks you with your info. I was null at jquery. I created the xml(dynamic). I parsed the xml and replaced the old divs and hrefs with. But got errors and errors. I Answered my question.

Jorge Bellido · Accepted Answer · 2011-09-05 22:09:40Z

0

My problem resolved in other post:

$(document).ready(function()
{

$(document).delegate('.vote, .vote1', 'click', function()
    {
...

answered Sep 5, 2011 at 22:09

Jorge Bellido

798 bronze badges

Collectives™ on Stack Overflow

PHP and MySQL voting system with jQuery

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related