function dataTable()
console.log ("Javascript OK "); //le temps des tests $(document).ready(function() { console.log("document ready ok !"); //le temps des tests var table = $('#example').dataTable(); $('#example tbody').on( 'click', 'tr', function () { if ($(this).hasClass('selected')){ $(this).removeClass('selected'); } }); $('.button').click( function () { console.log("clic sur le bouton : ok"); //le temps des tests table.row('.selected').remove().draw( false ); }); });
<?php require_once "PDO_connect.php";
$query="SELECT * FROM smartphone.abonnements";
try{
$prep = $bdd->prepare($query);
$prep->execute();
$resultats = $prep->fetchAll();
}catch(Exception $e){;
echo "Erreur ! ".$e->getMessage() ;
}
?>
<!DOCTYPE>
<html>
<head>
<title>Abonnement</title>
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/jq-2.2.4/dt-1.10.13/se-1.2.0/datatables.min.css"/>
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/jq-2.2.4/dt-1.10.13/se-1.2.0/datatables.min.js"></script>
<link rel="stylesheet" type="text/css" href="Select.css">
<script type="text/javascript">
console.log ("Javascript OK "); //le temps des tests
$(document).ready(function() {
console.log("document ready ok !"); //le temps des tests
var table = $('#example').dataTable();
$('#example tbody').on( 'click', 'tr', function () {
if ($(this).hasClass('selected')){
$(this).removeClass('selected');
}
});
$('.button').click( function () {
console.log("clic sur le bouton : ok"); //le temps des tests
table.row('.selected').remove().draw( false );
});
});
</script>
</head>
<body>
<center>
<table id="#example" class="DataTable" >
<thead>
<tr>
<th>Operateur</th>
<th>SIM</th>
<th>PUK</th>
<th>Num ligne</th>
<th>Volume</th>
<th>Statut abo</th>
</tr>
</thead><tbody>
<?php
echo "<br>";
if(!empty($resultats)){
foreach ($resultats as $row) {
echo "<tr>";
echo "<td data-name=\"Operateur\">".$row["Operateur"]."</td>";
echo "<td data-name=\"Num_SIM\">".$row["Num_SIM"]."</td>";
echo "<td data-name=\"PUK\">".$row["PUK"]."</td>";
echo "<td data-name=\"Num_ligne\">".$row["Num_ligne"]."</td>";
echo "<td data-name=\"Volume\">".$row["Volume"]."</td>";
echo "<td data-name=\"Statut_abo\">".$row["Statut_abo"]."</td>";
echo "</tr>";
}
}else {
echo "Pas d'enregistrements dans cette table...";
}
?>
</tbody></table></center>
</body>
</html>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$('#example tbody').on( 'click', 'tr', function () { if ($(this).hasClass('selected')){ $(this).removeClass('selected'); } });
$('#example tbody').on( 'click', 'tr', function () { var tr_sel = $(this).hasClass('selected'); if (tr_sel){ $(this).removeClass('selected'); } else { $(this).addClass('selected'); } });
$('#example tbody').on( 'click', 'tr', function () { $('#example tbody tr').removeClass('selected'); //retire le selected partout $(this).addClass('selected'); //met le selected sur le ligne cliquée });