11111
<p>mysqli_fetch_fields
<LINK TITLE="Improved MySQL Extension" HREF="ref.mysqli.html"><LINK TITLE="mysqli_fetch_field" HREF="function.mysqli-fetch-field.html"><LINK TITLE="mysqli_fetch_lengths" HREF="function.mysqli-fetch-lengths.html">
<p><a href="function.mysqli-fetch-field.html">Пред.</a>
<p><a href="function.mysqli-fetch-lengths.html">След.</a>
<p><h1><a name="function.mysqli-fetch-fields"></a>mysqli_fetch_fields</h1><div><a name="AEN98670"></a>
<p>(PHP 5)mysqli_fetch_fields
<p>(no version information, might be only in CVS)result-&#62;fetch_fields -- Returns an array of objects representing the fields in a result set</div><div><a name="AEN98674"></a><h2>Description</h2>
<p>Procedural Style:array mysqli_fetch_fields (mysqli_result result)
<p>Object oriented style (method):class <B CLASS="classname">mysqli_result {
<p>array fetch_fields (void)
<p>}
<p>- This function serves an identical purpose to the <a href="function.mysqli-fetch-field.html">mysqli_fetch_field()</a>
<p>function with the single difference that, instead of returning one object at a time for
<p>each field, the columns are returned as an array of objects.
<p></div><div><a name="AEN98693"></a><h2>Возвращаемые значения</h2>
<p>- Returns an array of objects which contains field definition information or <TT CLASS="constant">FALSE if no field information
<p>is available.
<p>- <DIV><a name="AEN98698"></a>
<p>Таблица 1. Object properties<table><COL><COL><thEAD><tr><th>Property</TH><th>Description</TH></THEAD><tr><td>name<td>The name of the column<tr><td>orgname<td>Original column name if an alias was specified<tr><td>table<td>The name of the table this field belongs to (if not calculated)<tr><td>orgtable<td>Original table name if an alias was specified<tr><td>def<td>The default value for this field, represented as a string<tr><td>max_length<td>The maximum width of the field for the result set.<tr><td>flags<td>An integer representing the bit-flags for the field.<tr><td>type<td>The data type used for this field<tr><td>decimals<td>The number of decimals used (for integer fields)</TABLE></div>
<p></div><div><a name="AEN98733"></a><h2>Смотрите также</h2>
<p>- <a href="function.mysqli-num-fields.html">mysqli_num_fields()</a>,
<p><a href="function.mysqli-fetch-field.html">mysqli_fetch_field()</a> и
<p><a href="function.mysqli-fetch-field-direct.html">mysqli_fetch_field_direct()</a>.
<p></div><div><a name="AEN98739"></a><h2>Примеры</h2><table><tr><td><DIV><a name="AEN98741"></a>
<p>Пример 1. Object oriented style<table><tr><td><code>
<p>&lt;?php
<p>$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";
<p>
<p>if ($result = $mysqli->query($query)) {
<p>
<p>/* Get field information for all columns */
<p>$finfo = $result->fetch_fields();
<p>
<p>foreach ($finfo as $val) {
<p>printf("Name: %s\n", $val->name);
<p>printf("Table: %s\n", $val->table);
<p>printf("max. Len: %d\n", $val->max_length);
<p>printf("Flags: %d\n", $val->flags);
<p>printf("Type: %d\n\n", $val->type);
<p>} 
<p>$result->close();
<p>}
<p>
<p>/* close connection */
<p>$mysqli->close();
<p>?>
<p>
<p></code></TABLE></div></TABLE><table><tr><td><DIV><a name="AEN98744"></a>
<p>Пример 2. Procedural style<table><tr><td><code>
<p>&lt;?php
<p>$link = mysqli_connect("localhost", "my_user", "my_password", "world");
<p>
<p>/* check connection */
<p>if (mysqli_connect_errno()) {
<p>printf("Connect failed: %s\n", mysqli_connect_error());
<p>exit();
<p>}
<p>
<p>$query = "SELECT Name, SurfaceArea from Country ORDER BY Code LIMIT 5";
<p>
<p>if ($result = mysqli_query($link, $query)) {
<p>
<p>/* Get field information for all columns */
<p>$finfo = mysqli_fetch_fields($result);
<p>
<p>foreach ($finfo as $val) {
<p>printf("Name: %s\n", $val->name);
<p>printf("Table: %s\n", $val->table);
<p>printf("max. Len: %d\n", $val->max_length);
<p>printf("Flags: %d\n", $val->flags);
<p>printf("Type: %d\n\n", $val->type);
<p>} 
<p>mysqli_free_result($result);
<p>}
<p>
<p>/* close connection */
<p>mysqli_close($link);
<p>?>
<p>
<p></code></TABLE></div></TABLE>
<p>Результат выполнения данного примера:<table><tr><td><PRE>Name: Name
<p>Table: Country
<p>max. Len: 11
<p>Flags: 1
<p>Type: 254
<p>Name: SurfaceArea
<p>Table: Country
<p>max. Len: 10
<p>Flags: 32769
<p>Type: 4</PRE></TABLE></div>
<p><a href="function.mysqli-fetch-field.html">Пред.</a>
<p><a href="index.html">Начало</a>
<p><a href="function.mysqli-fetch-lengths.html">След.</a>
<p>mysqli_fetch_field
<p><a href="ref.mysqli.html">Уровень выше</a>
<p>mysqli_fetch_lengths
22222
<div style="text-align:right;position:fixed;bottom:3px;right:3px;width:100%;z-index:999999;cursor:pointer;line-height:0;display:block;"><a target="_blank" href="https://www.freewebhostingarea.com" title="Free Web Hosting with PHP5 or PHP7"><img alt="Free Web Hosting" src="https://www.freewebhostingarea.com/images/poweredby.png" style="border-width: 0px;width: 180px; height: 45px; float: right;"></a></div>