jQuery的隐藏行按下按钮
问题描述:
我有以下表代码:jQuery的隐藏行按下按钮
echo "<table border='1'>
<tr>
<th>Code</th>
<th>Name</th>
<th>Price</th>
</tr>";
$sql = "SELECT * FROM products where updated_account_ID='$aktiv'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<tr>";
echo "<td>" . $row['code'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['price'] . "</td>";
echo "<td>" . "<button name='code' value='".$row['code'] ."'>Delete</button></td>";
echo "</tr>";
我想使用jQuery来隐藏或按“删除”按钮,将同时删除记录后,删除指定的行来自数据库。有人可以这么善良,并帮助做到这一点吗? 谢谢!
答
JQUERY:
$(".delete").click(function(){
var product_id = $(this).parents('tr').attr('data-product-id');
$(this).parents('tr').remove();
$.ajax({
url: "remove-record.php",
data: product_id,
type: "post",
success: function(result){
alert(result);
}
});
});
php文件:
echo "<table border='1'>
<tr>
<th>Code</th>
<th>Name</th>
<th>Price</th>
</tr>";
$sql = "SELECT * FROM products where updated_account_ID='$aktiv'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
echo "<tr data-product-id='".$row['id']."'>";
echo "<td>" . $row['code'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['price'] . "</td>";
echo "<td>" . "<button name='code' value='".$row['code'] ."'>Delete</button
</td>";
echo "</tr>";
删除-record.php:
$product_id = $_POST['data'];
$sql = "DELETE FROM products WHERE id=product_id";
echo json_encode('Record deleted');
你将不得不使用AJAX –
喔,我看到这样做,你能告诉我怎么做丝毫的? – Stonesmit