From b6cc61737fa7bbc1e6de046a46f7c051bf6af86a Mon Sep 17 00:00:00 2001
From: Ulf Wendel <uw@php.net>
Date: Thu, 12 Jul 2007 20:57:30 +0000
Subject: [PATCH] Will this never end?    - connection parameter tweaking    -
 a bit of whitespace here and there    - use UEXPECTF if need be

---
 ext/mysqli/tests/050.phpt |  6 ++---
 ext/mysqli/tests/051.phpt |  8 +++---
 ext/mysqli/tests/052.phpt |  2 +-
 ext/mysqli/tests/053.phpt |  2 +-
 ext/mysqli/tests/054.phpt |  2 +-
 ext/mysqli/tests/055.phpt |  2 +-
 ext/mysqli/tests/056.phpt |  2 +-
 ext/mysqli/tests/057.phpt | 55 ++++++++++++++++++++++++++++++++-------
 ext/mysqli/tests/058.phpt | 30 +++++++++++++++------
 ext/mysqli/tests/059.phpt | 15 ++++++-----
 10 files changed, 89 insertions(+), 35 deletions(-)

diff --git a/ext/mysqli/tests/050.phpt b/ext/mysqli/tests/050.phpt
index 5f923ccf34..1e3fd6403a 100644
--- a/ext/mysqli/tests/050.phpt
+++ b/ext/mysqli/tests/050.phpt
@@ -1,15 +1,15 @@
 --TEST--
-non freed statement test 
+non freed statement test
 --SKIPIF--
 <?php require_once('skipif.inc'); ?>
 --FILE--
 <?php
 	include "connect.inc";
-	
+
 	/************************
 	 * non freed stamement
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$stmt = mysqli_prepare($link, "SELECT CURRENT_USER()");
 	mysqli_execute($stmt);
diff --git a/ext/mysqli/tests/051.phpt b/ext/mysqli/tests/051.phpt
index ef378757f1..72b8618319 100644
--- a/ext/mysqli/tests/051.phpt
+++ b/ext/mysqli/tests/051.phpt
@@ -1,15 +1,15 @@
 --TEST--
-free statement after close 
+free statement after close
 --SKIPIF--
 <?php require_once('skipif.inc'); ?>
 --FILE--
 <?php
 	include "connect.inc";
-	
+
 	/************************
-	 * free statement after close 
+	 * free statement after close
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$stmt1 = mysqli_prepare($link, "SELECT CURRENT_USER()");
 	mysqli_execute($stmt1);
diff --git a/ext/mysqli/tests/052.phpt b/ext/mysqli/tests/052.phpt
index 3fa5dc8f17..24b9db94bd 100644
--- a/ext/mysqli/tests/052.phpt
+++ b/ext/mysqli/tests/052.phpt
@@ -9,7 +9,7 @@ call statement after close
 	/************************
 	 * statement call  after close 
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$stmt2 = mysqli_prepare($link, "SELECT CURRENT_USER()");
 
diff --git a/ext/mysqli/tests/053.phpt b/ext/mysqli/tests/053.phpt
index 99148c7e80..5f1de890b5 100644
--- a/ext/mysqli/tests/053.phpt
+++ b/ext/mysqli/tests/053.phpt
@@ -9,7 +9,7 @@ not freed resultset
 	/************************
 	 * non freed resultset 
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$result = mysqli_query($link, "SELECT CURRENT_USER()");
 	mysqli_close($link);
diff --git a/ext/mysqli/tests/054.phpt b/ext/mysqli/tests/054.phpt
index 727b87ef8e..756c008fc9 100644
--- a/ext/mysqli/tests/054.phpt
+++ b/ext/mysqli/tests/054.phpt
@@ -9,7 +9,7 @@ free resultset after close
 	/************************
 	 * free resultset after close 
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$result1 = mysqli_query($link, "SELECT CURRENT_USER()");
 	mysqli_close($link);
diff --git a/ext/mysqli/tests/055.phpt b/ext/mysqli/tests/055.phpt
index e650dbcecd..0c30a31304 100644
--- a/ext/mysqli/tests/055.phpt
+++ b/ext/mysqli/tests/055.phpt
@@ -9,7 +9,7 @@ free nothing
 	/************************
 	 * don't free anything 
 	 ************************/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
 	$result2 = mysqli_query($link, "SELECT CURRENT_USER()");
 	$stmt2 = mysqli_prepare($link, "SELECT CURRENT_USER()");
diff --git a/ext/mysqli/tests/056.phpt b/ext/mysqli/tests/056.phpt
index cc5c32fc60..e723c6158a 100644
--- a/ext/mysqli/tests/056.phpt
+++ b/ext/mysqli/tests/056.phpt
@@ -13,7 +13,7 @@ extend mysqli
 	}
 
 	$foo = new foobar();
-	$foo->connect($host, $user, $passwd);
+	$foo->connect($host, $user, $passwd, $db, $port, $socket);
 	$foo->close();
 	printf("%s\n", $foo->test());
 ?>
diff --git a/ext/mysqli/tests/057.phpt b/ext/mysqli/tests/057.phpt
index 6f2f797021..063126560a 100644
--- a/ext/mysqli/tests/057.phpt
+++ b/ext/mysqli/tests/057.phpt
@@ -5,14 +5,14 @@ mysqli_get_metadata
 --FILE--
 <?php
 	include "connect.inc";
-	
+
 	/*** test mysqli_connect 127.0.0.1 ***/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
-	mysqli_select_db($link, "test");
+	mysqli_select_db($link, $db);
 
-  	mysqli_query($link,"DROP TABLE IF EXISTS test_store_result");
-  	mysqli_query($link,"CREATE TABLE test_store_result (a int)");
+	mysqli_query($link,"DROP TABLE IF EXISTS test_store_result");
+	mysqli_query($link,"CREATE TABLE test_store_result (a int)");
 
 	mysqli_query($link, "INSERT INTO test_store_result VALUES (1),(2),(3)");
 
@@ -26,6 +26,15 @@ mysqli_get_metadata
 	}
 	mysqli_stmt_close($stmt);
 
+	/* now we should try mysqli_stmt_reset() */
+	$stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
+	var_dump(mysqli_execute($stmt));
+	var_dump(mysqli_stmt_reset($stmt));
+	var_dump($stmt = mysqli_prepare($link, "SELECT * FROM test_store_result"));
+	var_dump(mysqli_execute($stmt));
+	var_dump($stmt = @mysqli_prepare($link, "SELECT * FROM test_store_result"), mysqli_error($link));
+	var_dump(mysqli_stmt_reset($stmt));
+
 	$stmt = mysqli_prepare($link, "SELECT * FROM test_store_result");
 	mysqli_execute($stmt);
 	$result1 = mysqli_get_metadata($stmt);
@@ -37,18 +46,46 @@ mysqli_get_metadata
 	if ($result = mysqli_query($link, "SELECT * FROM test_store_result")) {
 		$row = mysqli_fetch_row($result);
 		mysqli_free_result($result);
-	} 
-	
+	}
 
-	var_dump($row);	
+	var_dump($row);
 
 	mysqli_free_result($result1);
 	mysqli_stmt_close($stmt);
 	mysqli_close($link);
+	echo "done!";
 ?>
 --EXPECTF--
+bool(true)
+bool(true)
+object(mysqli_stmt)#%d (%d) {
+}
+bool(true)
+bool(false)
+string(0) ""
+
+Warning: mysqli_stmt_reset() expects parameter 1 to be mysqli_stmt, boolean given in %s on line %d
+NULL
+Rows: 3
+array(1) {
+  [0]=>
+  string(1) "1"
+}
+done!
+--UEXPECTF--
+bool(true)
+bool(true)
+object(mysqli_stmt)#%d (%d) {
+}
+bool(true)
+bool(false)
+unicode(0) ""
+
+Warning: mysqli_stmt_reset() expects parameter 1 to be mysqli_stmt, boolean given in %s on line %d
+NULL
 Rows: 3
 array(1) {
   [0]=>
-  %s(1) "1"
+  unicode(1) "1"
 }
+done!
\ No newline at end of file
diff --git a/ext/mysqli/tests/058.phpt b/ext/mysqli/tests/058.phpt
index 2c08090d99..b602b55cd5 100644
--- a/ext/mysqli/tests/058.phpt
+++ b/ext/mysqli/tests/058.phpt
@@ -5,17 +5,17 @@ multiple binds
 --FILE--
 <?php
 	include "connect.inc";
-	
+
 	/*** test mysqli_connect 127.0.0.1 ***/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
-	mysqli_select_db($link, "test");
+	mysqli_select_db($link, $db);
 
-  	mysqli_query($link,"DROP TABLE IF EXISTS mbind");
-  	mysqli_query($link,"CREATE TABLE mbind (a int, b varchar(10))");
+	mysqli_query($link,"DROP TABLE IF EXISTS mbind");
+	mysqli_query($link,"CREATE TABLE mbind (a int, b varchar(10))");
 
 	$stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?,?)");
-	
+
 	mysqli_bind_param($stmt, "is", $a, $b);
 
 	$a = 1;
@@ -43,15 +43,29 @@ multiple binds
 	var_dump((array($e,$f,$g,$h)));
 
 	mysqli_close($link);
+	print "done!";
 ?>
 --EXPECTF--
 array(4) {
   [0]=>
   int(1)
   [1]=>
-  %s(3) "foo"
+  string(3) "foo"
+  [2]=>
+  int(2)
+  [3]=>
+  string(3) "bar"
+}
+done!
+--UEXPECTF--
+array(4) {
+  [0]=>
+  int(1)
+  [1]=>
+  unicode(3) "foo"
   [2]=>
   int(2)
   [3]=>
-  %s(3) "bar"
+  unicode(3) "bar"
 }
+done!
\ No newline at end of file
diff --git a/ext/mysqli/tests/059.phpt b/ext/mysqli/tests/059.phpt
index 98149f303a..8ad4d86a08 100644
--- a/ext/mysqli/tests/059.phpt
+++ b/ext/mysqli/tests/059.phpt
@@ -5,19 +5,19 @@ sqlmode + bind
 --FILE--
 <?php
 	include "connect.inc";
-	
+
 	/*** test mysqli_connect 127.0.0.1 ***/
-	$link = mysqli_connect($host, $user, $passwd);
+	$link = mysqli_connect($host, $user, $passwd, $db, $port, $socket);
 
-	mysqli_select_db($link, "test");
+	mysqli_select_db($link, $db);
 
 	mysqli_query($link, "SET SQL_MODE='PIPES_AS_CONCAT'");
 
-  	mysqli_query($link,"DROP TABLE IF EXISTS mbind");
-  	mysqli_query($link,"CREATE TABLE mbind (b varchar(25))");
+	mysqli_query($link,"DROP TABLE IF EXISTS mbind");
+	mysqli_query($link,"CREATE TABLE mbind (b varchar(25))");
 
 	$stmt = mysqli_prepare($link, "INSERT INTO mbind VALUES (?||?)");
-	
+
 	mysqli_bind_param($stmt, "ss", $a, $b);
 
 	$a = "foo";
@@ -36,8 +36,11 @@ sqlmode + bind
 	var_dump($e);
 
 	mysqli_close($link);
+	print "done!";
 ?>
 --EXPECT--
 string(6) "foobar"
+done!
 --UEXPECT--
 unicode(6) "foobar"
+done!
\ No newline at end of file
-- 
2.40.0