Question

How to get the lengths of the columns of the current row in the result set using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';

$con = new mysqli('localhost', $db_user, $db_password, $db_name);

if ($con->connect_error) 
    die('Connection Error: ' . $con->connect_error);
    
$query = "SELECT * FROM images";

if ($result = $con->query($query)) 
{
    $row = $result->fetch_row();

    foreach ($result->lengths as $i => $val) 
        echo "Field " . ($i + 1) . " length: $val <br />";
    
    $result->close();
}

$con->close();


/*
run: 

Field 1 length: 2 
Field 2 length: 2 
Field 3 length: 21 
Field 4 length: 59 
Field 5 length: 0 
Field 6 length: 4 
Field 7 length: 1 
Field 8 length: 1 
Field 9 length: 1 
Field 10 length: 19 
Field 11 length: 1 

*/

 

70+ SQL courses for beginners and professionals