File:  [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysql / tests / mysql_create_db.phpt
Revision 1.1.1.1 (vendor branch): download - view: text, annotated - select for diffs - revision graph
Tue Feb 21 23:47:58 2012 UTC (12 years, 4 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, v5_3_10, HEAD
php

--TEST--
mysql_create_db()
--SKIPIF--
<?php
require_once('skipif.inc');
if (!function_exists('mysql_create_db'))
	die("Skip mysql_create_db() exists only in old versions of the libmysql.");
?>
--FILE--
<?php
include "connect.inc";

$link   = NULL;
$tmp    = null;

if (false !== ($tmp = mysql_create_db()))
	printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);

if (false !== ($tmp = mysql_create_db($link, $link, $link)))
	printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);

if ($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
	printf("[003] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n",
		$host, $user . 'unknown_really', $db, $port, $socket);

if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link))
	die(sprintf("[004] Cannot create database, aborting test, [%d] %s\n", mysql_errno($link), mysql_error($link)));

if (!mysql_query("DROP DATABASE mysqlcreatedb", $link))
	printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));

if (true !== ($tmp = mysql_create_db("mysqlcreatedb", $link)))
	printf("[006] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));

if (false !== ($tmp = mysql_create_db("mysqlcreatedb", $link)))
	printf("[007] Expecting boolean/false, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));

if (!mysql_query("DROP DATABASE mysqlcreatedb", $link))
	printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link));

print "done!";
?>
--CLEAN--
<?php
require_once('connect.inc');
if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
	printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
		$host, $user, $db, $port, $socket);

if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link))
	printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));

mysql_close($link);
?>
--EXPECTF--
done!

FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>