php PMA_exportStructure类(方法)实例源码

break;
     }
     // We export just one table
     if ($limit_to > 0 && $limit_from >= 0) {
         $add_query = ' LIMIT ' . ($limit_from > 0 ? $limit_from . ', ' : '') . $limit_to;
     } else {
         $add_query = '';
     }
     if (!empty($sql_query)) {
         $local_query = $sql_query . $add_query;
         PMA_DBI_select_db($db);
     } else {
         $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query;
     }
     if (isset($GLOBALS[$what . '_structure'])) {
         if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) {
             break;
         }
     }
     if (isset($GLOBALS[$what . '_data'])) {
         if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) {
             break;
         }
     }
     if (!PMA_exportDBFooter($db)) {
         break;
     }
 }
 if (!PMA_exportFooter()) {
     break;
 }

// remove trailing semicolon before adding a LIMIT
                    $sql_query = preg_replace('%;\\s*$%', '', $sql_query);
                }
                $local_query = $sql_query . $add_query;
                PMA_DBI_select_db($db);
            } else {
                $local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query;
            }
            if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) {
                break;
            }
        }
        // now export the triggers (needs to be done after the data because
        // triggers can modify already imported tables)
        if (isset($GLOBALS[$what . '_structure'])) {
            if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, 'triggers', $export_type)) {
                break 2;
            }
        }
        if (!PMA_exportDBFooter($db)) {
            break;
        }
    }
    if (!PMA_exportFooter()) {
        break;
    }
} while (false);
// End of fake loop
if ($save_on_server && isset($message)) {
    $GLOBALS['js_include'][] = 'functions.js';
    require_once './libraries/header.inc.php';

if (!PMA_exportDBFooter($db)) {
         break;
     }
 } else {
     if (!PMA_exportDBHeader($db)) {
         break;
     }
     // We export just one table
     if ($limit_to > 0 && $limit_from >= 0) {
         $add_query = ' LIMIT ' . ($limit_from > 0 ? $limit_from . ', ' : '') . $limit_to;
     } else {
         $add_query = '';
     }
     $is_view = PMA_Table::isView($db, $table);
     if (isset($GLOBALS[$what . '_structure'])) {
         if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates, $is_view ? 'create_view' : 'create_table', $export_type)) {
             break;
         }
     }
     // If this is an export of a single view, we have to export data;
     // for example, a PDF report
     if (isset($GLOBALS[$what . '_data'])) {
         if (!empty($sql_query)) {
             // only preg_replace if needed
             if (!empty($add_query)) {
                 // remove trailing semicolon before adding a LIMIT
                 $sql_query = preg_replace('%;\\s*$%', '', $sql_query);
             }
             $local_query = $sql_query . $add_query;
             PMA_DBI_select_db($db);
         } else {