Return to mysqli_report_wo_ps.phpt CVS log

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

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_report_wo_ps.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: mysqli_report()
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifemb.inc');
                      7: require_once('skipifconnectfailure.inc');
                      8: ?>
                      9: --FILE--
                     10: <?php
                     11:        require_once("connect.inc");
                     12: 
                     13:        $tmp    = NULL;
                     14:        $link   = NULL;
                     15: 
                     16:        if (NULL !== ($tmp = @mysqli_report()))
                     17:                printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     18: 
                     19:        if (true !== ($tmp = mysqli_report(-1)))
                     20:                printf("[002] Expecting boolean/true even for invalid flags, got %s/%s\n", gettype($tmp), $tmp);
                     21: 
                     22:        if (true !== ($tmp = mysqli_report(MYSQLI_REPORT_ERROR)))
                     23:                printf("[003] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
                     24: 
                     25:        if (true !== ($tmp = mysqli_report(MYSQLI_REPORT_STRICT)))
                     26:                printf("[004] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
                     27: 
                     28:        if (true !== ($tmp = mysqli_report(MYSQLI_REPORT_INDEX)))
                     29:                printf("[005] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
                     30: 
                     31:        if (true !== ($tmp = mysqli_report(MYSQLI_REPORT_ALL)))
                     32:                printf("[007] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
                     33: 
                     34:        if (true !== ($tmp = mysqli_report(MYSQLI_REPORT_OFF)))
                     35:                printf("[008] Expecting boolean/true, got %s/%s\n", gettype($tmp), $tmp);
                     36: 
                     37:        require('table.inc');
                     38: 
                     39:        /*
                     40:        Internal macro MYSQL_REPORT_ERROR
                     41:        */
                     42:        mysqli_report(MYSQLI_REPORT_ERROR);
                     43: 
                     44:        mysqli_multi_query($link, "BAR; FOO;");
                     45:        mysqli_query($link, "FOO");
                     46:        mysqli_change_user($link, "0123456789-10-456789-20-456789-30-456789-40-456789-50-456789-60-456789-70-456789-80-456789-90-456789", "password", $db);
                     47:        mysqli_kill($link, -1);
                     48: 
                     49:        // mysqli_ping() cannot be tested, because one would need to cause an error inside the C function to test it
                     50:        mysqli_real_query($link, "FOO");
                     51:        if (@mysqli_select_db($link, "Oh lord, let this be an unknown database name"))
                     52:                printf("[009] select_db should have failed\n");
                     53:        // mysqli_store_result() and mysqli_use_result() cannot be tested, because one would need to cause an error inside the C function to test it
                     54: 
                     55: 
                     56:        // Check that none of the above would have caused any error messages if MYSQL_REPORT_ERROR would
                     57:        // not have been set. If that would be the case, the test would be broken.
                     58:        mysqli_report(MYSQLI_REPORT_OFF);
                     59: 
                     60:        mysqli_multi_query($link, "BAR; FOO;");
                     61:        mysqli_query($link, "FOO");
                     62:        mysqli_change_user($link, "This might work if you accept anonymous users in your setup", "password", $db);
                     63:        mysqli_kill($link, -1);
                     64:        mysqli_real_query($link, "FOO");
                     65:        mysqli_select_db($link, "Oh lord, let this be an unknown database name");
                     66: 
                     67:        mysqli_report(MYSQLI_REPORT_OFF);
                     68:        mysqli_report(MYSQLI_REPORT_STRICT);
                     69: 
                     70:        try {
                     71: 
                     72:                if ($link = my_mysqli_connect($host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket))
                     73:                        printf("[010] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n",
                     74:                                $host, $user . 'unknown_really', $db, $port, $socket);
                     75:                mysqli_close($link);
                     76: 
                     77:        } catch (mysqli_sql_exception $e) {
                     78:                printf("[011] %s\n", $e->getMessage());
                     79:        }
                     80: 
                     81:        try {
                     82:                if (!$link = mysqli_init())
                     83:                        printf("[012] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     84: 
                     85:                if ($link = my_mysqli_real_connect($link, $host, $user . 'unknown_really', $passwd . 'non_empty', $db, $port, $socket))
                     86:                        printf("[013] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n",
                     87:                                $host, $user . 'unknown_really', $db, $port, $socket);
                     88:                mysqli_close($link);
                     89:        } catch (mysqli_sql_exception $e) {
                     90:                printf("[014] %s\n", $e->getMessage());
                     91:        }
                     92: 
                     93:        print "done!";
                     94: ?>
                     95: --CLEAN--
                     96: <?php
                     97:        require_once("clean_table.inc");
                     98: ?>
                     99: --EXPECTF--
                    100: Warning: mysqli_multi_query(): (%d/%d): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BAR; FOO' at line 1 in %s on line %d
                    101: 
                    102: Warning: mysqli_query(): (%d/%d): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOO' at line 1 in %s on line %d
                    103: 
                    104: Warning: mysqli_change_user(): (%d/%d): Access denied for user '%s'@'%s' (using password: %s) in %s on line %d
                    105: 
                    106: Warning: mysqli_kill(): processid should have positive value in %s on line %d
                    107: 
                    108: Warning: mysqli_real_query(): (%d/%d): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOO' at line 1 in %s on line %d
                    109: 
                    110: Warning: mysqli_kill(): processid should have positive value in %s on line %d
                    111: [011] Access denied for user '%s'@'%s' (using password: YES)
                    112: [014] Access denied for user '%s'@'%s' (using password: YES)
                    113: done!