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
|
public function createBdd($val,$type_CSV)
{
$bdd=new MYPDO();
foreach($val as $val_bdd)
{
$deb_req="INSERT INTO `".$type_CSV."` ";
$list_colons='(id_SESA,alternate_id,platform,platform_owner,publisher,application_name,HFMCODE,Currently_active,Activate_date,Deactivate_date,Group_name,Office_Country,Firstname,Lastname,Company_name,Job_code,Reporting_entity,Business_unit_name,Location,Internet_Address,Manager_firstname,Manager_lastname,Manager_email)';
$list_values=" VALUES('".$val_bdd."')";
$sql=$deb_req.$list_colons.$list_values;
$ret=$bdd->select( $sql, [] );
var_dump($ret);
}
return $ret;
}
///////////////////////
$CSV_in_bdd=new CSVInBDD();
$ret=$CSV_in_bdd->createBdd($val['content'],$val['type_csv']);
if ($ret)
{
$body = new PhpEcho('', ['msg_end' => $_FILES['file2']['name']." fully processed, without errors."]);
$body->setCode('<p>'.$body('msg_end').'</p>');
echo $body;
}
else{
$body = new PhpEcho('', ['msg_error' => $_FILES['file2']['name']." has not been put in BDD."]);
$body->setCode('<p>'.$body('msg_error').'</p>');
echo $body;
} |
Partager