Requête delete (php+jquery)
bonsoir;
mon problème lorsque je clique sur le lien supp ,aucune modification sur ma table
voilà trois page
1: voiture.php
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Document sans titre</title>
<script src="jquery.js"></script>
<script>
$(document).ready(function()
{
$('#idm').change(function() {
var idv = $(this).val();
$.ajax({
type: 'POST',
url: "marque.php",
data: {idv: idv },
success: function(msgn){
$('#mm').html(msgn);
}
});
});
});
</script>
</head>
<body>
<form>
<select name="nmarque" id="idm">
<option></option>
<?php
$idcon=mysqli_connect("localhost","root","","basevoiture");
$result = mysqli_query($idcon,"select * from marque_voiture");
while($row = mysqli_fetch_array($result))
{
echo"<option value=".$row['id_marque'].">".$row['nom_marque']."</option>";
}
mysqli_close($idcon);
?>
</select>
<div id="mm"></div>
</form>
</body>
</html> |
2: marque.php
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
<script src="jquery.js"></script>
<script>
$(document).ready(function()
{
$('.delete').click(function(){
var response = confirm("Voulez-vous vraiment supprimer l'article?");
/* si la réponse est non */
if(!response)
{
return false; /* ANNULE LE CLICK et donc le href */
}
});
});
</script>
<table border="1">
<tr><td>matricule</td><td>couleur</td><td>KM</td><td>nom_marque</td><td>sup</td></tr>
<?php
$idcon = mysqli_connect("localhost","root","","basevoiture");
$idv = $_POST['idv'];
$result = mysqli_query($idcon,"SELECT * FROM marque_voiture where id_marque ='$idv' ");
$row = mysqli_fetch_array($result);
$result1 = mysqli_query($idcon,"SELECT * FROM voiture where id_marque ='$idv' ");
while($row1 = mysqli_fetch_array($result1))
{
echo "<tr><td>".$row1['matricule']."</td><td>".$row1['couleur']."</td><td>".$row1['km']."</td><td>".$row['nom_marque']."</td><td><a class='delete' href='d_voiture.php' id_voiture=(".$row1['id_voiture'].")' >sup</a></td></tr>";
}
mysqli_close($idcon);
?></table> |
3: d_voiture.php
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<?php
$idv = $_POST['idv'];
if (isset($idv) AND !(empty($idv)))
{
include ("voiture.php");
include ("marque.php");
$idcon = mysqli_connect("localhost","root","","basevoiture");
$result = mysqli_query($idcon,"DELETE FROM voiture WHERE id_voiture=$idv");
}
?> |
