adding a few tests

1 files changed, 68 insertions, 0 deletions

diff --git a/ext/mysqli/tests/025.phpt b/ext/mysqli/tests/025.phpt
new file mode 100644
index 0000000000..f32ef143f2
--- /dev/null
+++ b/ext/mysqli/tests/025.phpt
@@ -0,0 +1,68 @@
+--TEST--
+mysqli bind_param/bind_result tinyint 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 tinyint,
+                                                     c2 tinyint unsigned,
+                                                     c3 tinyint not NULL,
+                                                     c4 tinyint,
+                                                     c5 tinyint,
+                                                     c6 tinyint unsigned,
+                                                     c7 tinyint)");
+
+	$stmt = mysqli_prepare ($link, "INSERT INTO test_bind_fetch VALUES(?,?,?,?,?,?,?)");
+	mysqli_bind_param($stmt,&$c1, MYSQLI_BIND_INT,&$c2, MYSQLI_BIND_INT,&$c3, MYSQLI_BIND_INT,&$c4, MYSQLI_BIND_INT,
+				&$c5, MYSQLI_BIND_INT,&$c6, MYSQLI_BIND_INT,&$c7, MYSQLI_BIND_INT);
+
+	$c1 = -23;
+	$c2 = 300;
+	$c3 = 0;
+	$c4 = -100;
+	$c5 = -127;
+	$c6 = 30;
+	$c7 = 0;
+
+	mysqli_execute($stmt);
+	mysqli_stmt_close($stmt);
+
+	mysqli_query($link, "INSERT INTO test_bind_fetch VALUES (-23,300,0,-100,-127,+30,0)");
+
+	$c1 = $c2 = $c3 = $c4 = $c5 = $c6 = $c7 = NULL;
+
+	$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(-23)
+  [1]=>
+  int(255)
+  [2]=>
+  int(0)
+  [3]=>
+  int(-100)
+  [4]=>
+  int(-127)
+  [5]=>
+  int(30)
+  [6]=>
+  int(0)
+}