duan7664 2018-07-14 13:32
浏览 47

使用strtotime从xpath转换日期但继续获得纪元

Trying to convert dates being scraped with xpath to mysql datetime format and having some trouble. The below is my date, and my function to convert the date, and my desired output:

$date = '  8-May-2014';
$date_fixed = date("Y-m-d H:i:s", strtotime(trim($date)));

echo $date; // '  8-May-2014'
echo $date_fixed; // '2014-05-08 00:00:00'

The issue is that when I run this in my server (php7), and the date is set from an xpath nodeValue, the conversion comes back at the epoch time instead, even though the value of that node is the date string. I var_dump'ed the nodeValues to verify they are strings, and they are. I tried setting the nodeValue to a new variable and then converting that, still doesn't work.

$date = $xpath->query('./td[2]', $row)->item(0)->nodeValue; // '  8-May-2014'
$date_fixed = date("Y-m-d H:i:s", strtotime($date));

echo $date_fixed; // '1970-01-01 00:00:00'

I'm not sure what I'm missing.

  • 写回答

1条回答 默认 最新

  • dsf6778 2018-07-14 14:24
    关注

    Turned out to be non-unicode characters. Not sure why the browser or php or xpath returned them as spaces, but eliminated them with:

    substr($date, 4);
    
    评论

报告相同问题?

悬赏问题

  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目,支持注册表等
  • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
  • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
  • ¥15 lingo18勾选global solver求解使用的算法
  • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
  • ¥20 测距传感器数据手册i2c