[BACK]Return to mysqli_query_iterators.phpt CVS log [TXT] [DIR] Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests
File:  [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysqli / tests / mysqli_query_iterators.phpt
Revision 1.1.1.1 (vendor branch): download - view: text, annotated - select for diffs - revision graph
Tue May 29 12:34:41 2012 UTC (12 years, 10 months ago) by misho
Branches: php, MAIN
CVS tags: v5_4_3elwix, v5_4_29p0, v5_4_29, v5_4_20p0, v5_4_20, v5_4_17p0, v5_4_17, HEAD
php 5.4.3+patches

--TEST--
mysqli iterators
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');
?>
--FILE--
<?php
	require_once("connect.inc");

	$tmp    = NULL;
	$link   = NULL;

	require('table.inc');

	echo "--- Testing default ---\n";
	if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id")))
		printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	else {
		foreach ($res as $row) {
			var_dump($row);
		}
		echo "======\n";
		foreach ($res as $row) {
			var_dump($row);
		}
		mysqli_free_result($res);
		foreach ($res as $row) {
			var_dump($row);
		}
	}
	echo "--- Testing USE_RESULT ---\n";
	if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_USE_RESULT)))
		printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	else {
		foreach ($res as $row) {
			var_dump($row);
		}
		echo "======\n";
		foreach ($res as $row) {
			var_dump($row);
		}
		mysqli_free_result($res);
	}

	echo "--- Testing STORE_RESULT ---\n";
	if (!is_object($res = mysqli_query($link, "SELECT id FROM test ORDER BY id", MYSQLI_STORE_RESULT)))
		printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	else {
		foreach ($res as $row) {
			var_dump($row);
		}
		echo "======\n";
		foreach ($res as $row) {
			var_dump($row);
		}
		mysqli_free_result($res);
	}

	mysqli_close($link);

	print "done!";
?>
--CLEAN--
<?php
	require_once("clean_table.inc");
?>
--EXPECTF--
--- Testing default ---
array(1) {
  ["id"]=>
  string(1) "1"
}
array(1) {
  ["id"]=>
  string(1) "2"
}
array(1) {
  ["id"]=>
  string(1) "3"
}
array(1) {
  ["id"]=>
  string(1) "4"
}
array(1) {
  ["id"]=>
  string(1) "5"
}
array(1) {
  ["id"]=>
  string(1) "6"
}
======
array(1) {
  ["id"]=>
  string(1) "1"
}
array(1) {
  ["id"]=>
  string(1) "2"
}
array(1) {
  ["id"]=>
  string(1) "3"
}
array(1) {
  ["id"]=>
  string(1) "4"
}
array(1) {
  ["id"]=>
  string(1) "5"
}
array(1) {
  ["id"]=>
  string(1) "6"
}

Warning: main(): Couldn't fetch mysqli_result in %s on line %d
--- Testing USE_RESULT ---
array(1) {
  ["id"]=>
  string(1) "1"
}
array(1) {
  ["id"]=>
  string(1) "2"
}
array(1) {
  ["id"]=>
  string(1) "3"
}
array(1) {
  ["id"]=>
  string(1) "4"
}
array(1) {
  ["id"]=>
  string(1) "5"
}
array(1) {
  ["id"]=>
  string(1) "6"
}
======

Warning: main(): Data fetched with MYSQLI_USE_RESULT can be iterated only once in %s on line %d
--- Testing STORE_RESULT ---
array(1) {
  ["id"]=>
  string(1) "1"
}
array(1) {
  ["id"]=>
  string(1) "2"
}
array(1) {
  ["id"]=>
  string(1) "3"
}
array(1) {
  ["id"]=>
  string(1) "4"
}
array(1) {
  ["id"]=>
  string(1) "5"
}
array(1) {
  ["id"]=>
  string(1) "6"
}
======
array(1) {
  ["id"]=>
  string(1) "1"
}
array(1) {
  ["id"]=>
  string(1) "2"
}
array(1) {
  ["id"]=>
  string(1) "3"
}
array(1) {
  ["id"]=>
  string(1) "4"
}
array(1) {
  ["id"]=>
  string(1) "5"
}
array(1) {
  ["id"]=>
  string(1) "6"
}
done!
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>