B0Bka / box

0 stars 0 forks source link

csv import #27

Open B0Bka opened 6 years ago

B0Bka commented 6 years ago

`if (($handle = fopen("svcar.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if($data[1] != '') { $arAdd = array("SITE_ID" => "s1", "RULE" => $data[0], "TARGET" => $data[1]); add($arAdd); } } fclose($handle); } function add($arFields) { global $DB; $table = 'b_webvision_seo_redirects';

foreach ($arFields as $k => $v)
{
    $arFields[$k] = '"'.$DB->ForSQL($v).'"';
}
return $DB->Insert($table, $arFields, '');

}`