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
| <?php
$bd2= new mysqli('localhost','root','', 'admin_compta');
$mois=$_POST["d"];
$Collabo= trim($_POST["ComboBox1"]);
$cab =$_POST["ComboBox2"];
$Doss =$_POST["ComboBox3"];
$Jrnal =$_POST["ComboBox4"];
$Moitraite =$_POST["ComboBox5"];
$tache =$_POST["textarea"];
$tempcli =$_POST["ComboBox6"];
$tempsaisi =$_POST["ComboBox7"];
$temprevi =$_POST["ComboBox8"];
$tempfac =$_POST["ComboBox9"];
$nbrlig =$_POST["nombre"];
$mois= addslashes($mois);
$Collabo= addslashes($Collabo);
$cab = addslashes($cab);
$Doss = addslashes($Doss);
$Jrnal = addslashes($Jrnal);
$Moitraite = addslashes($Moitraite);
$tache= addslashes($tache);
$tempcli= addslashes($tempcli);
$tempsaisi= addslashes($tempsaisi);
$temprevi= addslashes($temprevi);
$tempfac= addslashes($tempfac);
$nbrlig= addslashes($nbrlig);
function xmlentities($string) {
return str_replace ( array ("'"), array ("\'" ), $string );
}
$sql2="insert into compta (date_saisie,Collaborateur,Cabinet,Dossier,Journaux_de_saisie,mois_traités,taches,temps_client,temps_saisie,temps_revision,temps_facturable,nbr_ligne)
values($mois,$Collabo,$cab,$Doss,$Jrnal,$Moitraite,$tache,$tempcli,$tempsaisi,$temprevi,$tempfac,$nbrlig)";
$requete= $bd2->query($sql2) or die( 'Unable to establish a DB connection' ) ;
echo ($mois);
echo($Collabo);
?> |
Partager