PDOStatement::errorCode

    (PHP 5 >= 5.1.0, PHP 7, PHP 8, PECL pdo >= 0.1.0)

    PDOStatement::errorCode — Fetch the SQLSTATE associated with the last operation on the statement handle

    Description

    public PDOStatement::errorCode(): ?string

    Parameters

    This function has no parameters.

    Return Values

    Identical to PDO::errorCode(), except that PDOStatement::errorCode() only retrieves error codes for operations performed with PDOStatement objects.

    Examples

    Example #1 Retrieving an SQLSTATE code

    <?php
    /* Provoke an error -- the BONES table does not exist */
    $err = $dbh->prepare('SELECT skull FROM bones');
    $err->execute();

    echo     "\nPDOStatement::errorCode(): ";
    print     $err->errorCode();
    ?>

    The above example will output:

    PDOStatement::errorCode(): 42S02

    See Also

    • PDO::errorCode() - Fetch the SQLSTATE associated with the last operation on the database handle
    • PDO::errorInfo() - Fetch extended error information associated with the last operation on the database handle
    • PDOStatement::errorInfo() - Fetch extended error information associated with the last operation on the statement handle

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top