按钮单击更新数据库[关闭]

Question

I have been struggling with this for a few days. I have a webpage that has a table of dynamically created data on it (using php and datatable). Everything works great. Now I have 2 columns with buttons for each row :

NAME | ADDRESS   | STAGE | ASSIGN  
John   9 Doe Way   btnS     btnA

All I want to do is when the user clicks the btnS or btnA run a simple update query and put that person that is clicked into the stage or assign category for this activity. (I can handle that part in the database). I can do this fine if I have a hyperlink instead of buttons. I want the page to refresh, because the will remove the name from my list.

So how do I get the ID of the row of the dynamically created button? I have a hidden field for ID if needed.

I would paste code, but I have no idea the correct direction. I have tried jquery (function), form POST function, but nothing seems to work?

Thanks!!

Answer 1

You can insert an onclick attribute to your button like this:

<button onclick="location.href='http://www.example.com/yourscript.php?id='+ parentNode.parentNode.childNodes[0].innerHTML" />Delete</button>

There's another solution also:

<form action="">
  <input type="submit" name="SaveChanges" value="Delete" onclick="this.form.action='http://www.example.com/yourscript.php?id='+ parentNode.parentNode.childNodes[0].innerHTML;" />
</form>

So..

<table>
  <tr><th>ID</th><th>Address</th><th>Delete</th></tr>
  <tr><td id="id">1</td>
      <td>John</td>
      <td>9 Doe Way</td>
      <td><button onclick="location.href='http://www.example.com/yourscript.php?id='+ parentNode.parentNode.childNodes[0].innerHTML" />Delete</button></td></tr>
</table>