HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
PHP MySQLi Reference : Set the field cursor to the second column ("Age") in the result-set, get field info with fetch_field(), then print the field's name, table, and max length
The field_seek() / mysqli_field_seek() function sets the field cursor to the given field offset.
Object oriented style:
Procedural style:
| Parameter | Description |
|---|---|
| result | Required. Specifies a result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result() |
| fieldnr | Required. Specifies the field number. Must be an integer from 0 to number of fields-1 |
| Return Value: | TRUE on success. FALSE on failure |
|---|---|
| PHP Version: | 5+ |
Set the field cursor to the second column ("Age") in the result-set, get field info with mysqli_fetch_field(), then print the field's name, table, and max length:
<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}
$sql="SELECT Lastname, Age FROM Persons ORDER BY Lastname";
if ($result = mysqli_query($con,$sql)) {
// Get field information for
second column
mysqli_field_seek($result, 1);
$fieldinfo = mysqli_fetch_field($result);
printf("Name: %s\n", $fieldinfo -> name);
printf("Table: %s\n", $fieldinfo -> table);
printf("max. Len: %d\n", $fieldinfo -> max_length);
mysqli_free_result($result);
}
mysqli_close($con);
?>
❮ PHP MySQLi Reference