Bonjour, j'ai un souci pour renvoyer des informations saisies dans un formulaire dans une base de données...
Je voudrais renvoyer les informations dans table nommée "requests"....
<body style="font-family: Arial, sans-serif;font-size: 10px; color: #000000;">
<form action="emission.php" method="POST" >
<table width="800" align="left" valign="top" cellspacing="4" cellpadding="4" border="0">
<tr valign="middle">
<td width="800" height="50" colspan="2" bgcolor="#39C0FF">
<div style="font-size: 24px; color: #FFFFFF;">Bienvenue sur PROMO</div>
</td>
</tr>
<tr valign="top">
<td width="120" height="510" rowspan="2" bgcolor="#39C0FF">
<div style="font-size: 10px;"><b>MENU</b><br>
<ul>
<li><a href=index.php>Accueil</a></li>
<li><a href=emission.php>Emission</a></li>
<li><a href=rubrique2.php>Vos demandes</a></li>
<li><a href=partiepp.php>Partie Pilote Processus</a></li>
<li><a href=partiedq.php>Partie Direction de la Qualité</a></li>
<li><a href=processus.php>Processus</a></li>
<li><a href=procedure.php>Procedure</a></li>
<li><a href=rubrique4.php>Déconnexion</a></li>
</ul>
</div>
</td>
<td width="680" height="470" bgcolor="#FFFFFF">
<div>
<center><h2><font color="#2771CB">Enregistrer votre demande</font></h2>
</center>
<?php
include "modules/adodb/adodb.inc.php";
include "config/config.php";
$db = NewADOConnection("oci8");
$cstr = "(DESCRIPTION=(ADDRESS=(PROTOCOL=$PROTOCOL)(HOST=$HOST)(PORT=$PORT))(CONNECT_DATA=(SID=$SID)))";
$db->Connect($cstr, $USER, $PWD);
if (isset($_POST["create"]))
{
$pros1 = $_POST['pros1'];
$prod1 = $_POST['prod1'];
$page = $_POST['page'];
$chapitre = $_POST['chapitre'];
$paragraphe= $_POST['paragraphe'];
$libelle = $_POST['libelle'];
$db->Execute("INSERT INTO requests(idrequest, page, chapter,paragraph, wording, daterequest, iduser, idprocess, idprocedure)VALUES(sq_requests.NEXTVAL,'$page','$chapitre','$paragraphe','$date','','$pros1','$prod1')" );
}
echo "<form action='emission.php' method='POST' >";
echo"<table border='0'>";
$date = date("d-m-Y");
?>
<p><center>Les champs marqués d'une <font COLOR="#FF0000"><b>*</b></font> doivent obligatoirement être renseignés!
</center>
<tr>
<td>
<label for="date">La <em>date</em> de votre demande est le <?php Print($date)?></label>
</td>
</tr>
<?php
$req = "SELECT * FROM processes ORDER BY heading ASC";
$res = $db->Execute($req);
?>
<tr>
<td><label for="pros1">Veuillez sélectionner le <em>processus</em> concerné</label> :</td>
<td><select name="pros1" id="id_pros1" onChange="submit()">
<option>-- Choisissez --</option>
<?php
while ($data=$res->FetchRow()){
?>
<option value="<?php echo $data[0]?>" <?php if($_POST['pros1']==$data[0]){echo "selected";} ?>><?php echo $data[1]?></option>
<?php
}
?>
</select>
</td>
</tr>
<?php
if(isset($_POST['pros1']) && $_POST['pros1']!="")
{
$req = "SELECT * FROM procedures WHERE idprocess= '".$_POST['pros1']."' ORDER BY heading ASC " ;
$res=$db->Execute($req);
?>
<td><label>Veuillez sélectionner la <em>procédure</em> concernée</label> :</td>
<td><select name="prod1" id="id_prod1">
<option>-- Choisissez --</option>
<?php
while ($data=$res->FetchRow()){
?>
<option value="<?php echo $data[0]?>" ><?php echo $data[2]?></option>
<?php
}
?>
</select>
</td>
</tr>
<?php
}
?>
<tr>
<td><label for="page">Veuillez saisir la <em>page</em></label> :</td>
<td><select name="page" id="page">
<?php
echo "<option>1</option>";
echo "<option>2</option>";
echo "<option>3</option>";
echo "<option>4</option>";
echo "<option>5</option>";
echo "<option>6</option>";
echo "<option>7</option>";
echo "<option>8</option>";
echo "<option>9</option>";
echo "<option>10</option>";
echo "<option>11</option>";
echo "<option>12</option>";
echo "<option>13</option>";
echo "<option>14</option>";
echo "<option>15</option>";
echo "<option>16</option>";
echo "<option>17</option>";
echo "<option>18</option>";
echo "<option>19</option>";
echo "<option>20</option>";
echo "<option>21</option>";
echo "<option>22</option>";
echo "<option>23</option>";
echo "<option>24</option>";
echo "<option>25</option>";
echo "<option>26</option>";
echo "<option>27</option>";
echo "<option>28</option>";
echo "<option>29</option>";
echo "<option>30</option>";
echo "<option>31</option>";
echo "<option>32</option>";
echo "<option>33</option>";
echo "<option>34</option>";
echo "<option>35</option>";
echo "<option>36</option>";
echo "<option>37</option>";
echo "<option>38</option>";
echo "<option>39</option>";
echo "<option>40</option>";
echo "<option>41</option>";
echo "<option>42</option>";
echo "<option>43</option>";
echo "<option>44</option>";
echo "<option>45</option>";
echo "<option>46</option>";
echo "<option>47</option>";
echo "<option>48</option>";
echo "<option>49</option>";
echo "<option>50</option>";
echo "<option>51</option>";
echo "<option>52</option>";
echo "<option>53</option>";
echo "<option>54</option>";
echo "<option>55</option>";
echo "<option>56</option>";
echo "<option>57</option>";
echo "<option>58</option>";
echo "<option>59</option>";
echo "<option>60</option>";
?>
</select>
</td>
</tr>
<tr>
<td><label for="chapitre">Veuillez saisir le <em>chapitre</em><font COLOR="#FF0000"><b>*</b></font></label> :</td>
<td><input type="text" name="chapitre" id="chapitre" tabindex="1"> </td>
</tr>
<tr>
<td><label for="paragraphe">Veuillez saisir le <em>paragraphe</em><font COLOR="#FF0000"><b>*</b></font></label> :</td>
<td><input type="text" name="paragraphe" id="paragraphe" tabindex="1"> </td>
</tr>
<tr>
<td><label for="libelle">Veuillez saisir le <em>libellé</em><font COLOR="#FF0000"><b>*</b></font></label> :</td>
<td><textarea name='libelle' rows=7 cols=60 id="libelle">
Merci d'avance
bbk974
Afficher la suite
