PHP mysql_field_flags() Function
 Complete PHP MySQL Reference
Definition and Usage
The mysql_field_flags() function returns the flags of a field in a recordset.
This function gets field data from the mysql_query() function and returns a
string on success, or FALSE on failure or
when there are no more
rows.
Possible return values:
- auto_intcrement - 1 if AUTO_INCREMENT is set
- binary - 1 if the field has the BINAR attribute set
- blob - 1 if the field is a BLOB
- enum - 1 if the field is an ENUM field
- multiple_key - 1 if the field is a non-unique key
- not_null - 1 if the field cannot be NULL
- primary_key - 1 if the field is a primary key
- timestamp - 1 if the field is a timestamp field
- unique_key - 1 if the field is a unique key
- unsigned - 1 if the field is unsigned
- zerofill - 1 if the field is zero-filled
Syntax
mysql_field_flags(data,field_offset)
|
| Parameter |
Description |
| data |
Required. Specifies which data pointer to use. The data
pointer is the result from the mysql_query() function |
| field_offset |
Required. Specifies which field to start returning.
0 indicates the first field |
Tips and Notes
Tip: You can break the returned string into an array by using explode().
Example
<?php
$con = mysql_connect("localhost", "peter", "abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
$flags = mysql_field_flags($result, 0);
echo $flags;
mysql_close($con);
?>
|
The output of the code above could be:
not_null primary_key auto_increment
|
Complete PHP MySQL Reference
 |
 |
 |
 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
 |
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
 |
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|
HOME
Printer friendly page
