Return to mysql_db_query.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: mysql_db_query()
                      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: // NOTE: this function is deprecated. We do only the most necessary
                     13: // to test it. We don't test all aspects of the documented behaviour.
                     14: 
                     15: $tmp    = NULL;
                     16: $link   = NULL;
                     17: 
                     18: if (NULL !== ($tmp = @mysql_db_query()))
                     19:        printf("[001] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
                     20: 
                     21: if (NULL !== ($tmp = @mysql_db_query($link)))
                     22:        printf("[002] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
                     23: 
                     24: if (NULL !== ($tmp = @mysql_db_query($link)))
                     25:        printf("[003] Expecting NULL/NULL, got %s/%s\n", gettype($tmp), $tmp);
                     26: 
                     27: require('table.inc');
                     28: if (!$res = @mysql_db_query($db, 'SELECT id, label FROM test ORDER BY id LIMIT 1', $link))
                     29:        printf("[004] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     30: 
                     31: $row = mysql_fetch_assoc($res);
                     32: if (1 != $row['id'])
                     33:        printf("[005] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']);
                     34: 
                     35: if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($row['label'])) {
                     36:        printf("[006] No unicode returned! [%d] %s\n", mysql_errno($link), mysql_error($link));
                     37:        var_inspect($row);
                     38: }
                     39: 
                     40: mysql_free_result($res);
                     41: 
                     42: 
                     43: if (!$res = @mysql_db_query($db, 'SELECT id, label FROM test ORDER BY id LIMIT 1'))
                     44:        printf("[007] [%d] %s\n", mysql_errno(), mysql_error());
                     45: 
                     46: $row = mysql_fetch_assoc($res);
                     47: if (1 != $row['id'])
                     48:        printf("[008] Expecting record 1/a, got record %s/%s\n", $row['id'], $row['label']);
                     49: 
                     50: if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($row['label'])) {
                     51:        printf("[009] No unicode returned! [%d] %s\n", mysql_errno(), mysql_error());
                     52:        var_inspect($row);
                     53: }
                     54: 
                     55: mysql_free_result($res);
                     56: mysql_close($link);
                     57: 
                     58: print "done!\n";
                     59: ?>
                     60: --CLEAN--
                     61: <?php
                     62: require_once("clean_table.inc");
                     63: ?>
                     64: --EXPECTF--
                     65: done!