PHPのお勉強！

PHP TOP
PHP 8.4.2 Released!

    sqlsrv_has_rows

    (No version information available, might only be in Git)

    sqlsrv_has_rows — Indicates whether the specified statement has rows

    説明

    sqlsrv_has_rows(resource $stmt): bool

    Indicates whether the specified statement has rows.

    パラメータ

    stmt

    A statement resource returned by sqlsrv_query() or sqlsrv_execute().

    戻り値

    Returns true if the specified statement has rows and false if the statement does not have rows or if an error occurred.

    例

    例1 sqlsrv_has_rows() example

    <?php
    $server     = "serverName\sqlexpress";
    $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" );
    $conn = sqlsrv_connect( $server, $connectionInfo );

    $stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");

    if (    $stmt) {
    $rows = sqlsrv_has_rows( $stmt );
    if (    $rows === true)
    echo     "There are rows. <br />";
    else
    echo     "There are no rows. <br />";
    }
    ?>

    参考

    Found A Problem?

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

    User Contributed Notes 1 note

    up
    3
    Bin Ury
    7 years ago
    This function cannot be relied on to report errors since both a existence negative and a SQL error will report the same boolean value.
    ＋add a note
    To Top