File:  [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysql / tests / table.inc
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

<?PHP
require_once 'connect.inc';

// connect + select_db
if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
	printf("Cannot connect to the server using host=%s/%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
 	  $host, $myhost, $user, $db, $port, $socket);
	exit(1);
}

if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
	printf("Failed to drop old test table: [%d] %s\n", mysql_errno($link), mysql_error($link));
	exit(1);
}

if (!mysql_query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine, $link)) {
	printf("Failed to create test table: [%d] %s\n", mysql_errno($link), mysql_error($link));
	exit(1);
}

if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')", $link)) {
	printf("[%d] %s\n",  mysql_errno($link), mysql_error($link));
}
?>

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