2013-09-20 11:09
浏览 36

单击链接/按钮上的Jquery / AJAX更新表

I have a table populated from MySQL, I'm trying to update values by a click of a button, but I'm not really sure where to start.

I am just getting into Jquery / AJAX, and haven't really figured it out quite yet so don't be too harsh on me.

In my example I have a HTML table that looks like this:

ID   Status      Set Status
1    Pending     Yes / No
2    Pending     Yes / No
3    Pending     Yes / No
4    Pending     Yes / No
5    Pending     Yes / No

Now when I click on ID 3 Yes, MySQL entry with ID 3 should be updated to Yes

My question is, how do I find out which Yes / No of which row was clicked ? How do I pass that to the processing script via AJAX ?

My Yes / No Links have the ID of the entry attached like so:

<a href="status.php?set=yes&id=3">

I'm fine with the PHP part I think, my problem is getting the correct data to it.

//Edit, this is the table:

<table class="table table-striped table-bordered table-hover datatable">
           <th><div class="checkbox"><input type="checkbox" /></div></th>
           <th>Set Status</th>
      $query=mysql_query( "select * from test");
  <td><div class="checkbox"><input type="checkbox" /></div></td> 
  <td><?php echo $data['id']; ?></td>
  if($data['status'] == 'pending') 
       echo "<span class=\"label label-warning\">Pending</span>";
  elseif($data['status'] == 'yes') 
      echo "<span class=\"label label-success\">Yes</span>";
  elseif($data['status'] == 'no') 
    echo "<span class=\"label label-danger\">No</span>";
  if($data['status'] == 'pending') 
      echo "<a href=\"" . "status?set=yes&id=" . $data['id'] ."\" class=\"btn btn-success btn-xs\"><i class=\"icon-ok-sign\"></i> Yes</a>" . " <a href=\"" . "status?set=no&id=" . $data['id'] ."\" class=\"btn btn-danger btn-xs\"><i class=\"icon-remove\"></i>No</a>"; 
   } ?>
     } ?>

/// EDIT 2

Utilizing user574632's answer, I got the simple AJAX GET to work as to updating the table, now I'm trying to get some feedback posted back to the user and hiding the 2 buttons.


$id = $_GET['id'];
$status = $_GET['set'];

if($_GET['set'] == 'yes') {
$result = mysql_query("UPDATE test SET status='yes' WHERE id='$id'") 
or die(mysql_error()); 
echo "Status Changed to Yes";
exit();  }

if($_GET['set'] == 'no') {
$result = mysql_query("UPDATE test SET status='no' WHERE id='$id'") 
or die(mysql_error()); 
echo "Status Changed to No";
exit();  }
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

相关推荐 更多相似问题