1 2 3 4 5
| $liendb = mysql_connect($bddserver, $bddlogin, $bddpassword);
mysql_select_db ($bdd); // sélection de la base
$sql = "INSERT INTO retenues (`eleNOM`, `elepre`, `divcod`, `Combien`, `Qui`, `Quand1`, `OU`, `Dateincident`, `Heures1`, `Heures1bis`, `Cause`, `travail`, `elenoet`, `DATE_R` )
VALUES ('$eleNOM','$elepre','$divcod','$nbre','$Qui','$Quand1','$OU','$Dateincident','$Heures1','$Heures1bis','$Cause','$travail','$elenoet', STR_TO_DATE($Quand1,'%d/%m/%Y') );
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error()); |
Partager