/hphp/test/zend/bad/ext/mysql/tests/mysql_list_fields.php
PHP | 57 lines | 42 code | 15 blank | 0 comment | 10 complexity | 27e655aa292b083cbe4b8e50b76ad3af MD5 | raw file
Possible License(s): LGPL-2.1, BSD-2-Clause, BSD-3-Clause, MPL-2.0-no-copyleft-exception, MIT, LGPL-2.0, Apache-2.0
- <?php
- require_once 'connect.inc';
- $tmp = NULL;
- $link = NULL;
- require 'table.inc';
- if (!$res = mysql_list_fields($db, 'test', $link))
- printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
- if (2 !== ($num = mysql_num_fields($res)))
- printf("[004] Expecting two fields from 'test', got %d. [%d] %s\n", $num, mysql_errno($link), mysql_error($link));
- mysql_free_result($res);
- if (!mysql_query("DROP TABLE IF EXISTS test2", $link))
- printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
- if (!$res = @mysql_list_fields($db, 'test2', $link))
- printf("[006] [%d] %s\n", mysql_errno($link), mysql_error($link));
- if (!$res = mysql_list_fields($db, 'test', $link))
- printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link));
- if (2 !== ($num = mysql_num_fields($res)))
- printf("[008] Expecting 2 fields from 'test', got %d. [%d] %s\n", $num, mysql_errno($link), mysql_error($link));
- var_dump(mysql_fetch_assoc($res));
- for ($field_offset = 0; $field_offset < mysql_num_fields($res); $field_offset++) {
- printf("Field Offset %d\n", $field_offset);
- printf("mysql_field_flags(): %s\n", mysql_field_flags($res, $field_offset));
- printf("mysql_field_len(): %s\n", mysql_field_len($res, $field_offset));
- printf("mysql_field_name(): %s\n", mysql_field_name($res, $field_offset));
- printf("mysql_field_type(): %s\n", mysql_field_type($res, $field_offset));
- }
- mysql_free_result($res);
- mysql_close($link);
- print "done!";
- ?>
- <?php error_reporting(0); ?>
- <?php
- require_once 'connect.inc';
- if (!$link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))
- printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
- $host, $user, $db, $port, $socket);
- if (!mysql_query("DROP TABLE IF EXISTS test", $link))
- printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
- if (!mysql_query("DROP TABLE IF EXISTS test2", $link))
- printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
- mysql_close($link);
- ?>