Can somebody help with this script?

[ashkey]

Hi there

 

I am hoping that somebody will be able to help with this script I have had written. It uploads data from a .csv file to a database, although it works fine the problem is the seconds wont upload on the date and time. If I upload 16/08/2008  00:04:40 it shows on the database table as 2008-08-16 00:04:00. I need it to show the seconds also so it reads  2008-08-16 00:04:40. I have been trying for a few days but no luck can someone help?

 

 

Thanks

 

$dobParts = split("/", $AdobSTRING);

$Adob = $dobParts[2]."-".$dobParts[1]."-".$dobParts[0];

 

$datetimeParts = split(" ", $AdatetimeSTRING);

$dateParts = split("/", $datetimeParts[0]);

$timeParts = split(":", $datetimeParts[1]);

 

$Adatetime = $dateParts[2]."-".$dateParts[1]."-".$dateParts[0]." ".$timeParts[0].":".$timeParts[1].":00" ;

 

 

[Mchl]

There are specialised functions for parsing date and time. Try them

http://pl.php.net/datetime

[ashkey]

Thanks couldnt find the answer though, if anyone else knows please advise?

 

Cheers

[JonnoTheDev]

You are adding the seconds in as 00 yourself:

$Adatetime = $dateParts[2]."-".$dateParts[1]."-".$dateParts[0]." ".$timeParts[0].":".$timeParts[1].":00" ;

[ashkey]

Hi

 

Yes I should have said before, I realise that, if I remove the 00 the script wont import the data. I believe there should be another date part entered but I cant get it to work?

 

Thanks

[revraz]

Its not in $timeParts[2] ?

[ashkey]

 

 

I tried adding the .$timeParts[2] but this didn't work either, does anybody know the correct formula for this to work?

 

$Adatetime = $dateParts[2]."-".$dateParts[1]."-".$dateParts[0]." ".$timeParts[0].":".$timeParts[1].":".$timeParts[2];

 

Your help would be much appreciated.

 

 

 

[Mchl]

Why not:

$datetime = "16/08/2008  00:04:40";
$datetime = str_replace("/","-",$datetime);
$time = strtotime($datetime);
echo date("Y-m-d H:i:s",$time);