Bonjour, j'aimerais pousser un petit peu +le formulaire de ma page v_ajoutClient.php ci-dessous.
Mon problème se situe au niveau du textarea "notesClient" : j'aimerais pouvoir y rentrer des images en + du texte, et derrière l'enregistrer dans la BDD "fichesclients" dans la table "infoclient".
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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 <?php 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 =''; if (isset($_POST['valider'])) { $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']); $typeContrat = mysql_escape_string($_POST['typeContrat']); $notesClient = mysql_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')"; $pdo = new PDO('mysql:host=localhost;dbname=fichesclients','root','', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->query($query) and $pdo->query($query1); } } ?> </html>
Puis, lors de l'affichage des données des clients ( page v_contratMaintenance.php, ci-dessous ), il faudrait que les images soient affichées dans les notes avant ou après le texte du "textarea".
Merci d'avance pour votre généreuse aide !
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
124 <?php session_start(); ?> <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 $pdo = new PDO('mysql:host=localhost;dbname=fichesclients','root','', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $requete = 'SELECT societeClient FROM infoclient WHERE typeContrat="Maintenance"'; $exec_req = $pdo->query($requete); while ($data = $exec_req->fetch()) { 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 =$pdo->query($requete); $data = $exec_req->fetch(); ?> <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> <?php echo '<center><textarea name="notesClient" resize="none" value ="$data["notesClient"]" rows="8" cols="30" >'.$data["notesClient"].'</textarea></center><br>';?> <input class ="boutonResetContrat" type="reset" value="Reset"/> <input class ="boutonModifContrat" type="submit" name="modifierClient" value="Modifier" onClick="ConfirmMessage()"/> </form> <?php } if (isset($_POST['modifierClient'])) { $pdo = new PDO('mysql:host=localhost;dbname=fichesclients','root','', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $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 = $pdo->query($sql); } ?> </body> </html>
Partager