0,0 → 1,654 |
<?php |
/* $Id: sql.php,v 2.53.2.1 2006/05/05 09:20:37 nijel Exp $ */ |
// vim: expandtab sw=4 ts=4 sts=4: |
/** |
* Set of functions used to build SQL dumps of tables |
*/ |
|
/** |
* Marker for comments, -- is needed for ANSI SQL. |
*/ |
$GLOBALS['comment_marker'] = '-- '; |
|
/** |
* Avoids undefined variables, use NULL so isset() returns false |
*/ |
if ( ! isset( $use_backquotes ) ) { |
$use_backquotes = null; |
} |
|
/** |
* Outputs comment |
* |
* @param string Text of comment |
* |
* @return bool Whether it suceeded |
*/ |
function PMA_exportComment($text) |
{ |
return PMA_exportOutputHandler($GLOBALS['comment_marker'] . $text . $GLOBALS['crlf']); |
} |
|
/** |
* Outputs export footer |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportFooter() |
{ |
global $crlf; |
|
$foot = ''; |
|
if (isset($GLOBALS['disable_fk'])) { |
$foot .= $crlf . 'SET FOREIGN_KEY_CHECKS=1;' . $crlf; |
} |
|
if (isset($GLOBALS['use_transaction'])) { |
$foot .= $crlf . 'COMMIT;' . $crlf; |
} |
|
return PMA_exportOutputHandler($foot); |
} |
|
/** |
* Outputs export header |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportHeader() |
{ |
global $crlf; |
global $cfg; |
|
if (PMA_MYSQL_INT_VERSION >= 40100 && isset($GLOBALS['sql_compat']) && $GLOBALS['sql_compat'] != 'NONE') { |
PMA_DBI_try_query('SET SQL_MODE="' . $GLOBALS['sql_compat'] . '"'); |
} |
|
$head = $GLOBALS['comment_marker'] . 'phpMyAdmin SQL Dump' . $crlf |
. $GLOBALS['comment_marker'] . 'version ' . PMA_VERSION . $crlf |
. $GLOBALS['comment_marker'] . 'http://www.phpmyadmin.net' . $crlf |
. $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strHost'] . ': ' . $cfg['Server']['host']; |
if (!empty($cfg['Server']['port'])) { |
$head .= ':' . $cfg['Server']['port']; |
} |
$head .= $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strGenTime'] . ': ' . PMA_localisedDate() . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strServerVersion'] . ': ' . substr(PMA_MYSQL_INT_VERSION, 0, 1) . '.' . (int) substr(PMA_MYSQL_INT_VERSION, 1, 2) . '.' . (int) substr(PMA_MYSQL_INT_VERSION, 3) . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strPHPVersion'] . ': ' . phpversion() . $crlf; |
|
if (isset($GLOBALS['header_comment']) && !empty($GLOBALS['header_comment'])) { |
$lines = explode('\n', $GLOBALS['header_comment']); |
$head .= $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . implode($crlf . $GLOBALS['comment_marker'], $lines) . $crlf |
. $GLOBALS['comment_marker'] . $crlf; |
} |
|
if (isset($GLOBALS['disable_fk'])) { |
$head .= $crlf . 'SET FOREIGN_KEY_CHECKS=0;' . $crlf; |
} |
|
if (isset($GLOBALS['use_transaction'])) { |
$head .= $crlf .'SET AUTOCOMMIT=0;' . $crlf |
. 'START TRANSACTION;' . $crlf . $crlf; |
} |
|
return PMA_exportOutputHandler($head); |
} |
|
/** |
* Outputs create database database |
* |
* @param string Database name |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportDBCreate($db) |
{ |
global $crlf; |
if (isset($GLOBALS['drop_database'])) { |
if (!PMA_exportOutputHandler('DROP DATABASE ' . (isset($GLOBALS['use_backquotes']) ? PMA_backquote($db) : $db) . ';' . $crlf)) { |
return FALSE; |
} |
} |
$create_query = 'CREATE DATABASE ' . (isset($GLOBALS['use_backquotes']) ? PMA_backquote($db) : $db); |
if (PMA_MYSQL_INT_VERSION >= 40101) { |
$collation = PMA_getDbCollation($db); |
if (strpos($collation, '_')) { |
$create_query .= ' DEFAULT CHARACTER SET ' . substr($collation, 0, strpos($collation, '_')) . ' COLLATE ' . $collation; |
} else { |
$create_query .= ' DEFAULT CHARACTER SET ' . $collation; |
} |
} |
$create_query .= ';' . $crlf; |
if (!PMA_exportOutputHandler($create_query)) { |
return FALSE; |
} |
if (isset($GLOBALS['use_backquotes']) && PMA_MYSQL_INT_VERSION >= 40100 && isset($GLOBALS['sql_compat']) && $GLOBALS['sql_compat'] == 'NONE') { |
return PMA_exportOutputHandler('USE ' . PMA_backquote($db) . ';' . $crlf); |
} |
return PMA_exportOutputHandler('USE ' . $db . ';' . $crlf); |
} |
|
/** |
* Outputs database header |
* |
* @param string Database name |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportDBHeader($db) |
{ |
global $crlf; |
$head = $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strDatabase'] . ': ' . (isset($GLOBALS['use_backquotes']) ? PMA_backquote($db) : '\'' . $db . '\''). $crlf |
. $GLOBALS['comment_marker'] . $crlf; |
return PMA_exportOutputHandler($head); |
} |
|
/** |
* Outputs database footer |
* |
* @param string Database name |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportDBFooter($db) |
{ |
$result = TRUE; |
if (isset($GLOBALS['sql_constraints'])) { |
$result = PMA_exportOutputHandler($GLOBALS['sql_constraints']); |
unset($GLOBALS['sql_constraints']); |
} |
return $result; |
} |
|
/** |
* Returns $table's CREATE definition |
* |
* @param string the database name |
* @param string the table name |
* @param string the end of line sequence |
* @param string the url to go back in case of error |
* @param boolean whether to include creation/update/check dates |
* |
* @return string resulting schema |
* |
* @global boolean whether to add 'drop' statements or not |
* @global boolean whether to use backquotes to allow the use of special |
* characters in database, table and fields names or not |
* |
* @access public |
*/ |
function PMA_getTableDef($db, $table, $crlf, $error_url, $show_dates = false) |
{ |
global $drop; |
global $use_backquotes; |
global $cfgRelation; |
global $sql_constraints; |
|
$schema_create = ''; |
$auto_increment = ''; |
$new_crlf = $crlf; |
|
// need to use PMA_DBI_QUERY_STORE with PMA_DBI_num_rows() in mysqli |
$result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . PMA_sqlAddslashes($table) . '\'', null, PMA_DBI_QUERY_STORE); |
if ($result != FALSE) { |
if (PMA_DBI_num_rows($result) > 0) { |
$tmpres = PMA_DBI_fetch_assoc($result); |
if (isset($GLOBALS['sql_auto_increment']) && !empty($tmpres['Auto_increment'])) { |
$auto_increment .= ' AUTO_INCREMENT=' . $tmpres['Auto_increment'] . ' '; |
} |
|
if ($show_dates && isset($tmpres['Create_time']) && !empty($tmpres['Create_time'])) { |
$schema_create .= $GLOBALS['comment_marker'] . $GLOBALS['strStatCreateTime'] . ': ' . PMA_localisedDate(strtotime($tmpres['Create_time'])) . $crlf; |
$new_crlf = $GLOBALS['comment_marker'] . $crlf . $crlf; |
} |
|
if ($show_dates && isset($tmpres['Update_time']) && !empty($tmpres['Update_time'])) { |
$schema_create .= $GLOBALS['comment_marker'] . $GLOBALS['strStatUpdateTime'] . ': ' . PMA_localisedDate(strtotime($tmpres['Update_time'])) . $crlf; |
$new_crlf = $GLOBALS['comment_marker'] . $crlf . $crlf; |
} |
|
if ($show_dates && isset($tmpres['Check_time']) && !empty($tmpres['Check_time'])) { |
$schema_create .= $GLOBALS['comment_marker'] . $GLOBALS['strStatCheckTime'] . ': ' . PMA_localisedDate(strtotime($tmpres['Check_time'])) . $crlf; |
$new_crlf = $GLOBALS['comment_marker'] . $crlf . $crlf; |
} |
} |
PMA_DBI_free_result($result); |
} |
|
$schema_create .= $new_crlf; |
|
if (!empty($drop)) { |
$schema_create .= 'DROP TABLE IF EXISTS ' . PMA_backquote($table, $use_backquotes) . ';' . $crlf; |
} |
|
// Steve Alberty's patch for complete table dump, |
// Whether to quote table and fields names or not |
if ($use_backquotes) { |
PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 1'); |
} else { |
PMA_DBI_query('SET SQL_QUOTE_SHOW_CREATE = 0'); |
} |
|
$result = PMA_DBI_query('SHOW CREATE TABLE ' . PMA_backquote($db) . '.' . PMA_backquote($table), null, PMA_DBI_QUERY_UNBUFFERED); |
if ($result != FALSE && ($row = PMA_DBI_fetch_row($result))) { |
$create_query = $row[1]; |
unset($row); |
|
// Convert end of line chars to one that we want (note that MySQL doesn't return query it will accept in all cases) |
if (strpos($create_query, "(\r\n ")) { |
$create_query = str_replace("\r\n", $crlf, $create_query); |
} elseif (strpos($create_query, "(\n ")) { |
$create_query = str_replace("\n", $crlf, $create_query); |
} elseif (strpos($create_query, "(\r ")) { |
$create_query = str_replace("\r", $crlf, $create_query); |
} |
|
// Should we use IF NOT EXISTS? |
if (isset($GLOBALS['if_not_exists'])) { |
$create_query = preg_replace('/^CREATE TABLE/', 'CREATE TABLE IF NOT EXISTS', $create_query); |
} |
|
// are there any constraints to cut out? |
if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $create_query)) { |
|
// Split the query into lines, so we can easily handle it. We know lines are separated by $crlf (done few lines above). |
$sql_lines = explode($crlf, $create_query); |
$sql_count = count($sql_lines); |
|
// lets find first line with constraints |
for ($i = 0; $i < $sql_count; $i++) { |
if (preg_match('@^[\s]*(CONSTRAINT|FOREIGN[\s]+KEY)@', $sql_lines[$i])) { |
break; |
} |
} |
|
// If we really found a constraint |
if ($i != $sql_count) { |
|
// remove , from the end of create statement |
$sql_lines[$i - 1] = preg_replace('@,$@', '', $sql_lines[$i - 1]); |
|
// prepare variable for constraints |
if (!isset($sql_constraints)) { |
if (isset($GLOBALS['no_constraints_comments'])) { |
$sql_constraints = ''; |
} else { |
$sql_constraints = $crlf . $GLOBALS['comment_marker'] . |
$crlf . $GLOBALS['comment_marker'] . $GLOBALS['strConstraintsForDumped'] . |
$crlf . $GLOBALS['comment_marker'] . $crlf; |
} |
} |
|
// comments for current table |
if (!isset($GLOBALS['no_constraints_comments'])) { |
$sql_constraints .= $crlf . $GLOBALS['comment_marker'] . |
$crlf . $GLOBALS['comment_marker'] . $GLOBALS['strConstraintsForTable'] . ' ' . PMA_backquote($table) . |
$crlf . $GLOBALS['comment_marker'] . $crlf; |
} |
|
// let's do the work |
$sql_constraints .= 'ALTER TABLE ' . PMA_backquote($table) . $crlf; |
|
$first = TRUE; |
for ($j = $i; $j < $sql_count; $j++) { |
if (preg_match('@CONSTRAINT|FOREIGN[\s]+KEY@', $sql_lines[$j])) { |
if (!$first) { |
$sql_constraints .= $crlf; |
} |
if (strpos($sql_lines[$j], 'CONSTRAINT') === FALSE) { |
$sql_constraints .= preg_replace('/(FOREIGN[\s]+KEY)/', 'ADD \1', $sql_lines[$j]); |
} else { |
$sql_constraints .= preg_replace('/(CONSTRAINT)/', 'ADD \1', $sql_lines[$j]); |
} |
$first = FALSE; |
} else { |
break; |
} |
} |
$sql_constraints .= ';' . $crlf; |
$create_query = implode($crlf, array_slice($sql_lines, 0, $i)) . $crlf . implode($crlf, array_slice($sql_lines, $j, $sql_count - 1)); |
unset($sql_lines); |
} |
} |
$schema_create .= $create_query; |
} |
|
$schema_create .= $auto_increment; |
|
PMA_DBI_free_result($result); |
return $schema_create; |
} // end of the 'PMA_getTableDef()' function |
|
|
/** |
* Returns $table's comments, relations etc. |
* |
* @param string the database name |
* @param string the table name |
* @param string the end of line sequence |
* @param boolean whether to include relation comments |
* @param boolean whether to include column comments |
* @param boolean whether to include mime comments |
* |
* @return string resulting comments |
* |
* @access public |
*/ |
function PMA_getTableComments($db, $table, $crlf, $do_relation = false, $do_comments = false, $do_mime = false) |
{ |
global $cfgRelation; |
global $use_backquotes; |
global $sql_constraints; |
|
$schema_create = ''; |
|
// triggered only for MySQL < 4.1.x (pmadb-style comments) |
if ($do_comments && $cfgRelation['commwork']) { |
if (!($comments_map = PMA_getComments($db, $table))) { |
unset($comments_map); |
} |
} |
|
// Check if we can use Relations (Mike Beck) |
if ($do_relation && !empty($cfgRelation['relation'])) { |
// Find which tables are related with the current one and write it in |
// an array |
$res_rel = PMA_getForeigners($db, $table); |
|
if ($res_rel && count($res_rel) > 0) { |
$have_rel = TRUE; |
} else { |
$have_rel = FALSE; |
} |
} else { |
$have_rel = FALSE; |
} // end if |
|
if ($do_mime && $cfgRelation['mimework']) { |
if (!($mime_map = PMA_getMIME($db, $table, true))) { |
unset($mime_map); |
} |
} |
|
if (isset($comments_map) && count($comments_map) > 0) { |
$schema_create .= $crlf . $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strCommentsForTable']. ' ' . PMA_backquote($table, $use_backquotes) . ':' . $crlf; |
foreach ($comments_map AS $comment_field => $comment) { |
$schema_create .= $GLOBALS['comment_marker'] . ' ' . PMA_backquote($comment_field, $use_backquotes) . $crlf |
. $GLOBALS['comment_marker'] . ' ' . PMA_backquote($comment, $use_backquotes) . $crlf; |
} |
$schema_create .= $GLOBALS['comment_marker'] . $crlf; |
} |
|
if (isset($mime_map) && count($mime_map) > 0) { |
$schema_create .= $crlf . $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strMIMETypesForTable']. ' ' . PMA_backquote($table, $use_backquotes) . ':' . $crlf; |
@reset($mime_map); |
foreach ($mime_map AS $mime_field => $mime) { |
$schema_create .= $GLOBALS['comment_marker'] . ' ' . PMA_backquote($mime_field, $use_backquotes) . $crlf |
. $GLOBALS['comment_marker'] . ' ' . PMA_backquote($mime['mimetype'], $use_backquotes) . $crlf; |
} |
$schema_create .= $GLOBALS['comment_marker'] . $crlf; |
} |
|
if ($have_rel) { |
$schema_create .= $crlf . $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strRelationsForTable']. ' ' . PMA_backquote($table, $use_backquotes) . ':' . $crlf; |
foreach ($res_rel AS $rel_field => $rel) { |
$schema_create .= $GLOBALS['comment_marker'] . ' ' . PMA_backquote($rel_field, $use_backquotes) . $crlf |
. $GLOBALS['comment_marker'] . ' ' . PMA_backquote($rel['foreign_table'], $use_backquotes) |
. ' -> ' . PMA_backquote($rel['foreign_field'], $use_backquotes) . $crlf; |
} |
$schema_create .= $GLOBALS['comment_marker'] . $crlf; |
} |
|
return $schema_create; |
|
} // end of the 'PMA_getTableComments()' function |
|
/** |
* Outputs table's structure |
* |
* @param string the database name |
* @param string the table name |
* @param string the end of line sequence |
* @param string the url to go back in case of error |
* @param boolean whether to include relation comments |
* @param boolean whether to include column comments |
* @param boolean whether to include mime comments |
* |
* @return bool Whether it suceeded |
* |
* @access public |
*/ |
function PMA_exportStructure($db, $table, $crlf, $error_url, $relation = FALSE, $comments = FALSE, $mime = FALSE, $dates = FALSE) |
{ |
$formatted_table_name = (isset($GLOBALS['use_backquotes'])) |
? PMA_backquote($table) |
: '\'' . $table . '\''; |
$dump = $crlf |
. $GLOBALS['comment_marker'] . '--------------------------------------------------------' . $crlf |
. $crlf . $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strTableStructure'] . ' ' . $formatted_table_name . $crlf |
. $GLOBALS['comment_marker'] . $crlf |
. PMA_getTableDef($db, $table, $crlf, $error_url, $dates) . ';' . $crlf |
. PMA_getTableComments($db, $table, $crlf, $relation, $comments, $mime); |
|
|
return PMA_exportOutputHandler($dump); |
} |
|
/** |
* Dispatches between the versions of 'getTableContent' to use depending |
* on the php version |
* |
* @param string the database name |
* @param string the table name |
* @param string the end of line sequence |
* @param string the url to go back in case of error |
* @param string SQL query for obtaining data |
* |
* @return bool Whether it suceeded |
* |
* @global boolean whether to use backquotes to allow the use of special |
* characters in database, table and fields names or not |
* @global integer the number of records |
* @global integer the current record position |
* |
* @access public |
* |
* @see PMA_getTableContentFast(), PMA_getTableContentOld() |
* |
* @author staybyte |
*/ |
function PMA_exportData($db, $table, $crlf, $error_url, $sql_query) |
{ |
global $use_backquotes; |
global $rows_cnt; |
global $current_row; |
|
$formatted_table_name = (isset($GLOBALS['use_backquotes'])) |
? PMA_backquote($table) |
: '\'' . $table . '\''; |
$head = $crlf |
. $GLOBALS['comment_marker'] . $crlf |
. $GLOBALS['comment_marker'] . $GLOBALS['strDumpingData'] . ' ' . $formatted_table_name . $crlf |
. $GLOBALS['comment_marker'] . $crlf .$crlf; |
|
if (!PMA_exportOutputHandler($head)) { |
return FALSE; |
} |
|
$buffer = ''; |
|
// analyze the query to get the true column names, not the aliases |
// (this fixes an undefined index, also if Complete inserts |
// are used, we did not get the true column name in case of aliases) |
$analyzed_sql = PMA_SQP_analyze(PMA_SQP_parse($sql_query)); |
|
$result = PMA_DBI_query($sql_query, null, PMA_DBI_QUERY_UNBUFFERED); |
if ($result != FALSE) { |
$fields_cnt = PMA_DBI_num_fields($result); |
|
// Get field information |
$fields_meta = PMA_DBI_get_fields_meta($result); |
$field_flags = array(); |
for ($j = 0; $j < $fields_cnt; $j++) { |
$field_flags[$j] = PMA_DBI_field_flags($result, $j); |
} |
|
for ($j = 0; $j < $fields_cnt; $j++) { |
if (isset($analyzed_sql[0]['select_expr'][$j]['column'])) { |
$field_set[$j] = PMA_backquote($analyzed_sql[0]['select_expr'][$j]['column'], $use_backquotes); |
} else { |
$field_set[$j] = PMA_backquote($fields_meta[$j]->name, $use_backquotes); |
} |
} |
|
if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'update') { |
// update |
$schema_insert = 'UPDATE '; |
if (isset($GLOBALS['sql_ignore'])) { |
$schema_insert .= 'IGNORE '; |
} |
$schema_insert .= PMA_backquote($table, $use_backquotes) . ' SET '; |
unset($GLOBALS['extended_ins']); |
} else { |
// insert or replace |
if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'replace') { |
$sql_command = 'REPLACE'; |
} else { |
$sql_command = 'INSERT'; |
} |
|
// delayed inserts? |
if (isset($GLOBALS['delayed'])) { |
$insert_delayed = ' DELAYED'; |
} else { |
$insert_delayed = ''; |
} |
|
// insert ignore? |
if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'insert' && isset($GLOBALS['sql_ignore'])) { |
$insert_delayed .= ' IGNORE'; |
} |
|
// scheme for inserting fields |
if (isset($GLOBALS['showcolumns'])) { |
$fields = implode(', ', $field_set); |
$schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $use_backquotes) |
. ' (' . $fields . ') VALUES '; |
} else { |
$schema_insert = $sql_command . $insert_delayed .' INTO ' . PMA_backquote($table, $use_backquotes) |
. ' VALUES '; |
} |
} |
|
$search = array("\x00", "\x0a", "\x0d", "\x1a"); //\x08\\x09, not required |
$replace = array('\0', '\n', '\r', '\Z'); |
$current_row = 0; |
$query_size = 0; |
$separator = isset($GLOBALS['extended_ins']) ? ',' : ';'; |
|
while ($row = PMA_DBI_fetch_row($result)) { |
$current_row++; |
for ($j = 0; $j < $fields_cnt; $j++) { |
// NULL |
if (!isset($row[$j]) || is_null($row[$j])) { |
$values[] = 'NULL'; |
// a number |
// timestamp is numeric on some MySQL 4.1, BLOBs are sometimes numeric |
} elseif ($fields_meta[$j]->numeric && $fields_meta[$j]->type != 'timestamp' |
&& ! $fields_meta[$j]->blob) { |
$values[] = $row[$j]; |
// a binary field |
// Note: with mysqli, under MySQL 4.1.3, we get the flag |
// "binary" for those field types (I don't know why) |
} elseif (stristr($field_flags[$j], 'BINARY') |
&& isset($GLOBALS['hexforbinary']) |
&& $fields_meta[$j]->type != 'datetime' |
&& $fields_meta[$j]->type != 'date' |
&& $fields_meta[$j]->type != 'time' |
&& $fields_meta[$j]->type != 'timestamp' |
) { |
// empty blobs need to be different, but '0' is also empty :-( |
if (empty($row[$j]) && $row[$j] != '0') { |
$values[] = '\'\''; |
} else { |
$values[] = '0x' . bin2hex($row[$j]); |
} |
// something else -> treat as a string |
} else { |
$values[] = '\'' . str_replace($search, $replace, PMA_sqlAddslashes($row[$j])) . '\''; |
} // end if |
} // end for |
|
// should we make update? |
if (isset($GLOBALS['sql_type']) && $GLOBALS['sql_type'] == 'update') { |
|
$insert_line = $schema_insert; |
for ($i = 0; $i < $fields_cnt; $i++) { |
if ($i > 0) { |
$insert_line .= ', '; |
} |
$insert_line .= $field_set[$i] . ' = ' . $values[$i]; |
} |
|
$insert_line .= ' WHERE ' . PMA_getUvaCondition($result, $fields_cnt, $fields_meta, $row); |
|
} else { |
|
// Extended inserts case |
if (isset($GLOBALS['extended_ins'])) { |
if ($current_row == 1) { |
$insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; |
} else { |
$insert_line = '(' . implode(', ', $values) . ')'; |
if (isset($GLOBALS['max_query_size']) && $GLOBALS['max_query_size'] > 0 && $query_size + strlen($insert_line) > $GLOBALS['max_query_size']) { |
if (!PMA_exportOutputHandler(';' . $crlf)) { |
return FALSE; |
} |
$query_size = 0; |
$current_row = 1; |
$insert_line = $schema_insert . $insert_line; |
} |
} |
$query_size += strlen($insert_line); |
} |
// Other inserts case |
else { |
$insert_line = $schema_insert . '(' . implode(', ', $values) . ')'; |
} |
} |
unset($values); |
|
if (!PMA_exportOutputHandler(($current_row == 1 ? '' : $separator . $crlf) . $insert_line)) { |
return FALSE; |
} |
|
} // end while |
if ($current_row > 0) { |
if (!PMA_exportOutputHandler(';' . $crlf)) { |
return FALSE; |
} |
} |
} // end if ($result != FALSE) |
PMA_DBI_free_result($result); |
|
return TRUE; |
} // end of the 'PMA_exportData()' function |
?> |