cvs: php-src /ext/mysql/tests .cvsignore 001.phpt 002.phpt connect.inc skipif.inc

From: Date: Mon, 12 Jan 2004 02:31:09 +0000
Subject: cvs: php-src /ext/mysql/tests .cvsignore 001.phpt 002.phpt connect.inc skipif.inc
Groups: php.cvs 
Request: Send a blank email to php-cvs+get-25613@lists.php.net to get a copy of this message
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); ?>

« previous php.cvs (#25613) next »