[RESOLVED] prepare csv data before import

[vang]

hi,

i would like to learn how to prepare csv data before import into mysql using php script.

eg.
the csv file contains column data like date in this format (01-jan-10).
i want to auto change it to date format (eg. yyyy-mm-dd) during importing.

eg.
the csv file contain column data like student_id.
i want to get the student name from another table and inset both the student_id & student name into this table during importing.

i've search online but have not find any similar tutorial.

[Weedpacket]

I'm afraid you're going to have to do some programming; tutorials can only get you so far.

Actually work out how to explain to a computer that "01-jan-10" represents the tenth of January 2001.

[mrbaseball34]

Are you positive that the date data will always be in the same format in the same column?

You can use the strtotime function to convert it to the format you want.

<?php

$str = '04-jun-10';
// yyyy-mm-dd
$timestamp = strtotime($str);
echo "$str == " . date('Y-m-d', $timestamp)."<br>";
echo date('l dS \o\f F Y h:i:s A', $timestamp);

?>

[vang]

many many thanks for your guidance, 🙂