php-src/ext/mysqli/tests/mysqli_class_mysqli_stmt_interface.phpt

--TEST--
Interface of the class mysqli_stmt
--EXTENSIONS--
mysqli
--SKIPIF--
<?php
    require_once 'skipifconnectfailure.inc';
?>
--FILE--
<?php
    require 'table.inc';

    $link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket);
    $stmt = new mysqli_stmt($link);

    printf("Parent class:\n");
    var_dump(get_parent_class($stmt));

    printf("\nMethods:\n");

    $methods = get_class_methods($stmt);
    $expected_methods = array(
        '__construct'       => true,
        'attr_get'          => true,
        'attr_set'          => true,
        'bind_param'        => true,
        'bind_result'       => true,
        'close'             => true,
        'data_seek'         => true,
        'execute'           => true,
        'fetch'             => true,
        'free_result'       => true,
        'get_warnings'      => true,
        'num_rows'          => true,
        'prepare'           => true,
        'reset'             => true,
        'result_metadata'   => true,
        'send_long_data'    => true,
        'store_result'      => true,
    );

    $expected_methods['get_result'] = true;
    $expected_methods['more_results'] = true;
    $expected_methods['next_result'] = true;

    foreach ($methods as $k => $method) {
    if (isset($expected_methods[$method])) {
        unset($methods[$k]);
        unset($expected_methods[$method]);
    }
        if ($method == 'mysqli_stmt') {
            // get_class_method reports different constructor names
            unset($expected_methods['__construct']);
            unset($methods[$k]);
        }
    }
    if (!empty($methods)) {
        printf("More methods found than indicated. Dumping list of unexpected methods.\n");
        var_dump($methods);
    }
    if (!empty($expected_methods)) {
        printf("Some methods are missing. Dumping list of missing methods.\n");
        var_dump($expected_methods);
    }
    if (empty($methods) && empty($expected_methods))
        printf("ok\n");

    printf("\nClass variables:\n");
    $variables = array_keys(get_class_vars(get_class($stmt)));
    sort($variables);
    foreach ($variables as $var)
        printf("%s\n", $var);

    printf("\nObject variables:\n");
    $variables = array_keys(get_object_vars($stmt));
    foreach ($variables as $var)
        printf("%s\n", $var);

printf("\nMagic, magic properties:\n");

try {
    mysqli_stmt_affected_rows($stmt);
} catch (Error $exception) {
    echo $exception->getMessage() . "\n";
}

try {
    $stmt->affected_rows;
} catch (Error $exception) {
    echo $exception->getMessage() . "\n";
}

if (!$stmt->prepare("INSERT INTO test(id, label) VALUES (100, 'z')") || !$stmt->execute()) {
    printf("[001] [%d] %s\n", $stmt->errno, $stmt->error);
}

assert(mysqli_stmt_affected_rows($stmt) === $stmt->affected_rows);
printf("stmt->affected_rows = '%s'\n", $stmt->affected_rows);

assert(mysqli_stmt_errno($stmt) === $stmt->errno);
printf("stmt->errno = '%s'\n", $stmt->errno);

assert(mysqli_stmt_error($stmt) === $stmt->error);
printf("stmt->error = '%s'\n", $stmt->error);

assert(mysqli_stmt_error_list($stmt) === $stmt->error_list);
var_dump("stmt->error = ", $stmt->error_list);

assert(mysqli_stmt_field_count($stmt) === $stmt->field_count);
printf("stmt->field_count = '%s'\n", $stmt->field_count);

assert($stmt->id > 0);
printf("stmt->id = '%s'\n", $stmt->id);

assert(mysqli_stmt_insert_id($stmt) === $stmt->insert_id);
printf("stmt->insert_id = '%s'\n", $stmt->insert_id);

assert(mysqli_stmt_num_rows($stmt) === $stmt->num_rows);
printf("stmt->num_rows = '%s'\n", $stmt->num_rows);

assert(mysqli_stmt_param_count($stmt) === $stmt->param_count);
printf("stmt->param_count = '%s'\n", $stmt->param_count);

assert(mysqli_stmt_sqlstate($stmt) === $stmt->sqlstate);
printf("stmt->sqlstate = '%s'\n", $stmt->sqlstate);

printf("\nAccess to undefined properties:\n");
printf("stmt->unknown = '%s'\n", @$stmt->unknown);
@$stmt->unknown = 13;
printf("stmt->unknown = '%s'\n", @$stmt->unknown);

print "done!";
?>
--EXPECTF--
Parent class:
bool(false)

Methods:
ok

Class variables:
affected_rows
errno
error
error_list
field_count
id
insert_id
num_rows
param_count
sqlstate

Object variables:

Magic, magic properties:
mysqli_stmt object is not fully initialized
Property access is not allowed yet
stmt->affected_rows = '1'
stmt->errno = '0'
stmt->error = ''
string(14) "stmt->error = "
array(0) {
}
stmt->field_count = '0'
stmt->id = '%d'
stmt->insert_id = '0'
stmt->num_rows = '0'
stmt->param_count = '0'
stmt->sqlstate = '00000'

Access to undefined properties:
stmt->unknown = ''
stmt->unknown = '13'
done!