Joomla table DESCRIBE

by user1616338   Last Updated October 11, 2018 14:10 PM - source

I'm trying to DESCRIBE a table in joomla 3.x I want to get the column names and the associated details (type etc) into an array.

I can't find anything in Joomla API that allow me to do the DESCRIBE. I've tried lots of ways of getting the info but no success e.g:

$db = JFactory::getDbo();
$query = $db->getQuery(true);   
$query = "DESCRIBE `##__table_person`";
$row = $db->loadObjectList($query);
/*while($row ) {
    echo "{$row['Field']} - {$row['Type']}\n";
print "<pre>";
print "</pre>";

Related Questions

How to edit the text string "Contact Form"

Updated November 22, 2017 01:10 AM

Why int(11) on database integer columns?

Updated August 05, 2015 13:04 PM

Joomla SQL drivers and prepared statements

Updated August 11, 2015 17:04 PM