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
| $date1 = mysql_real_escape_string (trim($_POST['date'][1]));
$date2 = $today = date("Y-m-j");
$user = $_SESSION['nom'];
$ref = mysql_real_escape_string ($_POST['ref'][1]);
$nom = mysql_real_escape_string ($_POST['nom_client'][1]);
$adr = mysql_real_escape_string ($_POST['adr'][1]);
$code = mysql_real_escape_string ($_POST['postal'][1]);
$commune = mysql_real_escape_string ($_POST['commune'][1]);
$address_mac = $_POST['mac'][1].":".$_POST['mac'][2].":".$_POST['mac'][3].":".$_POST['mac'][4].":".$_POST['mac'][5].":".$_POST['mac'][6];
$tech = mysql_real_escape_string ($_POST['technicien']);
$heure_debut = mysql_real_escape_string ($_POST['ha'][1].":".$_POST['ha'][2]);
$heure_fin = mysql_real_escape_string ($_POST['hd'][1].":".$_POST['hd'][2]);
$telephone = mysql_real_escape_string ($_POST['tel'][1]);
$installation = mysql_real_escape_string ($_POST['installation']);
//$commentaire = mysql_real_escape_string ($_POST['com']);
/************************************ TEST array_map
*****************************************
$_POST = array_map( 'htmlentities', $_POST );
//$ref = $_POST['ref'];
/*************************** Insertion dans la TABLE prestation
***************************************/
$sql = "INSERT INTO prestation_tvc_lux (date_encodage, date, nom_utilisateur, ref_client, nom_client, adr_client, code_postal, commune, adr_modem, technicien, heure_debut, heure_fin, telephone, etat_installation, commentaire) values ( '".$date2."','".$date1."','".$user."','".$ref."','".ucfirst($nom)."','".ucfirst($adr)."','".$code."','".ucfirst($commune)."','".strtoupper($address_mac)."', '".$tech."','".$heure_debut."','".$heure_fin."','".$telephone."','".$installation."','".ucfirst($commentaire)."')"; |
Partager