Textearea vide!!
Bonjour,
j'ai un problème avec le champs textearea qui ne s'insére pa dans base de données
voici mon code:
les autres champs sans bien insérer ms le champ reamark est vide..
j'ai un problème avec le champs textearea qui ne s'insére pa dans base de données
voici mon code:
if(isset($_POST['remark']))
$remark=mysql_real_escape_string($_POST['remark']);
$sq="INSERT INTO manager_approve(ref_no,mail, date_approve, remark) VALUES('$ref_no','$email1', '$date_approve','$remark')";
$s= mysql_query($sq) or die('Erreur SQL !'.$sq.'<br>'.mysql_error());
}
les autres champs sans bien insérer ms le champ reamark est vide..
2 réponses
-
Et si tu pouvez montrer la structure de ton formulaire , ce serait plus claire
-
voici le code entier:
<form name="remplir" method="POST" action="adm.php"> <?php if(isset ($_SESSION['receive_pc'])){ echo'<table border=0 width=90%>'; echo'<tr>'; echo'<td>'; echo'<table border=1 bgcolor="#EEEEEE" >'; echo'<TR> <td class=itemfont>APPROVAL CYCLE</TD> <TD class=itemfont>EMAIL</TD> <td class="itemfont" >SIGN</td> <TD class="itemfont">DATE</TD> </tr>'; { $d=mysql_query('SELECT date,mail_req FROM formulaire WHERE ref_no="'.mysql_escape_string($_SESSION['ref_no']).'"')or die('Erreur SQL !'.$r.'<br>'.mysql_error()); $data=mysql_fetch_array($d); $date=$data['date']; $mail_req=$data['mail_req']; $date_approve=date("Y-m-d"); echo' <tr> <TD style="font-weight: bold;">Requestor</TD> <TD>',$mail_req,'</TD> <TD>SUBMITTED</TD> <TD>',$date,'</TD> </tr>';} { $re=mysql_query("SELECT name, email FROM tablecc WHERE manager='Equipement_manager'"); $data=mysql_fetch_array($re); $name=$data['name']; $email1=$data['email']; echo' <tr> <TD>Equipement manager</TD> <TD>',$email1,'</TD> <TD>PENDING</TD> <td><input type="submit" name="approve" value="APPROVE" class="envoi"><input type="submit" name="reject" value="REJECT" class="envoi"></td> </tr>';} { $re= mysql_query("SELECT name, email FROM tablecc WHERE manager='Financial_manager'"); $data=mysql_fetch_array($re); $name=$data['name']; $email=$data['email']; echo' <tr> <TD>financial manager</TD> <TD>',$email,'</TD> <TD> </TD> <td> </td> </tr>';} { $re= mysql_query("SELECT name, email FROM tablecc WHERE manager='Security_manager'"); $data=mysql_fetch_array($re); $name=$data['name']; $email=$data['email']; echo' <tr> <TD>security manager</TD> <TD>',$email,'</TD> <TD> </TD> <td> </td> </tr>';} echo' </table>'; echo'</td>'; echo'<td valign=top> <table border=0 > <tr> REMARK : <br></tr><tr><textarea name="remark" cols=30 rows=15></textarea></tr> </table> </td> </tr> </table>'; if(isset($_POST['approve'])) {$remark=mysql_real_escape_string($_POST['remark']); $remark="";} $sq="INSERT INTO manager_approve(ref_no,mail, date_approve, remark) VALUES('$ref_no','$email1', '$date_approve','$remark')"; $s= mysql_query($sq) or die('Erreur SQL !'.$sq.'<br>'.mysql_error()); }
