doubiankang2845 2015-11-16 07:58
浏览 53

如何使用FluentPDO检测错误

I am using FluentPDO to build my queries.

When I execute an insert statement, it returns False if it is unable to do so. However, I am unable to figure out how to retrieve the error behind the failure.

Does anyone know how to handle errors while using this library?

This is my current code...

function doInsert() {
    $pdo = new PDO("mysql:dbname=blog", "root", "password");
    $fpdo = new FluentPDO($pdo);

    $values = [
        'field1' => 'value 1',
        'field2' => 'value 2',
        'field3' => 'value 3',
    ];

    $query = $fpdo->insertInto('my_table', $values)->execute();
    if (!$query) {
        // what to type here to determine error
    }
}
  • 写回答

1条回答 默认 最新

  • droirqk4795 2015-12-15 21:10
    关注

    This is NOT the answer, but the explanation from author (FluentPDO/BaseQuery.php Line: 98):

        // At this point, $result is a PDOStatement instance, or false.
        // PDO::prepare() does not reliably return errors. Some database drivers
        // do not support prepared statements, and PHP emulates them.  Postgres
        // does support prepared statements, but PHP does not call Postgres's
        // prepare function until we call PDOStatement::execute() (below).
        // If PDO::prepare() worked properly, this is where we would check
        // for prepare errors, such as invalid SQL.
    
    评论

报告相同问题?

悬赏问题

  • ¥20 @microsoft/fetch-event-source 流式响应问题
  • ¥15 ogg dd trandata 报错
  • ¥15 高缺失率数据如何选择填充方式
  • ¥50 potsgresql15备份问题
  • ¥15 Mac系统vs code使用phpstudy如何配置debug来调试php
  • ¥15 目前主流的音乐软件,像网易云音乐,QQ音乐他们的前端和后台部分是用的什么技术实现的?求解!
  • ¥60 pb数据库修改与连接
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False