I'm importing a csv file into Mysql.
Problem is that the csv has values like this: 4,45647 (Note the comma)
I need to change the comma to dot to import this correctly into Mysql.
Anyone knows how to ?
Script I use:
Code: Select all
<?php
mysql_select_db($database_ASN, $ASN);
$fp = fopen('Klassement.csv', 'r');
// first line has column names
$data = fgetcsv($fp, 2048, ';');
$columns = array();
foreach($data as $column)
{
$columns[] = trim($column, '"');
}
mysql_query('DELETE FROM testklassement');
$sql = 'INSERT INTO testklassement (';
$sql .= implode($columns, ', ');
$sql .= ') VALUES (';
// next lines have values
while (($data = fgetcsv($fp, 2048, ';')) !== FALSE)
{
$sql2 = $sql;
foreach($data as $column)
{
$column = mysql_real_escape_string($column);
$sql2 .= "'{$column}', ";
}
$sql2 = rtrim($sql2, ', ');
$sql2 .= ')';
echo 'Executing: ' . $sql2 . '</br>';
mysql_query($sql2) or print(mysql_error() . '<br>');
}
fclose($fp);
?>