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 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107
| <?php
mysql_query("SET NAMES 'utf8'");
session_start();
?>
<html>
<head>
<meta charset="utf-8" >
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" media="screen and (min-device-width:768px) and (max-device-width:1023px)" href="mainMin768.css" type="text/css" />
<link rel="stylesheet" media="screen and (min-device-width:1024px) and (max-device-width:1300px)" href="mainMin1024.css" type="text/css" />
<link rel="stylesheet" media="screen and (min-device-width:1301px) and (max-device-width:1400px)" href="mainMin1301.css" type="text/css" />
<link rel="stylesheet" media="screen and (min-device-width:1401px)" href="mainMin1401.css" type="text/css" />
<title>InfobisPro</title>
</head>
<script language=JAVASCRIPT>
function validation()
{
if(confirm('Êtes-vous sûr de faire cet ajout ?')){
alert("Le nouveau client a été ajouté !");
}
else{
alert("Ouf !");
}
}
</script>
<style>
body {
background-color: black;
color:white;
}
</style>
<div class ="titre">
<h1>
Formulaire d'ajout d'un client<br><br>
</h1>
</div>
<form method="post" action="v_liste.php">
<INPUT class ="boutonRetourAjoutClient" TYPE="submit" value="RETOUR"/>
</form>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
<form class="input-group1" action="v_ajoutClient.php" method="POST">
<br><input type="text" name="societeClient" value="" placeholder="Nom de société"/><br><br>
<input type="text" name="nomClient" value="" placeholder="Nom du responsable"/><br><br>
<input type="text" name="prenomClient" value="" placeholder="Prénom"/><br><br>
<input type="tel" name="telephoneMobileClient" maxlength="10" value="" placeholder="Téléphone mobile"/><br><br>
<input type="tel" name="telephoneFixeClient" maxlength="10" value="" placeholder="Téléphone fixe"/><br><br>
<input type="text" name="adresseClient" value="" placeholder="Adresse de facturation"/><br><br>
<input type="email" name="emailClient" value="" placeholder="Email"/><br><br>
<input type="date" name="dateContratClient" value=""/><br><br>
<input type="radio" name="typeContrat" value="Maintenance">
Maintenance
<input type="radio" name="typeContrat" value="CALP">
CALP <br><br>
<center><textarea name="notesClient" resiez="none" rows="8" cols="30" value="" placeholder="NOTES"></textarea></center><br>
<input class = "boutonResetForm" type="reset" value="RESET"/>
<input class = "boutonValiderForm" type="submit" name="valider" value="VALIDER" onclick="validation()" />
</form>
<?php
$info ='';
mysql_connect("localhost","root","") or die("Echec de connexion au serveur.");
mysql_select_db("fichesclients") or die("Echec de connexion à la base de données.");
if (isset($_POST['valider']))
{
$societeClient = mysql_real_escape_string($_POST['societeClient']);
$nomClient = mysql_real_escape_string($_POST['nomClient']);
$prenomClient = mysql_real_escape_string($_POST['prenomClient']);
$telephoneMobileClient = mysql_real_escape_string($_POST['telephoneMobileClient']);
$telephoneFixeClient = mysql_real_escape_string($_POST['telephoneFixeClient']);
$adresseClient = mysql_real_escape_string($_POST['adresseClient']);
$emailClient = mysql_real_escape_string($_POST['emailClient']);
$dateContratClient = mysql_real_escape_string($_POST['dateContratClient']);
$typeContrat = mysql_real_escape_string($_POST['typeContrat']);
$notesClient = mysql_real_escape_string($_POST['notesClient']);
if(empty($societeClient) || empty($nomClient) || empty($prenomClient) || empty($telephoneMobileClient) || empty($telephoneFixeClient) || empty($adresseClient) || empty($emailClient) || empty($dateContratClient) || empty($typeContrat) || empty($notesClient))
$info = 'veuillez renseigner tous les champs';
else
{
$query = "INSERT INTO infoclient(societeClient, nomClient, prenomClient, telephoneMobileClient, telephoneFixeClient, adresseClient, emailClient, dateContratClient, typeContrat, notesClient) VALUES('$societeClient','$nomClient','$prenomClient','$telephoneMobileClient','$telephoneFixeClient','$adresseClient','$emailClient','$dateContratClient','$typeContrat','$notesClient')";
$query1 = "INSERT INTO infocalendrier(dispoCal, dateCal, notesCal, societeClient, typeContrat)
VALUES(DEFAULT, NULL, NULL, '$societeClient', '$typeContrat')";
if(mysql_query($query) and mysql_query($query1))
$info = 'cest bon';
else
$info = 'Erreur lors de la creation';
}
}
?>
</html> |
Partager