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
| <?php
require('connexion.php');
// If form submitted, insert values into the database.
if (isset($_REQUEST['voiture_assuree'])) {
// removes backslashes
$voiture_assuree = stripslashes($_REQUEST['voiture_assuree']);
//escapes special characters in a string
$voiture_assuree = mysqli_real_escape_string($conn,$voiture_assuree);
$modele = stripslashes($_REQUEST['modele']);
//escapes special characters in a string
$modele = mysqli_real_escape_string($conn,$modele);
$marque = stripslashes($_REQUEST['marque']);
$marque = mysqli_real_escape_string($conn,$marque);
$query = "INSERT into test (voiture_assuree ,modele,marque)
VALUES ('$voiture_assuree' ,'$modele','$marque')";
$result = mysqli_query($conn,$query);
if($result){
echo '<div style="text-align:center" class="msg">'.'
<h3>Assurance Ajouté avec success</h3>'.'
<br/>
<form style="text-align:center" method="post">
<button type="submit" name="excell" class="btn btn-success" style="width:180px"> Exporter Fichier Excel </button >'.'</div>'.'</form>
';
$sql = "SELECT id, voiture_assuree, marque,modele FROM test";
$result = $conn->query($sql);
$conn->close();
}
}else{
?>
<div style="text-align:center" class="form">
<h1> Assurance Auto </h1>
<form style="text-align:center" name="test" action="" method="post">
<input style="text-align:center" type="text" name="voiture_assuree" placeholder="Voiture Assurée" required /><br><br>
<input style="text-align:center" type="text" name="marque" placeholder="Marque de Voiture" required /><br><br>
<input style="text-align:center" type="text" name="modele" placeholder="Modele" required /><br><br>
<button type="submit" name="submit" class="btn btn-primary"> Valider </button>
<!-- <a href="index.php" class="btn btn-primary"> Retour </a> -->
</form>
</div>
<?php } ?> |
Partager