Ejemplos de HTML_contact::db_table_struct_select en PHP

Ejemplo n.º 1

Archivo: formmaker.php Proyecto: ankaau/GathBandhan

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);
}