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 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
| <?php
session_start();
mysql_query("SET NAMES 'utf8'");
?>
<html>
<head>
<meta charset="utf-8"/ >
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel ="stylesheet" href = "main.css" type = "text/css">
<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>
<body style="background-color: black; color:white;">
<script type="text/javascript">
function ConfirmMessage() {
if (confirm("Voulez-vous modifier ce client ?")){
alert("Le client a bien été modifié !");
window.location.assign('v_liste.php');
}
}
</script>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<div id = "bienvenueMaintenance">
<h1>Bienvenue sur la page de gestion des contrats de maintenance !</h1><br>
</div>
<?php
if(isset($_POST['liste1']))
{
//si la liste a été "postée" c'est à dire choix fait
$liste1=$_POST['liste1'];
}else{
$liste1=-1;
}
?>
<form method="post" action="v_liste.php">
<INPUT class ="boutonRetour" TYPE="submit" value="RETOUR"/>
</form>
<h2 style ="color:white; text-align:center; ">Selectionnez le nom du client dans la liste ci-dessous :</h2><br>
<form id="selectionNomMaintenance" name ="selectionNomMaintenance" method= "POST" action="v_contratMaintenance.php">
<select name = "liste1" class="liste1" onchange="selectionNomMaintenance.submit();">
<option value =-1> -- Choisissez -- </option>
<?php
$base = mysql_connect('localhost','root','');
mysql_select_db('fichesclients', $base);
$requete = 'SELECT societeClient FROM infoclient WHERE typeContrat="Maintenance"';
$exec_req = mysql_query($requete);
mysql_query("SET NAMES 'utf8'");
while ($data = mysql_fetch_array($exec_req))
{
echo "<option value=\"".$data["societeClient"]."\"";
if($liste1==$data['societeClient']){ echo "selected";}//pour garder la selection lors du réaffichage
echo ">".$data['societeClient']."</option>\n";
}
?>
</select></form>
<?php
if($liste1 != -1){
$requete = "SELECT idClient, societeClient, nomClient, prenomClient, telephoneMobileClient, telephoneFixeClient, adresseClient, emailClient, dateContratClient, typeContrat, notesClient FROM infoclient WHERE societeClient ='".$liste1."'";
$exec_req =mysql_query($requete);
$data = mysql_fetch_array($exec_req);
?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
<form action ="v_contratMaintenance.php" class="input-group2" method ="POST">
<input name="idClient" type ="hidden" value="<?php echo $data['idClient'];?>"><br>
<input style ="text-align:center;" type="text" name="societeClient" value="<?php echo $data['societeClient']; ?>"/><br><br>
<input style ="text-align:center;" type="text" name="nomClient" value="<?php echo $data['nomClient']; ?>" /><br><br>
<input style ="text-align:center;" type="text" name="prenomClient" value="<?php echo $data['prenomClient']; ?>" /><br><br>
<input style ="text-align:center;" type="tel" name="telephoneMobileClient" maxlength="10" value="<?php echo $data['telephoneMobileClient']; ?>"/><br><br>
<input style ="text-align:center;" type="tel" name="telephoneFixeClient" maxlength="10" value="<?php echo $data['telephoneFixeClient']; ?>"/><br><br>
<input style ="text-align:center;" type="text" name="adresseClient" value="<?php echo $data['adresseClient']; ?>"/><br><br>
<input style ="text-align:center;" type="email" name="emailClient" value="<?php echo $data['emailClient']; ?>"/><br><br>
<input style ="text-align:center;" type="date" name="dateContratClient" value="<?php echo $data['dateContratClient']; ?>"/><br><br>
<input style ="text-align:center;" disabled="disabled" type="text" name="typeContrat" placeholder ="<?php echo $data['typeContrat']; ?>" value ="<?php $data['typeContrat']; ?>"> <br><br>
<center><textarea name="notesClient" resize="none" rows="8" cols="30" value="<?php echo $data['notesClient']; ?>" placeholder="<?php echo $data['notesClient']; ?>"></textarea></center><br>
<input type="reset" value="Reset"/>
<input type="submit" name="modifierClient" value="Modifier" onClick="ConfirmMessage()"/>
</form>
<?php
}
if (isset($_POST['modifierClient']))
{
$cnx = mysql_connect("localhost", "root", "");
$db = mysql_select_db("fichesclients");
$idClient = mysql_escape_string($_POST["idClient"]);
$societeClient = mysql_escape_string($_POST['societeClient']);
$nomClient = mysql_escape_string($_POST['nomClient']);
$prenomClient = mysql_escape_string($_POST['prenomClient']);
$telephoneMobileClient = mysql_escape_string($_POST['telephoneMobileClient']);
$telephoneFixeClient = mysql_escape_string($_POST['telephoneFixeClient']);
$adresseClient = mysql_escape_string($_POST['adresseClient']);
$emailClient = mysql_escape_string($_POST['emailClient']);
$dateContratClient = mysql_escape_string($_POST['dateContratClient']);
$notesClient = mysql_escape_string($_POST['notesClient']);
$sql = "UPDATE infoclient SET societeClient = '$societeClient', nomClient = '$nomClient', prenomClient = '$prenomClient', telephoneMobileClient = '$telephoneMobileClient', telephoneFixeClient = '$telephoneFixeClient', adresseClient ='$adresseClient', emailClient = '$emailClient', dateContratClient = '$dateContratClient', notesClient = '$notesClient' WHERE idClient = '$idClient'";
$requete = mysql_query($sql, $cnx) or die (mysql_error());
}
?>
</body>
</html> |
Partager