1--TEST--
2mysqli insert (bind_param + bind_result) char/text types
3--EXTENSIONS--
4mysqli
5--SKIPIF--
6<?php
7require_once dirname(__DIR__) . "/test_setup/test_helpers.inc";
8mysqli_check_skip_test();
9?>
10--FILE--
11<?php
12require_once dirname(__DIR__) . "/test_setup/test_helpers.inc";
13
14    $link = default_mysqli_connect();
15
16    mysqli_query($link,"CREATE TABLE insert_bind_char_text(c1 char(10), c2 text)");
17
18    $stmt = mysqli_prepare($link, "INSERT INTO insert_bind_char_text VALUES (?,?)");
19    mysqli_stmt_bind_param($stmt, "ss", $q1, $q2);
20    $q1 = "1234567890";
21    $q2 = "this is a test";
22    mysqli_stmt_execute($stmt);
23    mysqli_stmt_close($stmt);
24
25    $stmt = mysqli_prepare($link, "SELECT * FROM insert_bind_char_text");
26    mysqli_stmt_bind_result($stmt, $c1, $c2);
27    mysqli_stmt_execute($stmt);
28    mysqli_stmt_fetch($stmt);
29
30    $test = array($c1,$c2);
31
32    var_dump($test);
33
34    mysqli_stmt_close($stmt);
35    mysqli_close($link);
36    print "done!";
37?>
38--CLEAN--
39<?php
40require_once dirname(__DIR__) . "/test_setup/test_helpers.inc";
41tear_down_table_on_default_connection('insert_bind_char_text');
42?>
43--EXPECT--
44array(2) {
45  [0]=>
46  string(10) "1234567890"
47  [1]=>
48  string(14) "this is a test"
49}
50done!
51