private static function insertExcelDataToTable($excelData, $field_names, $conn, $shpTablename)
{
$str = implode(",", array_map(function ($data) {
return $data['column_name'];
}, $field_names));
$i = 0;
$count = 0;
foreach ($excelData as $row_data) {
if ($i > 0) {
try {
$sql = "insert into " . $shpTablename . " (" . $str . ") values(";
$sql = $sql . SpatialFileMethods::getExcelRowdataValues($field_names, $row_data[0]);
$sql = $sql . ")";
$conn->query($sql);
$count += 1;
} catch (Doctrine\DBAL\DBALException $e) {
}
}
$i += 1;
}
return $count;
}
