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; }