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