Return to mysql_affected_rows.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: mysql_affected_rows()
                      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: include_once('setupdefault.inc');
                     12: 
                     13: $tmp    = NULL;
                     14: $link   = NULL;
                     15: 
                     16: if (0 !== ($tmp = @mysql_affected_rows()))
                     17:        printf("[001] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp);
                     18: 
                     19: if (null !== ($tmp = @mysql_affected_rows($link)))
                     20:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     21: 
                     22: if (!is_null($tmp = @mysql_affected_rows($link, $link)))
                     23:        printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
                     24: 
                     25: if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
                     26:        printf("[004] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     27:                $host, $user, $db, $port, $socket);
                     28: 
                     29: if (-1 !== ($tmp = mysql_affected_rows($link)))
                     30:        printf("[005] Expecting int/-1, got %s/%s. [%d] %s\n",
                     31:                gettype($tmp), $tmp, mysql_errno($link), mysql_error($link));
                     32: 
                     33: if (!mysql_query('DROP TABLE IF EXISTS test', $link))
                     34:        printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     35: 
                     36: if (!mysql_query('CREATE TABLE test(id INT, label CHAR(1), PRIMARY KEY(id)) ENGINE = ' . $engine, $link))
                     37:        printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link));
                     38: 
                     39: if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link))
                     40:        printf("[008] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     41: 
                     42: if (1 !== ($tmp = mysql_affected_rows($link)))
                     43:        printf("[010] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp);
                     44: 
                     45: // ignore INSERT error, NOTE: command line returns 0, affected_rows returns -1 as documented
                     46: @mysql_query("INSERT INTO test(id, label) VALUES (1, 'a')", $link);
                     47: if (-1 !== ($tmp = mysql_affected_rows($link)))
                     48:        printf("[011] Expecting int/-1, got %s/%s\n", gettype($tmp), $tmp);
                     49: 
                     50: if (!mysql_query("INSERT INTO test(id, label) VALUES (1, 'a') ON DUPLICATE KEY UPDATE id = 4", $link))
                     51:        printf("[012] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     52: 
                     53: if (2 !== ($tmp = mysql_affected_rows($link)))
                     54:        printf("[013] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp);
                     55: 
                     56: if (!mysql_query("INSERT INTO test(id, label) VALUES (2, 'b'), (3, 'c')", $link))
                     57:        printf("[014] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     58: 
                     59: if (2 !== ($tmp = mysql_affected_rows($link)))
                     60:        printf("[015] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp);
                     61: 
                     62: if (!mysql_query("INSERT IGNORE INTO test(id, label) VALUES (1, 'a')", $link)) {
                     63:        printf("[016] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     64: }
                     65: 
                     66: if (1 !== ($tmp = mysql_affected_rows($link)))
                     67:        printf("[017] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp);
                     68: 
                     69: if (!mysql_query("INSERT INTO test(id, label) SELECT id + 10, label FROM test", $link))
                     70:        printf("[018] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     71: 
                     72: if (4 !== ($tmp = mysql_affected_rows($link)))
                     73:        printf("[019] Expecting int/4, got %s/%s\n", gettype($tmp), $tmp);
                     74: 
                     75: if (!mysql_query("REPLACE INTO test(id, label) values (4, 'd')", $link))
                     76:        printf("[020] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     77: 
                     78: if (2 !== ($tmp = mysql_affected_rows($link)))
                     79:        printf("[021] Expecting int/2, got %s/%s\n", gettype($tmp), $tmp);
                     80: 
                     81: if (!mysql_query("REPLACE INTO test(id, label) values (5, 'e')", $link))
                     82:        printf("[022] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     83: 
                     84: if (1 !== ($tmp = mysql_affected_rows($link)))
                     85:        printf("[023] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp);
                     86: 
                     87: if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link))
                     88:        printf("[024] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     89: 
                     90: if (1 !== ($tmp = mysql_affected_rows($link)))
                     91:        printf("[025] Expecting int/1, got %s/%s\n", gettype($tmp), $tmp);
                     92: 
                     93: if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 2", $link)) {
                     94:        printf("[025] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                     95: }
                     96: 
                     97: if (0 !== ($tmp = mysql_affected_rows($link)))
                     98:        printf("[026] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp);
                     99: 
                    100: if (!mysql_query("UPDATE test SET label = 'a' WHERE id = 100", $link)) {
                    101:        printf("[025] [%d] %s\n",  mysql_errno($link), mysql_error($link));
                    102: }
                    103: 
                    104: if (0 !== ($tmp = mysql_affected_rows($link)))
                    105:        printf("[026] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp);
                    106: 
                    107: if (0 !== ($tmp = mysql_affected_rows()))
                    108:        printf("[027] Expecting int/0, got %s/%s\n", gettype($tmp), $tmp);
                    109: 
                    110: if (!mysql_query('DROP TABLE IF EXISTS test', $link))
                    111:        printf("[028] [%d] %s\n", mysql_errno($link), mysql_error($link));
                    112: 
                    113: mysql_close($link);
                    114: 
                    115: if (false !== ($tmp = @mysql_affected_rows($link)))
                    116:        printf("[029] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
                    117: 
                    118: print "done!";
                    119: ?>
                    120: --CLEAN--
                    121: <?php
                    122: require_once("clean_table.inc");
                    123: ?>
                    124: --EXPECTF--
                    125: done!