Question

How to fetch meta-data for a single field 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)) 
{
    $fld = $result->fetch_field_direct(1);
        
    echo $fld->name . "<br />";
    echo $fld->table . "<br />";
    echo $fld->max_length . "<br />";
    echo $fld->type . "<br />";
    
    $result->close();
}

$con->close();


/*
run: 

webpage_id
images
2
8

*/

 

70+ SQL courses for beginners and professionals