Insertion enregistrement en bd par php
saber07
Messages postés
116
Date d'inscription
Statut
Membre
Dernière intervention
-
saber07 Messages postés 116 Date d'inscription Statut Membre Dernière intervention -
saber07 Messages postés 116 Date d'inscription Statut Membre Dernière intervention -
Bonjour,
j'ai bloqué en ce code
quand il est exécuter il m'a fait 2 insertion la 1ere est correcte et la 2eme est avec des champ nul
svp aider moi
<HTML>
<style type="text/css">
<!--
body,td,th {
color: #000000;
}
body {
background-repeat: repeat;
background-image: url();
background-color: #FFFFFF;
}
.Style4 {color: #0000CC}
.Style11 {color: #000000; font-weight: bold; }
.Style19 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 36px;
color: #000000;
font-style: italic;
}
-->
</style>
<BODY>
<p align="center" class="Style19">ajout</p>
<div align="center">
<TABLE width="911" BORDER=2 align="center">
<CAPTION ALIGN=top>
</CAPTION>
<TR>
<TD width="76" bgcolor="#FFFFFF"><span class="Style11">Identifiant</span></TD>
<TD width="109" bgcolor="#FFFFFF"> <span class="Style11"><STRONG>Nom<STRONG></span></TD>
<TD width="94" bgcolor="#FFFFFF"> <span class="Style11"><STRONG>Prenom<STRONG></span></TD>
<TD width="90" bgcolor="#FFFFFF"><span class="Style11"><STRONG>Societé<STRONG></span></TD>
<TD width="114" bgcolor="#FFFFFF"><span class="Style11">Adresse</span></TD>
<TD width="114" bgcolor="#FFFFFF"><span class="Style11">Telephone</span></TD>
<TD width="48" bgcolor="#FFFFFF"> <span class="Style11">Fax</span></TD>
<TD width="163" bgcolor="#FFFFFF"> <span class="Style11">Date d'inscription</span></TD>
<TD width="43" bgcolor="#FFFFFF"> <span class="Style11">Etat</span></TD>
</TR>
<?php
$db=mysql_connect("localhost", "root", "");
mysql_select_db("ommanpage");
$promo = $_POST['promo'];
echo $promo; echo "<BR>";
$ref = $_POST['ref'];
//echo $ref; echo "<BR>";
$desc= $_POST['desc'];
$type = $_POST['type'];
//echo $type; echo "<BR>";
$ech = $_POST['ech'];
//echo $ech; echo "<BR>";
$sour = $_POST['sour'];
//echo $sour; echo "<BR>";
$page = $_POST['page'];
$ech= $_POST['ech'];
echo $page;echo "<BR>";
$date = $_POST['dat'];
$activite = $_POST['activite'];
echo $date;echo "<BR>";
//$rep= mysql_query("SELECT count(code_appel_offre) FROM appel_offre") or die ("erreur calcul");
// $donnees = mysql_fetch_array($rep);
// $cod=$donnees['count(code_appel_offre)'+1];
mysql_query('INSERT INTO appel_offre vALUES ("","'.$promo.'","'.$ref.'", "'.$desc.'", "'.$type.'", "'.$date.'", "'.$ech.'", "'.$sour.'", "'.$page.'" ,"'.$activite.'");') or die ("errrreeeeurrr");
mysql_close();
?>
<BODY>
<HTML>
j'ai bloqué en ce code
quand il est exécuter il m'a fait 2 insertion la 1ere est correcte et la 2eme est avec des champ nul
svp aider moi
<HTML>
<style type="text/css">
<!--
body,td,th {
color: #000000;
}
body {
background-repeat: repeat;
background-image: url();
background-color: #FFFFFF;
}
.Style4 {color: #0000CC}
.Style11 {color: #000000; font-weight: bold; }
.Style19 {
font-family: Georgia, "Times New Roman", Times, serif;
font-size: 36px;
color: #000000;
font-style: italic;
}
-->
</style>
<BODY>
<p align="center" class="Style19">ajout</p>
<div align="center">
<TABLE width="911" BORDER=2 align="center">
<CAPTION ALIGN=top>
</CAPTION>
<TR>
<TD width="76" bgcolor="#FFFFFF"><span class="Style11">Identifiant</span></TD>
<TD width="109" bgcolor="#FFFFFF"> <span class="Style11"><STRONG>Nom<STRONG></span></TD>
<TD width="94" bgcolor="#FFFFFF"> <span class="Style11"><STRONG>Prenom<STRONG></span></TD>
<TD width="90" bgcolor="#FFFFFF"><span class="Style11"><STRONG>Societé<STRONG></span></TD>
<TD width="114" bgcolor="#FFFFFF"><span class="Style11">Adresse</span></TD>
<TD width="114" bgcolor="#FFFFFF"><span class="Style11">Telephone</span></TD>
<TD width="48" bgcolor="#FFFFFF"> <span class="Style11">Fax</span></TD>
<TD width="163" bgcolor="#FFFFFF"> <span class="Style11">Date d'inscription</span></TD>
<TD width="43" bgcolor="#FFFFFF"> <span class="Style11">Etat</span></TD>
</TR>
<?php
$db=mysql_connect("localhost", "root", "");
mysql_select_db("ommanpage");
$promo = $_POST['promo'];
echo $promo; echo "<BR>";
$ref = $_POST['ref'];
//echo $ref; echo "<BR>";
$desc= $_POST['desc'];
$type = $_POST['type'];
//echo $type; echo "<BR>";
$ech = $_POST['ech'];
//echo $ech; echo "<BR>";
$sour = $_POST['sour'];
//echo $sour; echo "<BR>";
$page = $_POST['page'];
$ech= $_POST['ech'];
echo $page;echo "<BR>";
$date = $_POST['dat'];
$activite = $_POST['activite'];
echo $date;echo "<BR>";
//$rep= mysql_query("SELECT count(code_appel_offre) FROM appel_offre") or die ("erreur calcul");
// $donnees = mysql_fetch_array($rep);
// $cod=$donnees['count(code_appel_offre)'+1];
mysql_query('INSERT INTO appel_offre vALUES ("","'.$promo.'","'.$ref.'", "'.$desc.'", "'.$type.'", "'.$date.'", "'.$ech.'", "'.$sour.'", "'.$page.'" ,"'.$activite.'");') or die ("errrreeeeurrr");
mysql_close();
?>
<BODY>
<HTML>
A voir également:
- Insertion enregistrement en bd par php
- Touche insertion clavier - Guide
- Insertion sommaire word - Guide
- Insertion filigrane word - Guide
- Insertion liste déroulante excel - Guide
- Insertion signature word - Guide