summaryrefslogtreecommitdiff
path: root/ext/mysqli/tests/007.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/mysqli/tests/007.phpt')
-rw-r--r--ext/mysqli/tests/007.phpt51
1 files changed, 51 insertions, 0 deletions
diff --git a/ext/mysqli/tests/007.phpt b/ext/mysqli/tests/007.phpt
new file mode 100644
index 0000000000..89d1959752
--- /dev/null
+++ b/ext/mysqli/tests/007.phpt
@@ -0,0 +1,51 @@
+--TEST--
+mysqli fetch short values
+--FILE--
+<?php
+ include "connect.inc";
+
+ /*** test mysqli_connect 127.0.0.1 ***/
+ $link = mysqli_connect("localhost", $user, $passwd);
+
+ mysqli_select_db($link, "test");
+
+ mysqli_query($link,"DROP TABLE IF EXISTS test_bind_fetch");
+ mysqli_query($link,"CREATE TABLE test_bind_fetch(c1 smallint unsigned,
+ c2 smallint unsigned,
+ c3 smallint,
+ c4 smallint,
+ c5 smallint,
+ c6 smallint unsigned,
+ c7 smallint)");
+
+ mysqli_query($link, "INSERT INTO test_bind_fetch VALUES (-23,35999,NULL,-500,-9999999,+30,0)");
+
+ $stmt = mysqli_prepare($link, "SELECT * FROM test_bind_fetch");
+ mysqli_bind_result($stmt, &$c1, &$c2, &$c3, &$c4, &$c5, &$c6, &$c7);
+ mysqli_execute($stmt);
+ mysqli_fetch($stmt);
+
+ $test = array($c1,$c2,$c3,$c4,$c5,$c6,$c7);
+
+ var_dump($test);
+
+ mysqli_stmt_close($stmt);
+ mysqli_close($link);
+?>
+--EXPECT--
+array(7) {
+ [0]=>
+ int(0)
+ [1]=>
+ int(35999)
+ [2]=>
+ NULL
+ [3]=>
+ int(-500)
+ [4]=>
+ int(-32768)
+ [5]=>
+ int(30)
+ [6]=>
+ int(0)
+}