файл csv в postgresql, на php
Проблема в цикле как я понимаю, может из за того что колона массив?
<?php
if(isset($_POST['submitcsv']) and $_FILES)
{
require ('../con/head_loc.php');
$file = fopen('uploades/Insert.csv', 'r');
while ( ( $line = fgetcsv( $file ) ) !== FALSE)
{
$rec = "INSERT INTO pos (id, serial, mid, tid, pos_type, mcc, merchant_name, merchant_tax_number, merchant_address, pos_owner_id, payment_system_id)
VALUES ('" . $file[0] . "', '" . $file[1] . "', '" . $file[2] . "', '" . $file[3] . "', '" . $file[4] . "', '" . $file[5] . "', '" . $file[6] . "', '" . $file[7] . "', '" . $file[8] . "', '" . $file[9] . "')";
}
fclose( $file );
}
?>
Но sql через получается:
COPY pos (serial, mid, tid, pos_type, mcc, merchant_name, merchant_tax_number, merchant_address, pos_owner_id, payment_system_id) FROM '/home/comp/Рабочий стол/work elements/Insert.csv' DELIMITER ',' CSV HEADER;
Ну вот и содержания файла:
"serial","mid","tid","pos_type","mcc","merchant_name","merchant_number","merchant_address","pos_id","payment_id"
44103,442239,44113,"ZA 220",2323,"MN SX",33333,"27 Marks str.",1,1
44817,447115,447115,"zA 250",2323,"SIXTY Sxx",3332222,"29 ABss str.",1,1
444034,444132,447132,"za 220",2323,"SIXTY Q",33333222,"Micro 4 dist.N2",1,1
44484980,447133,447133,"za 250",2323,"SIXTY R",333333332,"4/3 Peace circle",1,1
В базе данных serial уникальный