$hote=*****;
$login=****;
$mdp=******;
$nombd='iac';
$nom_table = 'iac.Operateur_reject';
$bdd = mysqli_connect($hote, $login, $mdp, $nombd) or die ("Unable to connect to the Database");
$myfile = fopen("reject.csv", "r") or die("Unable to open file!");
$unic_id_calc = 0;
$operateur = 'SFR';
while(!feof($myfile))
{
 if ($line = fgets($myfile))
 {
    $pieces = explode(";", $line);
        if (isset($pieces[0]))
        {
            $Date_Heure = $pieces[0];
            //$Date_Heure = mysqli_real_escape_string($bdd, $Date_Heure);
            //echo $Date_Heure . ",  ";
        }
        else
            $Date_Heure = NULL;
        if (isset($pieces[1]))
        {
            $Numéro = $pieces[1];
            ////$Numéro = mysqli_real_escape_string($bdd, $Numéro);
            //echo $Numéro . ", ";
        }
        else
            $Numéro = NULL;
        if (isset($pieces[2]))
        {
            $Trunk = $pieces[2];
            //$Trunk = mysqli_real_escape_string($bdd, $Trunk);
            //echo $Trunk . ", ";
        }
        else
            $Trunk = NULL;
        if (isset($pieces[3]))
        {
            $Cause = $pieces[3];
            //$Cause = mysqli_real_escape_string($bdd, $Cause);
            //echo $Cause . ", ";
        }
        else
            $Cause = NULL;
        if (isset($pieces[4]))
        {
            $Occurrence = $pieces[4];
            //$Occurrence = mysqli_real_escape_string($bdd, $Occurrence);
            //echo $Occurrence . "<br>";
        }
        else
            $Occurrence = NULL;
        $secure = md5($unic_id_calc);
        //echo $secure . "<br>";
        $query = "INSERT INTO '$nom_table' (Operateur, unic_id_calc, Date_Heure, Numéro, Trunk, Cause, Occurrence) VALUES (" . $operateur . ", " . $secure . ", " . $Date_Heure . ", " . $Numéro . ", " . $Trunk . ", " . $Cause . ", " . $Occurrence . ")";
        mysqli_query($bdd, $query) or die ("la requete n'a pas pu etre executée, query vaut : " . $query);
        $unic_id_calc++;
 }
}
fclose($myfile) or die ("Impossible de fermer le fichier");
mysqli_close($bdd) or die ("Impossible de se déconnecter de la Bdd");
?>