mysqli_set_opt_numeric_and_datetime_as_unicode.phpt

linux下安装不上mysql5与php5的可用此关联

--TEST--
mysqli_set_opt() - MYSQLI_OPT_NUMERIC_AND_DATETIME_AS_UNICODE
--SKIPIF--
<?php 
require_once('skipif.inc');
require_once('skipifemb.inc'); 
if (!function_exists('unicode_semantics'))
	die("skip needs PHP 6");
if (!unicode_semantics())
	die("skip works only in unicode mode");	
?>
--FILE--
<?php
	include "connect.inc";
	include "table.inc";
	
	if (true !== ($tmp = mysqli_set_opt($link, MYSQLI_OPT_NUMERIC_AND_DATETIME_AS_UNICODE, 1)))
		printf("[001] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);

	if (!mysqli_query($link, 'ALTER TABLE test ADD col_date DATE, 
											ADD col_time TIME, 
											ADD col_timestamp TIMESTAMP, 
											ADD col_datetime DATETIME'))
		printf("[002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	
	if (!mysqli_query($link, 'UPDATE test SET col_date = NOW(), 
										col_time = NOW(), 
										col_timestamp = NOW(),
										col_datetime = NOW()'))
		printf("[003] [%d] %s\n", mysqli_errno($link), mysqli_error($link));

	if (!$res = mysqli_query($link, 'SELECT * FROM test'))
		printf("[004] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (!$row = mysqli_fetch_assoc($res))
		printf("[005] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (!is_unicode($row['col_time']) || '' == $row['col_time'])
		printf("[006] Expecting unicode/any, got %s/%s\n", gettype($row['col_time']), $row['col_time']);

	if (!is_unicode($row['col_timestamp']) || '' == $row['col_timestamp'])
		printf("[007] Expecting unicode/any, got %s/%s\n", gettype($row['col_timestamp']), $row['col_timestamp']);

	if (!is_unicode($row['col_datetime']) || '' == $row['col_datetime'])
		printf("[008] Expecting unicode/any, got %s/%s\n", gettype($row['col_datetime']), $row['col_datetime']);

	if (!is_unicode($row['col_date']) || '' == $row['col_date'])
		printf("[009] Expecting unicode/any, got %s/%s\n", gettype($row['col_date']), $row['col_date']);

	mysqli_free_result($res);
		
	if (true !== ($tmp = mysqli_set_opt($link, MYSQLI_OPT_NUMERIC_AND_DATETIME_AS_UNICODE, 0)))
		printf("[010] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
	
	if (!$res = mysqli_query($link, 'SELECT * FROM test'))
		printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (!$row = mysqli_fetch_assoc($res))
		printf("[012] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (is_unicode($row['col_time']) || '' == $row['col_time'])
		printf("[013] Expecting (binary) string/any, got %s/%s\n", gettype($row['col_time']), $row['col_time']);

	if (is_unicode($row['col_timestamp']) || '' == $row['col_timestamp'])
		printf("[014] Expecting (binary) string/any, got %s/%s\n", gettype($row['col_timestamp']), $row['col_timestamp']);

	if (is_unicode($row['col_datetime']) || '' == $row['col_datetime'])
		printf("[015] Expecting (binary) string/any, got %s/%s\n", gettype($row['col_datetime']), $row['col_datetime']);

	if (is_unicode($row['col_date']) || '' == $row['col_date'])
		printf("[016] Expecting (binary) string/any, got %s/%s\n", gettype($row['col_date']), $row['col_date']);
		
	mysqli_free_result($res);
	
	if (true !== ($tmp = mysqli_set_opt($link, MYSQLI_OPT_NUMERIC_AND_DATETIME_AS_UNICODE, 1)))
		printf("[017] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);

	if (!$res = mysqli_query($link, 'SELECT * FROM test'))
		printf("[018] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (!$row = mysqli_fetch_assoc($res))
		printf("[019] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
		
	if (!is_unicode($row['col_time']) || '' == $row['col_time'])
		printf("[020] Expecting unicode/any, got %s/%s\n", gettype($row['col_time']), $row['col_time']);
		
	mysqli_free_result($res);
	
	if (!$stmt = mysqli_stmt_init($link))
		printf("[021] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	
	$col_date = $col_time = $col_datetime = $col_timestamp = null;
	if (!mysqli_stmt_prepare($stmt, 'SELECT col_date, col_time, col_datetime, col_timestamp FROM test') ||
		!mysqli_stmt_execute($stmt) || 
		!mysqli_stmt_bind_result($stmt, $col_date, $col_time, $col_datetime, $col_timestamp) ||
		!mysqli_stmt_fetch($stmt))
		printf("[022] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
	
	if (!is_unicode($col_date) || '' == $col_date)
		printf("[023] Expecting unicode/any, got %s/%s\n", gettype($col_date), $col_date);

	if (!is_unicode($col_time) || '' == $col_time)
		printf("[024] Expecting unicode/any, got %s/%s\n", gettype($col_time), $col_time);

	if (!is_unicode($col_datetime) || '' == $col_datetime)
		printf("[025] Expecting unicode/any, got %s/%s\n", gettype($col_datetime), $col_datetime);

	if (!is_unicode($col_timestamp) || '' == $col_timestamp)
		printf("[026] Expecting unicode/any, got %s/%s\n", gettype($col_timestamp), $col_timestamp);		

	mysqli_stmt_close($stmt);
	
	if (true !== ($tmp = mysqli_set_opt($link, MYSQLI_OPT_NUMERIC_AND_DATETIME_AS_UNICODE, 0)))
		printf("[027] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
		
	if (!$stmt = mysqli_stmt_init($link))
		printf("[028] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	
	$col_date = $col_time = $col_datetime = $col_timestamp = null;
	if (!mysqli_stmt_prepare($stmt, 'SELECT col_date, col_time, col_datetime, col_timestamp FROM test') ||
		!mysqli_stmt_execute($stmt) || 
		!mysqli_stmt_bind_result($stmt, $col_date, $col_time, $col_datetime, $col_timestamp) ||
		!mysqli_stmt_fetch($stmt))
		printf("[029] [%d] %s\n", mysqli_stmt_errno($stmt), mysqli_stmt_error($stmt));
	
	if (is_unicode($col_date) || '' == $col_date)
		printf("[030] Expecting (binary) string/any, got %s/%s\n", gettype($col_date), $col_date);

	if (is_unicode($col_time) || '' == $col_time)
		printf("[031] Expecting (binary) string/any, got %s/%s\n", gettype($col_time), $col_time);

	if (is_unicode($col_datetime) || '' == $col_datetime)
		printf("[032] Expecting (binary) string/any, got %s/%s\n", gettype($col_datetime), $col_datetime);

	if (is_unicode($col_timestamp) || '' == $col_timestamp)
		printf("[033] Expecting (binary) string/any, got %s/%s\n", gettype($col_timestamp), $col_timestamp);		

	mysqli_stmt_close($stmt);

	mysqli_close($link);
	print "done!";
?>
--EXPECTF--
done!