コード例 #1
0
if (!mysqli_stmt_bind_param($stmt, "b", $label)) {
    printf("[014] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
$label = 'abc';
for ($i = 0; $i < 10; $i++) {
    if (!mysqli_stmt_send_long_data($stmt, 0, $label)) {
        printf("[015 - %d] [%d] %s\n", $i, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
    }
}
if (!mysqli_stmt_reset($stmt)) {
    printf("[016] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (!mysqli_stmt_execute($stmt)) {
    printf("[017] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (!($res = mysqli_query($link, "SELECT label FROM test"))) {
    printf("[018] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
if (!($row = mysqli_fetch_assoc($res))) {
    printf("[019] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
mysqli_free_result($res);
if ($row['label'] != '') {
    printf("[020] Expecting empty string, got string/%s\n", $row['label']);
}
mysqli_stmt_close($stmt);
if (NULL !== ($tmp = mysqli_stmt_reset($stmt))) {
    printf("[021] Expecting NULL, got %s/%s\n");
}
mysqli_close($link);
print "done!";
コード例 #2
0
ファイル: 057.php プロジェクト: alphaxxl/hhvm
if ($result = mysqli_query($link, "SELECT * FROM test_057_table_1")) {
    mysqli_free_result($result);
    printf("Query ok\n");
}
mysqli_stmt_close($stmt);
/* now we should try mysqli_stmt_reset() */
$stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1");
var_dump(mysqli_stmt_execute($stmt));
var_dump(mysqli_stmt_reset($stmt));
var_dump($stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1"));
if ($stmt->affected_rows !== 0) {
    printf("[001] Expecting 0, got %d\n", $stmt->affected_rows);
}
var_dump(mysqli_stmt_execute($stmt));
var_dump($stmt = @mysqli_prepare($link, "SELECT * FROM test_057_table_1"), mysqli_error($link));
var_dump(mysqli_stmt_reset($stmt));
$stmt = mysqli_prepare($link, "SELECT * FROM test_057_table_1");
mysqli_stmt_execute($stmt);
$result1 = mysqli_stmt_result_metadata($stmt);
mysqli_stmt_store_result($stmt);
printf("Rows: %d\n", mysqli_stmt_affected_rows($stmt));
/* this should show an error, cause results are not buffered */
if ($result = mysqli_query($link, "SELECT * FROM test_057_table_1")) {
    $row = mysqli_fetch_row($result);
    mysqli_free_result($result);
}
var_dump($row);
mysqli_free_result($result1);
mysqli_stmt_close($stmt);
mysqli_close($link);
echo "done!";
コード例 #3
0
if (!mysqli_stmt_fetch($stmt)) {
    printf("[021] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if ($id !== 1) {
    printf("[022] Expecting int/1 got %s/%s\n", gettype($id), $id);
}
mysqli_stmt_close($stmt);
if (!($stmt = mysqli_stmt_init($link))) {
    printf("[023] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}
if (!mysqli_stmt_prepare($stmt, "SELECT id FROM test ORDER BY id LIMIT 1")) {
    printf("[024] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (true !== ($tmp = mysqli_stmt_execute($stmt))) {
    printf("[025] Expecting boolean/true, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
if (true !== ($tmp = mysqli_stmt_reset($stmt))) {
    printf("[026] Expecting boolean/true, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
}
var_dump(mysqli_stmt_execute($stmt));
var_dump(mysqli_stmt_fetch($stmt));
mysqli_kill($link, mysqli_thread_id($link));
if (false !== ($tmp = mysqli_stmt_execute($stmt))) {
    printf("[027] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
}
mysqli_stmt_close($stmt);
if (NULL !== ($tmp = mysqli_stmt_execute($stmt))) {
    printf("[028] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
mysqli_close($link);
print "done!";