helly Sun Jan 11 21:31:09 2004 EDT
Added files:
/php-src/ext/mysql/tests .cvsignore 001.phpt 002.phpt connect.inc
skipif.inc
Log:
Add some tests
Index: php-src/ext/mysql/tests/.cvsignore
+++ php-src/ext/mysql/tests/.cvsignore
phpt.*
*.diff
*.log
*.exp
*.out
*.php
Index: php-src/ext/mysql/tests/001.phpt
+++ php-src/ext/mysql/tests/001.phpt
--TEST--
mysql connect
--FILE--
<?php
include 'connect.inc';
$test = '';
/*** test mysql_connect 127.0.0.1 ***/
$db = mysql_connect('127.0.0.1', $user, $passwd);
$test .= ($db) ? '1' : '0';
mysql_close($db);
/*** test mysql_connect localhost ***/
$db = mysql_connect($host, $user, $passwd);
$test .= ($db) ? '1' : '0';
mysql_close($db);
/*** test mysql_connect localhost:port ***/
$db = mysql_connect($host, $user, $passwd, '', 3306);
$test .= ($db) ? '1' : '0';
mysql_close($db);
var_dump($test);
?>
--EXPECT--
string(3) "111"
Index: php-src/ext/mysql/tests/002.phpt
+++ php-src/ext/mysql/tests/002.phpt
--TEST--
mysql_fetch_array
--SKIPIF--
<?php include 'skipif.inc'; ?>
--FILE--
<?php
include 'connect.inc';
$db = mysql_connect($host, $user, $passwd);
var_dump($db);
var_dump(mysql_select_db('test'));
var_dump(mysql_query('DROP TABLE IF EXISTS test'));
var_dump(mysql_query('CREATE TABLE test(col1 int PRIMARY KEY, col2 varchar(50), col3
char(5))'));
var_dump(mysql_query("INSERT INTO test(col1, col2, col3) VALUES(1, 'foo', 'bar'),(2,
'foo', 'bar')"));
var_dump($res = mysql_query('SELECT col1, col2, col3 FROM test ORDER BY col1 ASC'));
while ($data = mysql_fetch_array($res, MYSQL_ASSOC)) {
var_dump($data);
}
mysql_close($db);
?>
--EXPECTF--
resource(%d) of type (mysql link)
bool(true)
bool(true)
bool(true)
bool(true)
resource(%d) of type (mysql result)
array(3) {
["col1"]=>
string(1) "1"
["col2"]=>
string(3) "foo"
["col3"]=>
string(3) "bar"
}
array(3) {
["col1"]=>
string(1) "2"
["col2"]=>
string(3) "foo"
["col3"]=>
string(3) "bar"
}
Index: php-src/ext/mysql/tests/connect.inc
+++ php-src/ext/mysql/tests/connect.inc
<?php
/* default values are localhost, root and empty password
Change the values if you use another configuration */
$host = "localhost";
$user = "root";
$passwd = "";
?>
Index: php-src/ext/mysql/tests/skipif.inc
+++ php-src/ext/mysql/tests/skipif.inc
<?php
include 'connect.inc';
$link = @mysql_connect($host, $user, $passwd);
if (!$link) die('skip canot connect');
mysql_close($link);
?>
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
