DaniWeb Forum Index > Web Development > PHP

csv, convert date, mysql, php

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 1

Reputation: budiman is an unknown quantity at this point

Solved Threads: 0

budiman

Offline

Newbie Poster

csv, convert date, mysql, php

Dec 17th, 2007

HI

I want to submit csv file data into mysql using php.
One of the fields contain data : date with format (dd-mm-yyy).
I want to store the data in mysql with date format (yyy-mm-dd).
pls tell me how 2 do.
pls help me
Thanks.
bye

•

Join Date: Feb 2007

Posts: 1,602

Reputation: scru has a spectacular aura about

Solved Threads: 130

scru

Offline

Posting Virtuoso

Re: csv, convert date, mysql, php

Dec 17th, 2007

First you calculate a timestamp integer from the old date (that is the number of seconds from January 1, 1970 00:00:00 GMT to the old date).

Then you call the php function date() with a format string and pass in the timestamp. Like so:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$datestring = date("Y-m-d", $timestamp);
$datestring = date("Y-m-d", $timestamp);

See here for more information on using date format strings.

•

Join Date: Nov 2007

Posts: 3,744

Reputation: nav33n is a jewel in the rough

Solved Threads: 330

nav33n

Offline

Senior Poster

Re: csv, convert date, mysql, php

Dec 17th, 2007

First, you fetch the data from the csv file using fgetcsv. Its returns the value as an array. Access the array element where the date is stored and do as scru has mentioned.

Ignorance is definitely not bliss!

*PM asking for help will be ignored*