mysqli_debug_control_string.phpt   [plain text]


--TEST--
mysqli_debug() - invalid debug control strings
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');

if (!function_exists('mysqli_debug'))
 	die("skip: mysqli_debug() not available");

if (!defined('MYSQLI_DEBUG_TRACE_ENABLED'))
	die("skip: can't say for sure if mysqli_debug works");

if (defined('MYSQLI_DEBUG_TRACE_ENABLED') && !MYSQLI_DEBUG_TRACE_ENABLED)
	die("skip: debug functionality not enabled");

if (!$IS_MYSQLND)
	die("SKIP Libmysql feature not sufficiently spec'd in MySQL C API documentation");
?>
--FILE--
<?php
	require_once('connect.inc');
	require_once('table.inc');

	function try_control_string($link, $control_string, $trace_file, $offset) {

		if (true !== ($tmp = mysqli_debug($control_string))) {
			printf("[%03d][control string '%s'] Expecting boolean/true, got %s/%s.\n",
				$offset + 1,
				$control_string,
				gettype($tmp),
				$tmp);
			return false;
		}

		if (!$res = mysqli_query($link, 'SELECT * FROM test')) {
			printf("[%03d][control string '%s'] [%d] %s.\n",
				$offset + 2,
				$control_string,
				mysqli_errno($link),
				mysqli_error($link));
			return false;
		}

		clearstatcache();
		if (!file_exists($trace_file)) {
			printf("[%03d][control string '%s'] Trace file has not been written.\n",
				$offset + 3,
				$control_string,
				gettype($tmp),
				$tmp);
			return false;
		}

		unlink($trace_file);
	}

	$trace_file = sprintf('%s%s%s', sys_get_temp_dir(), DIRECTORY_SEPARATOR, 'mysqli_debug_phpt.trace');
	try_control_string($link, 't:,,:o,' . $trace_file, $trace_file, 10);
	try_control_string($link, ':' . chr(0) . 'A,' . $trace_file, $trace_file, 20);
	try_control_string($link, 't:o,' . $trace_file . ':abc', $trace_file, 30);
	try_control_string($link, 't:o,' . $trace_file . ':ABC,123:b', $trace_file, 40);
	try_control_string($link, 't:ABC,123:b;:o,' . $trace_file, $trace_file, 50);
	try_control_string($link, 't:A;BC,123:b;:o,' . $trace_file, $trace_file, 60);
	try_control_string($link, 't:p:o,' . $trace_file, $trace_file, 70);
	try_control_string($link, 't:p,1,,2:o,' . $trace_file, $trace_file, 80);
	try_control_string($link, 't:z,1,,2:o,' . $trace_file, $trace_file, 90);#

	mysqli_close($link);
	print "done";
	if ($IS_MYSQLND)
		print "libmysql/DBUG package prints some debug info here."
?>
--EXPECTF--
[023][control string '%s'] Trace file has not been written.
done%s