dpjjr42626 2015-07-23 23:33
浏览 96

Datetime作为数组并转换日期格式并插入数据库

I'm importing data from CSV file into database through HTML form, having multiple datetime in format 23/06/2015 12:00 which i convert to 2015-23-06 with follwing code

$Datetime = $emapData['1']; //Format is 23/06/2015 12:00
$ConvertDatetime = DateTime::createFromFormat('d/m/Y', $Datetime);
$NewDatetime = new DateTime($ConvertDatetime);
$NewDate = $NewDatetime->format('Y-m-d'); Here I have date in desire format (2015-06-23)
$NewTime = $NewDatetime->format('H:i'); Here I have time in format (7:00)

One solution is that i repeat above code by changing variables name to convert other datetime in csv which i did and things working fine but I'm thinking to use arrays, load the datetime into arrays and then convert datetime and then insert converted datetime into database.

$DateTimeArray = array( 
    '2/17/2015 13:59', '2/20/2015 18:59', '2/05/2015 05:59', '2/15/2015 03:59', '2/19/2015 12:59', '2/10/2015 14:59'
);

and then foreach

foreach ($DateTimeArray as $DateTime){ 
    $ConvertDatetime = DateTime::createFromFormat('m/d/Y', $DateTime);
    $NewDatetime = new DateTime($ConvertDatetime);
    $NewDate = $NewDatetime->format('Y-m-d');
    $NewTime = $NewDatetime->format('H:i');
    $ConvertedDateTime = $NewDate . " " . $NewTime;
    $FinalDateTime[] = $ConvertedDateTime;
}
print_r($FinalDateTime); 

but the ouput is just this current datetime

Array ( [0] => 2015-07-23 20:44 [1] => 2015-07-23 20:44 [2] => 2015-07-23 20:44 [3] => 2015-07-23 20:44 [4] => 2015-07-23 20:44 [5] => 2015-07-23 20:44 )

need help to sort it out.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 win11家庭中文版安装docker遇到Hyper-V启用失败解决办法整理
    • ¥15 gradio的web端页面格式不对的问题
    • ¥15 求大家看看Nonce如何配置
    • ¥15 Matlab怎么求解含参的二重积分?
    • ¥15 苹果手机突然连不上wifi了?
    • ¥15 cgictest.cgi文件无法访问
    • ¥20 删除和修改功能无法调用
    • ¥15 kafka topic 所有分副本数修改
    • ¥15 小程序中fit格式等运动数据文件怎样实现可视化?(包含心率信息))
    • ¥15 如何利用mmdetection3d中的get_flops.py文件计算fcos3d方法的flops?