I have the following PivotTable and I want to delete the records via AJAX / PHP but I can not.
I tried this way by passing the line id as the button id but it did not work ...
include("dbconn.php");
<script src="jquery.min.224.js"></script>
<?php $qry = pg_query($dbconn,"select id, nome, cidade from tabela"); ?>
<div id="tabela">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<?php while($qryRow = pg_fetch_assoc($qry)){ ?>
<form id="form" method="post">
<script>
$("#<?php echo $qryRow['id'];?>").click(function(e){
e.preventDefault();
$.ajax({
type: "POST",
url: "apagar.php",
data: { botao: $(this).val() },
beforeSend: function() { $("#loaderdiv").show(); },
success: function(data) { $("#loaderdiv").hide(); }
})
.done(function(data){
$("#apagar_msg").html(data);
//$("#form")[0].form.reset();
});
});
</script>
<tr>
<td><?php echo $qryRow['id'];?></td>
<td><?php echo $qryRow['nome'];?></td>
<td><?php echo $qryRow['cidade'];?></td>
<td><button type="button" name="apagar" id="<?php echo $qryRow['id'];?>" value="<?php echo $qryRow['id'];?>">Apagar</button></td>
</tr>
</form>
<?php } ?>
</tbody>
</table>
</div>
<div id="apagar_msg"></div>
On the delete page you get the value of the line and process:
<?php
include("dbconn.php");
if(isset($_POST['apagar'])){
$qry = pg_query($dbconn,"delete from tabela where id = ".$_POST['apagar']."");
if(pg_affected_rows($qry)>0){
echo 'Registro apagado';
}else{
echo 'Registro não apagado!';
}
}
?>