[PHP-CVS] cvs: php4 /ext/mysqli/tests 036.phpt 037.phpt 038.phpt 039.phpt 040.phpt 041.phpt

[Georg Richter]

georg           Wed Feb 12 05:40:19 2003 EDT

  Added files:                 
    /php4/ext/mysqli/tests      036.phpt 037.phpt 038.phpt 039.phpt 040.phpt 
                                041.phpt 
  Log:
  added new tests
  
  

Index: php4/ext/mysqli/tests/036.phpt
+++ php4/ext/mysqli/tests/036.phpt
--TEST--
function test: mysqli_insert_id()
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "DROP TABLE IF EXISTS t036");

        mysqli_query($link, "CREATE TABLE t036 (a bigint not null auto_increment 
primary key, b varchar(10))");


        mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo1')");
        $test[] = mysqli_insert_id($link);

        /* we have to insert more values, cause lexer sets auto_increment to max_int
           see mysql bug #54. So we don't check for the value, only for type (which 
must
           be type string) 
        */      
           
        mysqli_query($link, "ALTER TABLE t036 AUTO_INCREMENT=9999999999999998");
        mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo2')");
        mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo3')");
        mysqli_query($link, "INSERT INTO t036 (b) VALUES ('foo4')");
        $x = mysqli_insert_id($link);
        $test[] = is_string($x);
        
        var_dump($test);

        mysqli_close($link);
?>
--EXPECT--
array(2) {
  [0]=>
  int(1)
  [1]=>
  bool(true)
}

Index: php4/ext/mysqli/tests/037.phpt
+++ php4/ext/mysqli/tests/037.phpt
--TEST--
function test: mysqli_field_count()
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "DROP TABLE IF EXISTS test_result");

        mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10))");

        mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");
        $ir[] = mysqli_field_count($link);

        mysqli_real_query($link, "SELECT * FROM test_result");
        $ir[] = mysqli_field_count($link);
        
        
        var_dump($ir);

        mysqli_close($link);
?>
--EXPECT--
array(2) {
  [0]=>
  int(0)
  [1]=>
  int(2)
}

Index: php4/ext/mysqli/tests/038.phpt
+++ php4/ext/mysqli/tests/038.phpt
--TEST--
function test: mysqli_num_fields()
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "DROP TABLE IF EXISTS test_result");

        mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10))");

        mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");

        mysqli_real_query($link, "SELECT * FROM test_result");
        if (mysqli_field_count($link)) {
                $result = mysqli_store_result($link);
                $num = mysqli_num_fields($result);
                mysqli_free_result($result);
        }

        var_dump($num);

        mysqli_close($link);
?>
--EXPECT--
int(2)

Index: php4/ext/mysqli/tests/039.phpt
+++ php4/ext/mysqli/tests/039.phpt
--TEST--
function test: mysqli_num_fields() 2
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_real_query($link, "SHOW VARIABLES");

        if (mysqli_field_count($link)) {
                $result = mysqli_store_result($link);
                $num = mysqli_num_fields($result);
                mysqli_free_result($result);
        }

        var_dump($num);

        mysqli_close($link);
?>
--EXPECT--
int(2)

Index: php4/ext/mysqli/tests/040.phpt
+++ php4/ext/mysqli/tests/040.phpt
--TEST--
function test: mysqli_num_rows()
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "DROP TABLE IF EXISTS test_result");

        mysqli_query($link, "CREATE TABLE test_result (a int, b varchar(10))");

        mysqli_query($link, "INSERT INTO test_result VALUES (1, 'foo')");

        mysqli_real_query($link, "SELECT * FROM test_result");
        if (mysqli_field_count($link)) {
                $result = mysqli_store_result($link);
                $num = mysqli_num_rows($result);
                mysqli_free_result($result);
        }

        var_dump($num);

        mysqli_close($link);
?>
--EXPECT--
int(1)

Index: php4/ext/mysqli/tests/041.phpt
+++ php4/ext/mysqli/tests/041.phpt
--TEST--
function test: mysqli_warning_count()
--FILE--
<?php

        include "connect.inc";
        
        /*** test mysqli_connect 127.0.0.1 ***/
        $link = mysqli_connect("localhost", $user, $passwd);

        mysqli_select_db($link, "test");

        mysqli_query($link, "DROP TABLE IF EXISTS test_warnings");

        mysqli_query($link, "CREATE TABLE test_warnings (a int not null");

        mysqli_query($link, "INSERT INTO test_warnings VALUES (1),(2),(NULL)");
        $num = mysqli_warning_count($link);
        var_dump($num);

        mysqli_close($link);
?>
--EXPECT--
int(1)



-- 
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php