- 2.5 MySQL Functions
- 2.5.1 mysql_affected_rows
- 2.5.2 mysql_client_encoding
- 2.5.3 mysql_close
- 2.5.4 mysql_connect
- 2.5.5 mysql_create_db
- 2.5.6 mysql_data_seek
- 2.5.7 mysql_db_name
- 2.5.8 mysql_db_query
- 2.5.9 mysql_drop_db
- 2.5.10 mysql_errno
- 2.5.11 mysql_error
- 2.5.12 mysql_escape_string
- 2.5.13 mysql_fetch_array
- 2.5.14 mysql_fetch_assoc
- 2.5.15 mysql_fetch_field
- 2.5.16 mysql_fetch_lengths
- 2.5.17 mysql_fetch_object
- 2.5.18 mysql_fetch_row
- 2.5.19 mysql_field_flags
- 2.5.20 mysql_field_len
- 2.5.21 mysql_field_name
- 2.5.22 mysql_field_seek
- 2.5.23 mysql_field_table
- 2.5.24 mysql_field_type
- 2.5.25 mysql_free_result
- 2.5.26 mysql_get_client_info
- 2.5.27 mysql_get_host_info
- 2.5.28 mysql_get_proto_info
- 2.5.29 mysql_get_server_info
- 2.5.30 mysql_info
- 2.5.31 mysql_insert_id
- 2.5.32 mysql_list_dbs
- 2.5.33 mysql_list_fields
- 2.5.34 mysql_list_processes
- 2.5.35 mysql_list_tables
- 2.5.36 mysql_num_fields
- 2.5.37 mysql_num_rows
- 2.5.38 mysql_pconnect
- 2.5.39 mysql_ping
- 2.5.40 mysql_query
- 2.5.41 mysql_real_escape_string
- 2.5.42 mysql_result
- 2.5.43 mysql_select_db
- 2.5.44 mysql_set_charset
- 2.5.45 mysql_stat
- 2.5.46 mysql_tablename
- 2.5.47 mysql_thread_id
- 2.5.48 mysql_unbuffered_query
Copyright 1997-2012 the PHP Documentation Group.
mysql_field_flagsGet the flags associated with the specified field in a result
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
mysqli_fetch_field_direct [flags] |
PDOStatement::getColumnMeta [flags] |
Description
string mysql_field_flags(resource result,
int field_offset);
mysql_field_flags
returns the field flags of the specified field. The flags are
reported as a single word per flag separated by a single space,
so that you can split the returned value using
explode.
Parameters
-
result The result resource that is being evaluated. This result comes from a call to
mysql_query.-
field_offset The numerical field offset. The
field_offsetstarts at0. Iffield_offsetdoes not exist, an error of levelE_WARNINGis also issued.
Return Values
Returns a string of flags associated with the result or
FALSE
on failure.
The following flags are reported, if your version of MySQL is
current enough to support them:
"not_null",
"primary_key",
"unique_key",
"multiple_key",
"blob",
"unsigned",
"zerofill",
"binary",
"enum",
"auto_increment" and
"timestamp".
Examples
Example 2.27. A
mysql_field_flags
example
<?php
$result = mysql_query("SELECT id,email FROM people WHERE id = '42'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
$flags = mysql_field_flags($result, 0);
echo $flags;
print_r(explode(' ', $flags));
?>
The above example will output something similar to:
not_null primary_key auto_increment
Array
(
[0] => not_null
[1] => primary_key
[2] => auto_increment
)
Notes
For backward compatibility, the following deprecated alias may
be used: mysql_fieldflags
See Also
mysql_field_type
|
mysql_field_len
|
User Comments
Add your own comment.