function db_table_struct_select() { $db = JFactory::getDBO(); $field_type = JRequest::getVar('field_type'); $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(); HTML_contact::db_table_struct_select($table_struct, $field_type); }