Return to 003.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: mysql_fetch_object
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10: include_once('connect.inc');
                     11: 
                     12: class class24 {
                     13:        function __construct() {
                     14:                echo __METHOD__ . "\n";
                     15:        }
                     16: }
                     17: 
                     18: $data = array("one", "two", "three");
                     19: 
                     20: if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
                     21:        printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     22:                $host, $user, $db, $port, $socket);
                     23: 
                     24: if (!mysql_query('DROP TABLE IF EXISTS test', $link))
                     25:        printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     26: 
                     27: if (!mysql_query("CREATE TABLE test(a varchar(10))", $link))
                     28:        printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     29: 
                     30: foreach ($data as $str) {
                     31:        if (!mysql_query(sprintf("INSERT INTO test VALUES('%s')", $str), $link))
                     32:                printf("[004 - %s] [%d] %s\n", $str, mysql_errno($link), mysql_error($link));
                     33: }
                     34: 
                     35: echo "==stdClass==\n";
                     36: if (!$res = mysql_query("SELECT a FROM test", $link))
                     37:        printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     38: 
                     39: while ($obj = mysql_fetch_object($res)) {
                     40:        var_dump($obj);
                     41: }
                     42: mysql_free_result($res);
                     43: 
                     44: echo "==class24==\n";
                     45: if (!$res = mysql_query("SELECT a FROM test", $link))
                     46:     printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     47: 
                     48: while ($obj = mysql_fetch_object($res, 'class24')) {
                     49:        var_dump($obj);
                     50: }
                     51: mysql_free_result($res);
                     52: mysql_close($link);
                     53: print "done!";
                     54: ?>
                     55: --CLEAN--
                     56: <?php
                     57: require_once("clean_table.inc");
                     58: ?>
                     59: --EXPECTF--
                     60: ==stdClass==
                     61: object(stdClass)#%d (1) {
                     62:   [%u|b%"a"]=>
                     63:   %unicode|string%(3) "one"
                     64: }
                     65: object(stdClass)#%d (1) {
                     66:   [%u|b%"a"]=>
                     67:   %unicode|string%(3) "two"
                     68: }
                     69: object(stdClass)#%d (1) {
                     70:   [%u|b%"a"]=>
                     71:   %unicode|string%(5) "three"
                     72: }
                     73: ==class24==
                     74: class24::__construct
                     75: object(class24)#%d (1) {
                     76:   [%u|b%"a"]=>
                     77:   %unicode|string%(3) "one"
                     78: }
                     79: class24::__construct
                     80: object(class24)#%d (1) {
                     81:   [%u|b%"a"]=>
                     82:   %unicode|string%(3) "two"
                     83: }
                     84: class24::__construct
                     85: object(class24)#%d (1) {
                     86:   [%u|b%"a"]=>
                     87:   %unicode|string%(5) "three"
                     88: }
                     89: done!