xref: /PHP-5.3/ext/mysql/tests/bug47438.phpt (revision 5147f6cf)
1--TEST--
2Bug #47438 (mysql_fetch_field ignores zero offset)
3--SKIPIF--
4<?php
5require_once('skipif.inc');
6require_once('skipifconnectfailure.inc');
7?>
8--FILE--
9<?php
10require_once('connect.inc');
11
12if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
13        printf("[001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
14                $host, $user, $db, $port, $socket);
15
16mysql_select_db($db, $link);
17mysql_query("DROP TABLE IF EXISTS test_47438", $link);
18mysql_query("CREATE TABLE test_47438 (a INT, b INT, c INT)", $link);
19mysql_query("INSERT INTO test_47438 VALUES (10, 11, 12), (20, 21, 22)", $link);
20$result = mysql_query("SELECT * FROM test_47438", $link);
21mysql_field_seek($result, 1);
22
23$i = 0;
24
25while($i<mysql_num_fields($result))
26{
27  $meta=mysql_fetch_field($result,$i);
28  echo $i . "." . $meta->name . "\n";
29  $i++;
30}
31
32mysql_query("DROP TABLE IF EXISTS test_47438", $link);
33
34?>
35--CLEAN--
36<?php
37require_once('connect.inc');
38
39if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
40        printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
41                $host, $user, $db, $port, $socket);
42
43if (!mysql_select_db($db, $link) ||
44	!mysql_query("DROP TABLE IF EXISTS test_47438", $link))
45	printf("[c002] [%d] %s\n", mysql_errno($link), mysql_error($link));
46
47mysql_close($link);
48?>
49--EXPECT--
500.a
511.b
522.c
53