Return to mysql_error.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / mysql / tests

Annotation of embedaddon/php/ext/mysql/tests/mysql_error.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysql_error()
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: include "connect.inc";
                     11: 
                     12: $tmp    = NULL;
                     13: $link   = NULL;
                     14: 
                     15: if (false !== ($tmp = @mysql_error()))
                     16:        printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
                     17: 
                     18: if (NULL !== ($tmp = @mysql_error($link)))
                     19:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     20: 
                     21: if (!is_null($tmp = @mysql_error($link, 'too many args')))
                     22:        printf("[002b] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     23: 
                     24: if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) {
                     25:        printf("[003] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     26:                $host, $user, $db, $port, $socket);
                     27: }
                     28: 
                     29: $tmp = mysql_error($link);
                     30: if (!is_string($tmp) || ('' !== $tmp))
                     31:        printf("[004] Expecting string/empty, got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
                     32: 
                     33: if (!mysql_query('DROP TABLE IF EXISTS test', $link)) {
                     34:        printf("[005] Failed to drop old test table: [%d] %s\n", mysql_errno($link), mysql_error($link));
                     35: }
                     36: 
                     37: mysql_query('SELECT * FROM test', $link);
                     38: $tmp = mysql_error($link);
                     39: if (!is_string($tmp) || !preg_match("/Table '\w*\.test' doesn't exist/su", $tmp))
                     40:        printf("[006] Expecting string/[Table... doesn't exit], got %s/%s. [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
                     41: 
                     42: if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($tmp)) {
                     43:        printf("[007] Expecting Unicode error message!\n");
                     44:        var_inspect($tmp);
                     45: }
                     46: 
                     47: mysql_close($link);
                     48: 
                     49: var_dump(mysql_error($link));
                     50: 
                     51: if ($link = @mysql_connect($host . '_unknown', $user . '_unknown', $passwd, true)) {
                     52:        printf("[008] Can connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     53:                $host . '_unknown', $user . '_unknown', $db, $port, $socket);
                     54: }
                     55: if ('' == mysql_error())
                     56:        printf("[009] Connect error should have been set\n");
                     57: 
                     58: print "done!";
                     59: ?>
                     60: --CLEAN--
                     61: <?php
                     62: require_once("clean_table.inc");
                     63: ?>
                     64: --EXPECTF--
                     65: Warning: mysql_error(): %d is not a valid MySQL-Link resource in %s on line %d
                     66: bool(false)
                     67: done!