Edit Report a Bug

    maxdb_info

    maxdb::info

    (PECL maxdb >= 1.0)

    maxdb_info -- maxdb::info — Retrieves information about the most recently executed query

    설명

    절차식 형식

    string maxdb_info ( resource $link )

    객체 기반 형식

    string $maxdb->info;

    The maxdb_info() function returns a string providing information about the last query executed. The nature of this string is provided below:

    Possible maxdb_info return values
    Query type Example result string
    INSERT INTO...SELECT... Records: 100 Duplicates: 0 Warnings: 0
    INSERT INTO...VALUES (...),(...),(...) Records: 3 Duplicates: 0 Warnings: 0
    LOAD DATA INFILE ... Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
    ALTER TABLE ... Records: 3 Duplicates: 0 Warnings: 0
    UPDATE ... Rows matched: 40 Changed: 40 Warnings: 0

    Note:

    Queries which do not fall into one of the above formats are not supported. In these situations, maxdb_info() will return an empty string.

    반환값

    A character string representing additional information about the most recently executed query.

    예제

    Example #1 객체 기반 형식

    <?php
    $maxdb     = new maxdb("localhost", "MONA", "RED", "DEMODB");

    /* check connection */
    if (maxdb_connect_errno()) {
           printf("Connect failed: %s\n", maxdb_connect_error());
       exit();
    }

    $maxdb->query("CREATE TABLE temp.t1 LIKE hotel.city");

    /* INSERT INTO .. SELECT */
    $maxdb->query("INSERT INTO temp.t1 SELECT * FROM hotel.city");
    printf("%s\n", $maxdb->info);

    /* close connection */
    $maxdb->close();
    ?>

    Example #2 절차식 형식

    <?php
    $link     = maxdb_connect("localhost", "MONA", "RED", "DEMODB");

    /* check connection */
    if (maxdb_connect_errno()) {
           printf("Connect failed: %s\n", maxdb_connect_error());
       exit();
    }

    maxdb_query($link, "CREATE TABLE temp.t1 LIKE hotel.city");

    /* INSERT INTO .. SELECT */
    maxdb_query($link, "INSERT INTO temp.t1 SELECT * FROM hotel.city");
    printf("%s\n", maxdb_info($link));

    /* close connection */
    maxdb_close($link);
    ?>

    위 예제의 출력 예시:

    Records: 25 Duplicates: 0 Warnings: 0

    참고

    add a note add a note

    User Contributed Notes

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