[lauraMember]

I am trying to build function to vote for a particular essay and I just need a little help figuring out how to incorporate ajax so it updates right on the page. Right now I have a pod page that pulls the current number of votes for each essay and displays it above the essay. There is a form button that when pressed pulls up a php file that adds one to the vote count and displays the new vote count on the update page.

Can anyone point me in the right direction on how to incorporate ajax to have the result sent back to the original pod page?

This is my pod page:
<pre>
<?php
$orderby = ‘t.date ASC’;
$limit = 100;
$where = ‘t.featured_essay = 1′;
$featuredEssay = new Pod(‘essay’);
$featuredEssay->findRecords($orderby,$limit,$where);
while ($featuredEssay->fetchRecord()) {
$id = $featuredEssay->get_field(‘id’);
$title = $featuredEssay->get_field(‘name’);
$date = $featuredEssay->get_field(‘date’);
$date = date("m/d/Y",strtotime($date));
$essay = $featuredEssay->get_field(‘essay’);
$votes = $featuredEssay->get_field(‘votes’);
$votes = round($votes);
?>

PHP

<form id=&quot;recommend&quot; method=&quot;post&quot; action=&quot;../update&quot;> <input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;<?php echo $id; ?>&quot; /> <input id=&quot;submit&quot; type=&quot;submit&quot; name=&quot;vote&quot; value=&quot;Recommend this essay&quot; /> </form> <p id=&quot;total_votes&quot;>Total number of votes: <?php echo $votes; ?></p> <h3><?php echo $title; ?></h3> <p><?php echo $date; ?></p> <div><?php echo $essay; ?></div>

1 2 3 4 5 6 7 8 9

<form id=&quot;recommend&quot; method=&quot;post&quot; action=&quot;../update&quot;>     <input type=&quot;hidden&quot; name=&quot;id&quot; value=&quot;<?php echo $id; ?>&quot; />     <input id=&quot;submit&quot; type=&quot;submit&quot; name=&quot;vote&quot; value=&quot;Recommend this essay&quot; /> </form> <p id=&quot;total_votes&quot;>Total number of votes: <?php echo $votes; ?></p>             <h3><?php echo $title; ?></h3> <p><?php echo $date; ?></p> <div><?php echo $essay; ?></div>

<?php } ?>;
</pre>

and my update page:
<pre>
<?php
if(isset($_POST['vote'])) {
$id=$_POST['id'];

PHP

// Add a vote to the database $result = pod_query(&quot;UPDATE wp_pod_tbl_essay set votes=votes+1 WHERE id=$id&quot;); $orderby = 't.id'; $limit = 100; $where = &quot;t.id ='$id'&quot;; $vote_pod = new Pod('essay'); $vote_pod->findRecords($orderby,$limit,$where); while ($vote_pod->fetchRecord()) { $votes = $vote_pod->get_field('votes'); $votes = round($votes); } echo ($votes); }

1 2 3 4 5 6 7 8 9 10 11 12 13

// Add a vote to the database $result = pod_query("UPDATE wp_pod_tbl_essay set votes=votes+1 WHERE id=$id"); $orderby = 't.id'; $limit = 100; $where = "t.id ='$id'";   $vote_pod = new Pod('essay'); $vote_pod->findRecords($orderby,$limit,$where); while ($vote_pod->fetchRecord()) {     $votes = $vote_pod->get_field('votes');     $votes = round($votes);     }     echo ($votes); }

?>
</pre>

[logikal16Member]

Laura,

The best example for getting AJAX working is to look at the code for Pods itself. Look in core/manage_pods.php. For starters, here’s a really good example:

<pre>
function dropPage() {
if (confirm("Do you really want to drop this page?")) {
jQuery.ajax({
type: "post",
url: "<?php echo PODS_URL; ?>/ajax/api.php",
data: "action=drop_page&id="+page_id,
success: function(msg) {
// "msg" is whatever is returned back from the AJAX call
// Do something here (like update some HTML elements)
}
});
}
}
</pre>

The above function passes 2 variables to the file "api.php": action, and id.

[Author]

Posts