function db_table_struct() { $db = JFactory::getDBO(); $id = JRequest::getVar('id'); $name = JRequest::getVar('name'); if (!$name) { return; } $con_method = JRequest::getVar('con_method'); $con_type = JRequest::getVar('con_type'); if ($con_type == 'remote') { $remote = array(); //prevent problems $remote['driver'] = 'mysql'; $remote['host'] = JRequest::getVar('host'); $remote['user'] = JRequest::getVar('username'); $remote['password'] = JRequest::getVar('password'); $remote['database'] = JRequest::getVar('database'); $remote['prefix'] = ''; $db = JDatabase::getInstance($remote); if ($db->getErrorNum()) { echo '<div style="font-size: 22px; text-align: center; padding-top: 15px;">' . $db->stderr() . '</div>'; return false; } } $query = "SHOW COLUMNS FROM " . $name; $db->setQuery($query); $table_struct = $db->loadObjectList(); $db = JFactory::getDBO(); $query = "SELECT label_order_current FROM #__formmaker where id=" . $db->escape((int) $id); $db->setQuery($query); $label = $db->loadResult(); // print_r($table_struct); HTML_contact::db_table_struct($table_struct, $label, $con_method); }