mysqli_fetch_lengths to get length of the column of result set

<?Php
require "config.php";// Database connection file.

$query="select * from student where id=7 ";
if ($result_set = mysqli_query($connection,$query)) {
	 $row = mysqli_fetch_row($result_set);
echo $row[1]."<br>";
foreach (mysqli_fetch_lengths($result_set) as $i => $val) {
	echo " Field No ". $i ." value: ".$val . ",";
  }   
}
?>

Krish Star
Field No 0 value: 1, Field No 1 value: 10, Field No 2 value: 4, 
Field No 3 value: 2, Field No 4 value: 6,

$result_set->lengths;

mysqli_fetch_lengths

The input parameter $result_set is the output of result set identifier of mysqli_query(), mysqli_store_result() or mysqli_use_result().

The output is an array containing legth of all columns of result set row .

MySQLI database connection file

MySQL SELECT Query

Procedural style

<?Php
require "config.php";// Database connection file.
$q="SELECT * FROM student where id=4";
if ($result = $connection->query($q)){
    
$row = $result->fetch_row();

echo $row[1]."<br>";
  foreach ($result->lengths as $i => $val) {
   echo " Field No ". $i ." value: ".$val . ",";
  }
	
 $result->close();
}
?>

Getting field length of all records

<?Php
require "config.php";// Database connection,returns the object $connection
$query='SELECT * FROM student';
if ($result = $connection->query($query)) {
    while ($row = $result->fetch_assoc()) {
  echo "<br><br><b>".$row['id'],$row['name'],$row['class'].$row['mark']."</b>";
      foreach ($result->lengths as $i => $val) {
        printf("<br>Field %2d has Length %2d\n", $i+1, $val);
      }
  }
}
?>

<?Php
require "config.php";// Database connection,returns the object $connection
$query='SELECT * FROM student';
if ($result = mysqli_query($connection, $query)) {
while ($row = mysqli_fetch_assoc($result)) {
  echo "<br><br><b>".$row['id'],$row['name'],$row['class'].$row['mark']."</b>";
    /* display column lengths */
    foreach (mysqli_fetch_lengths($result) as $i => $val) {
      printf("<br>Field %2d has Length %2d\n", $i+1, $val);
    }
}
}
?>

output ( sample rows only )

1John DeoFour75
Field 1 has Length 1
Field 2 has Length 8
Field 3 has Length 4
Field 4 has Length 2
Field 5 has Length 6

2Max RuinThree85
Field 1 has Length 1
Field 2 has Length 8
Field 3 has Length 5
Field 4 has Length 2
Field 5 has Length 4

3ArnoldThree55
Field 1 has Length 1
Field 2 has Length 6
Field 3 has Length 5
Field 4 has Length 2
Field 5 has Length 4
------
------

MySQL DUMP of student table

MYSQLI Functions mysqli_num_rows() Number of rows in result set SELECT query UPDATE query mysqli_fetch_field_direct(): Field meta data

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

mysqli_fetch_lengths() : field length

Getting field length of all records

Subhendu Mohapatra