No decimal values on csv import..help ?
Posted: Tue Aug 02, 2005 2:58 pm
Hi,
I import a csv file into table, but all values (two columns with decimal values) are rounded to whole numbers..
Is there a mistake in the script or what ?
Thanks for checking..
I import a csv file into table, but all values (two columns with decimal values) are rounded to whole numbers..
Is there a mistake in the script or what ?
Thanks for checking..
Code: Select all
$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);
?>