dongwei3172 2018-08-16 11:03
浏览 92
已采纳

Doctrine 2.2 Symfony 3.4中的日期时间字符串转换

I am troubleshooting a search bar to return rows within a period chosen from 'To' and 'From' datepickers.

I initially got this error :

Error: Method Doctrine\ORM\Query\Expr\Comparison::__toString() must not throw an exception, caught Symfony\Component\Debug\Exception\ContextErrorException: Catchable Fatal Error: Object of class DateTime could not be converted to string

I converted the relevant query to a string using ->format() function:

            if (is_array($value) && isset($value['to'])) {

            $to = \DateTime::createFromFormat('d/m/Y H:i:s', $value['from'] . ' 23:59:59');
            var_dump($value, $to);die;
            if ($to <> false) {
                $query->andWhere(
                        $query->expr()->lte($path, $to->format('Y-m-d H:i:s'))
                );
            }
        }

Now doctrine throws the following error:

[Syntax Error] line 0, col 977: Error: Expected end of string, got '00'

Is there something else I need to do to format the date to make it acceptable to the querybuilder? I've tried using / instead of : but this causes an issue.

  • 写回答

1条回答 默认 最新

  • dqwd71332 2018-08-16 12:47
    关注

    If I recall correctly, you should either use literal(), or query parameter. And since the lte argument is not constant, using literal() is highly discouraged (due to potential SQL injection).

    Anyway, something like this should probably work:

    if (is_array($value) && isset($value['to'])) {

    if (is_array($value) && isset($value['to'])) {
    
        $to = \DateTime::createFromFormat('d/m/Y H:i:s', $value['from'] . ' 23:59:59');
    
        if ($to <> false) {
            $query->andWhere($query->expr()->lte($path, ':to'));
            $query->setParameter('to', $to->format('Y-m-d H:i:s'));
        }
    }
    

    Does it work?

    Hope it helps...

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 PdfiumViewer pdf转图片
  • ¥15 利用Java连接API接口总是出问题
  • ¥15 请教一个关于镜头标定,棋盘格格子大小的问题(畸变测试)
  • ¥15 安装GroudingDINO RuntimeError: Error compiling objects for extension
  • ¥15 关于推送项目到github的问题
  • ¥15 急!C++指针编写相关的问题
  • ¥15 kerberos身份认证配置问题
  • ¥30 用python写一个多签情况下波场的代理资源和回收资源
  • ¥15 matlab学期例题代码答疑
  • ¥15 在线手电筒追加按钮JS