[MySQL] enregistrement d'un Textarea "poussé"

Bonjour, j'aimerais pousser un petit peu +le formulaire de ma page v_ajoutClient.php ci-dessous.

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
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>

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".
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".

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
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>

Merci d'avance pour votre généreuse aide ! :)