/**
* Adds backquotes on both sides of a database, table or field name.
* and escapes backquotes inside the name with another backquote
*
* example:
* <code>
* echo backquote('owner`s db'); // `owner``s db`
*
* </code>
*
* @param mixed $a_name the database, table or field name to "backquote"
* or array of it
* @param boolean $do_it a flag to bypass this function (used by dump
* functions)
*
* @return mixed the "backquoted" database, table or field name
*
* @access public
*/
static function backquote($a_name)
{
if (is_array($a_name)) {
foreach ($a_name as &$data) {
$data = backquote($data);
}
return $a_name;
}
// '0' is also empty for php :-(
if (strlen($a_name) && $a_name !== '*') {
return '`' . str_replace('`', '``', $a_name) . '`';
} else {
return $a_name;
}
}
}
$formatted_db_name = isset($use_backquotes) ? backquote($db) : '\'' . $db . '\'';
$dump_buffer .= $crlf . '# ' . $strGenTime . ': ' . date('F j, Y, g:i a') . $crlf . '# ' . $strServerVersion . ': ' . substr(MYSQL_INT_VERSION, 0, 1) . '.' . substr(MYSQL_INT_VERSION, 1, 2) . '.' . substr(MYSQL_INT_VERSION, 3) . $crlf . '# ' . $strPHPVersion . ': ' . phpversion() . $crlf . '# ' . $strDatabase . ': ' . $formatted_db_name . $crlf;
$i = 0;
if (isset($table_select)) {
$tmp_select = implode($table_select, '|');
$tmp_select = '|' . $tmp_select . '|';
}
while ($i < $num_tables) {
if (!isset($single)) {
$table = mysql_tablename($tables, $i);
}
if (isset($tmp_select) && is_int(strpos($tmp_select, '|' . $table . '|')) == FALSE) {
$i++;
} else {
$formatted_table_name = isset($use_backquotes) ? backquote($table) : '\'' . $table . '\'';
// If only datas, no need to displays table name
if ($what != 'dataonly') {
$dump_buffer .= '# --------------------------------------------------------' . $crlf . $crlf . '#' . $crlf . '# ' . $strTableStructure . ' ' . $formatted_table_name . $crlf . '#' . $crlf . $crlf . get_table_def($db, $table, $crlf) . ';' . $crlf;
}
// At least data
if ($what == 'data' || $what == 'dataonly') {
$dump_buffer .= $crlf . '#' . $crlf . '# ' . $strDumpingData . ' ' . $formatted_table_name . $crlf . '#' . $crlf . $crlf;
$tmp_buffer = '';
if (!isset($limit_from) || !isset($limit_to)) {
$limit_from = $limit_to = 0;
}
get_table_content($db, $table, $limit_from, $limit_to, 'my_handler');
$dump_buffer .= $tmp_buffer;
}
// end if
function make_sql($table, $sql_drop_table = true)
{
/*
Reads the Database table in $table and creates
SQL Statements for recreating structure and data
*/
$sql_statements = "";
// Add SQL statement to drop existing table
/*
//$sql_statements .= "\n";
$sql_statements .= "\n";
$sql_statements .= "#\n";
$sql_statements .= "# Delete any existing table " . backquote($table) . "\n";
$sql_statements .= "#\n";
//$sql_statements .= "\n";*/
if ($sql_drop_table) {
$sql_statements .= "DROP TABLE IF EXISTS " . backquote($table) . ";\n";
}
// Table structure
// Comment in SQL-file
//$sql_statements .= "\n";
//$sql_statements .= "\n";
//$sql_statements .= "#\n";
//$sql_statements .= "# Table structure of table " . backquote($table) . "\n";
//$sql_statements .= "#\n";
//$sql_statements .= "\n";
// Get table structure
$query = "SHOW CREATE TABLE " . backquote($table);
$result = mysql_query($query, $GLOBALS["db_connect"]);
if ($result == FALSE) {
log_msg(date("H:i:s") . ": Error getting table structure of {$table}!\n", 20);
log_msg(" " . mysql_errno() . ": " . mysql_error() . "\n", 20);
} else {
if (mysql_num_rows($result) > 0) {
$sql_create_arr = mysql_fetch_array($result);
$sql_statements .= $sql_create_arr[1];
}
mysql_free_result($result);
$sql_statements .= " ;";
}
// ($result == FALSE)
// Table data contents
// Get table contents
$query = "SELECT * FROM " . backquote($table);
$result = mysql_query($query, $GLOBALS["db_connect"]);
if ($result == FALSE) {
log_msg(date("H:i:s") . ": Error getting records of {$table}!\n", 30);
log_msg(" " . mysql_errno() . ": " . mysql_error() . "\n", 30);
} else {
$fields_cnt = mysql_num_fields($result);
$rows_cnt = mysql_num_rows($result);
}
// if ($result == FALSE)
// Comment in SQL-file
//$sql_statements .= "\n";
//$sql_statements .= "\n";
//$sql_statements .= "#\n";
$sql_statements .= "# Data contents of table " . $table . " (" . $rows_cnt . " records)\n";
//$sql_statements .= "#\n";
// Checks whether the field is an integer or not
for ($j = 0; $j < $fields_cnt; $j++) {
$field_set[$j] = backquote(mysql_field_name($result, $j));
$type = mysql_field_type($result, $j);
if ($type == 'tinyint' || $type == 'smallint' || $type == 'mediumint' || $type == 'int' || $type == 'bigint') {
$field_num[$j] = TRUE;
} else {
$field_num[$j] = FALSE;
}
}
// end for
// Sets the scheme
$_entries = 'INSERT INTO ' . backquote($table) . ' VALUES';
$sql_statements .= "\n" . $_entries;
$entries = "\n (";
$search = array("", "\n", "\r", "");
//\x08\\x09, not required
$replace = array('\\0', '\\n', '\\r', '\\Z');
$current_row = 0;
$_entries_count = 0;
while ($row = mysql_fetch_row($result)) {
$current_row++;
for ($j = 0; $j < $fields_cnt; $j++) {
if (!isset($row[$j])) {
$values[] = 'NULL';
} else {
if ($row[$j] == '0' || $row[$j] != '') {
// a number
if ($field_num[$j]) {
$values[] = $row[$j];
} else {
$values[] = "'" . str_replace($search, $replace, sql_addslashes($row[$j])) . "'";
}
//if ($field_num[$j])
} else {
$values[] = "''";
}
}
// if (!isset($row[$j]))
}
// for ($j = 0; $j < $fields_cnt; $j++)
$sql_statements .= $entries . implode(', ', $values) . ')';
$_entries_count++;
//break in processes of 100 rows
if ($_entries_count % 100 == 0) {
$sql_statements .= ";\n" . $_entries;
} else {
$sql_statements .= ",";
}
unset($values);
}
// while ($row = mysql_fetch_row($result))
mysql_free_result($result);
if (endsWith($sql_statements, ",")) {
$sql_statements = substr($sql_statements, 0, strlen($sql_statements) - 1);
} else {
if (endsWith($sql_statements, $_entries)) {
$sql_statements = substr($sql_statements, 0, strlen($sql_statements) - strlen($_entries));
}
}
$sql_statements .= ";\n";
// Create footer/closing comment in SQL-file
//$sql_statements .= "\n";
//$sql_statements .= "#\n";
//$sql_statements .= "# End of data contents of table " . $table . "\n";
//$sql_statements .= "# --------------------------------------------------------\n";
//$sql_statements .= "\n";
return $sql_statements;
}
}
if (strlen($escaped) > 0) {
$query .= ' ESCAPED BY \'' . $escaped . '\'';
}
if (strlen($line_terminator) > 0) {
$query .= ' LINES TERMINATED BY \'' . $line_terminator . '\'';
}
if (strlen($column_name) > 0) {
if (MYSQL_INT_VERSION >= 32306) {
$query .= ' (';
$tmp = split(',( ?)', $column_name);
for ($i = 0; $i < count($tmp); $i++) {
if ($i > 0) {
$query .= ', ';
}
$query .= backquote(trim($tmp[$i]));
}
// end for
$query .= ')';
} else {
$query .= ' (' . $column_name . ')';
}
}
// Executes the query
// sql.php will stripslash the query if 'magic_quotes_gpc' is set to on
if (get_magic_quotes_gpc()) {
$sql_query = addslashes($query);
} else {
$sql_query = $query;
}
include './sql.php';
$query .= ' DEFAULT \'' . sql_addslashes($field_default[0]) . '\'';
}
}
if ($field_null[0] != '') {
$query .= ' ' . $field_null[0];
}
if ($field_extra[0] != '') {
$query .= ' ' . $field_extra[0];
}
// Optimization fix - 2 May 2001 - Robbat2
$sql_query = 'ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' CHANGE ' . $query;
$result = mysql_query($sql_query) or mysql_die();
$message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered;
include './tbl_properties.php';
exit;
} else {
if (get_magic_quotes_gpc()) {
$field = sql_addslashes(stripslashes($field), TRUE);
} else {
$field = sql_addslashes($field, TRUE);
}
$local_query = 'SHOW FIELDS FROM ' . backquote($db) . '.' . backquote($table) . " LIKE '{$field}'";
$result = mysql_query($local_query) or mysql_die('', $local_query);
$num_fields = mysql_num_rows($result);
$action = 'tbl_alter.php';
include './tbl_properties.inc.php';
}
/**
* Displays the footer
*/
require './footer.inc.php';
}
$source = backquote($db) . '.' . backquote($table);
$target = backquote($target_db) . '.' . backquote($new_name);
$sql_structure = get_table_def($db, $table, "\n");
$sql_structure = eregi_replace('^CREATE TABLE (`?)' . $table . '(`?)', 'CREATE TABLE ' . $target, $sql_structure);
$result = mysql_query($sql_structure) or mysql_die('', $sql_structure);
if (isset($sql_query)) {
$sql_query .= "\n" . $sql_structure . ';';
} else {
$sql_query = $sql_structure . ';';
}
// Copy the data
if ($result != FALSE && $what == 'data') {
// speedup copy table - staybyte - 22. Juni 2001
if (MYSQL_INT_VERSION >= 32300) {
$sql_insert_data = 'INSERT INTO ' . $target . ' SELECT * FROM ' . backquote($table);
$result = mysql_query($sql_insert_data) or mysql_die('', $sql_insert_data);
} else {
$sql_insert_data = '';
get_table_content($db, $table, 0, 0, 'my_handler');
}
// end MySQL < 3.23
$sql_query .= "\n\n" . $sql_insert_data;
}
$message = sprintf($strCopyTableOK, $source, $target);
$reload = 'true';
} else {
mysql_die($strTableEmpty);
}
/**
* Back to the calling script
<?php
/* $Id: db_create.php,v 1.8 2001/08/22 20:42:51 loic1 Exp $ */
/**
* Gets some core libraries
*/
require './grab_globals.inc.php';
require './header.inc.php';
/**
* Executes the db creation sql query
*/
$local_query = 'CREATE DATABASE ' . backquote($db);
$result = mysql_query('CREATE DATABASE ' . backquote($db)) or mysql_die('', $local_query, FALSE);
/**
* Displays the result and moves back to the calling page
*/
$message = $strDatabase . ' ' . htmlspecialchars($db) . ' ' . $strHasBeenCreated;
require './db_details.php';
} else {
if (strstr($fields[$i], '%')) {
$quot = '\'';
$cmp = 'LIKE';
} else {
if (substr($fields[$i], 0, 1) == '<' || substr($fields[$i], 0, 1) == '>') {
$quot = '';
$cmp = '';
} else {
$quot = '';
$cmp = '=';
}
}
}
}
}
// end if
$sql_query .= ' AND ' . backquote(urldecode($names[$i])) . " {$cmp} {$quot}{$fields[$i]}{$quot}";
}
// end if
}
// end for
}
// end if
if ($orderField != '--nil--') {
$sql_query .= ' ORDER BY ' . backquote(urldecode($orderField)) . ' ' . $order;
}
// end if
$url_query = 'lang=' . $lang . '&server=' . $server . '&db=' . urlencode($db) . '&table=' . urlencode($table) . '&sql_query=' . urlencode($sql_query) . '&pos=0' . '&sessionMaxRows=' . $sessionMaxRows . '&goto=' . $goto;
header('Location: ' . $cfgPmaAbsoluteUri . 'sql.php?' . $url_query);
}
}
if (!empty($primary_key)) {
$primary_key = stripslashes($primary_key);
}
}
/**
* Get the list of the fields of the current table
*/
mysql_select_db($db);
$table_def = mysql_query('SHOW FIELDS FROM ' . backquote($table));
if (isset($primary_key)) {
$local_query = 'SELECT * FROM ' . backquote($table) . ' WHERE ' . $primary_key;
$result = mysql_query($local_query) or mysql_die('', $local_query);
$row = mysql_fetch_array($result);
} else {
$local_query = 'SELECT * FROM ' . backquote($table) . ' LIMIT 1';
$result = mysql_query($local_query) or mysql_die('', $local_query);
}
/**
* Displays the form
*/
?>
<!-- Change table properties form -->
<form method="post" action="tbl_replace.php">
<input type="hidden" name="server" value="<?php
echo $server;
?>
" />
<input type="hidden" name="lang" value="<?php
echo $lang;
/**
* Deletes a bookmark
*
* @param string the current database name
* @param array the bookmark parameters for the current user
* @param integer the id of the bookmark to get
*/
function delete_bookmarks($db, $cfgBookmark, $id)
{
$query = 'DELETE FROM ' . backquote($cfgBookmark['db']) . '.' . backquote($cfgBookmark['table']) . ' WHERE user = \'' . sql_addslashes($cfgBookmark['user']) . '\'' . ' AND id = ' . $id;
if (isset($GLOBALS['dbh'])) {
$result = mysql_query($query, $GLOBALS['dbh']);
} else {
$result = mysql_query($query);
}
}
function grant_operations()
{
global $server, $lang, $user, $host;
global $dbgrant, $tablegrant;
global $self;
global $strBack, $strGo;
global $strDbEmpty, $strTableEmpty;
global $strAddPriv, $strAddPrivMessage;
global $strDatabase, $strAnyDatabase;
global $strTable, $strAnyTable;
global $strColumn, $strAnyColumn, $strColumnEmpty;
global $strPrivileges;
?>
<script language="JavaScript">
<!--
function getSelected(field) {
var f = "";
for (var i = 0; i < field.options.length; i++)
if (field.options[i].selected)
f += field.options[i].text + ", ";
return f.substring(0, f.length - 2);
}
function addGrant(f) {
var sql;
var db, table, column = "";
db = getSelected(f.database);
table = getSelected(f.table);
column = getSelected(f.column);
if (f.anydb[1].checked) {
if (db == "") {
alert("<?php
echo $strDbEmpty;
?>
");
return;
}
if (f.anytable[1].checked) {
if (table == "") {
alert("<?php
echo $strTableEmpty;
?>
");
return;
}
if (f.anycolumn[1].checked) {
if (column == "") {
alert("<?php
echo $strColumnEmpty;
?>
");
return;
}
column = " (" + column + ")";
} else column = "";
} else {table = "*"; column = ""; }
} else { db = "*"; table = "*"; column = ""; }
sql = "GRANT " + privGrantToString(f) + "" + column;
sql += " ON " + protect_name(db) + "." + protect_name(table)
sql += " TO '" + "<?php
echo $user;
?>
" + "'@'" + "<?php
echo $host;
?>
'"
if (f.Grant_priv.checked) sql += " with grant option";
url = "sql.php";
url += "?sql_query=" + escape(sql);
url += "&zero_rows=" + escape("<?php
echo $strAddPrivMessage;
?>
");
url += "<?php
echo "&server={$server}&lang={$lang}";
?>
&db=mysql";
url += "&goto=<?php
echo $self;
?>
";
location.href = url;
}
function protect_name(db_or_table) {
var js_mysql_version = <?php
echo MYSQL_INT_VERSION;
?>
;
if (js_mysql_version >= 32306) {
<!-- return "`" + db_or_table + "`"; -->
return db_or_table;
}
else {
return db_or_table;
}
}
function change(f, param) {
var l, p;
l = location.href;
if (param == "dbgrant") {
p = l.indexOf("&" + param);
if ( p >= 0) l = l.substring(0, p);
}
location.href = l + "&" + param + "=" + getSelected(f);
}
// -->
</script>
<div align=left>
<ul>
<li><a href="<?php
echo "{$self}?server={$server}&lang={$lang}&db=mysql&table=user";
?>
"><?php
echo $strBack;
?>
</a></li>
<li><form name=userForm3 onsubmit ="return false"><?php
echo $strAddPriv;
?>
<table width="100%"><tr>
<td><input type="radio" name="anydb"<?php
echo $dbgrant ? "" : " checked";
?>
><?php
echo $strAnyDatabase;
?>
</td>
<td> </td>
<td><input type="radio" name="anydb"<?php
echo $dbgrant ? " checked" : "";
?>
><?php
echo $strDatabase;
?>
:
<select name="database" onchange="change(userForm3.database, 'dbgrant')">
<?php
if (!isset($dbgrant)) {
echo "<option selected></option>";
}
$result = mysql_query("SHOW DATABASES");
if (@mysql_num_rows($result)) {
while ($row = mysql_fetch_row($result)) {
$selected = $row[0] == $dbgrant ? "SELECTED" : "";
echo "<option {$selected}>" . $row[0] . "</option>\n";
}
}
?>
</select></td>
</tr></table>
<table width="100%"><tr>
<td><input type="radio" name="anytable"<?php
echo $tablegrant ? "" : " checked";
?>
><?php
echo $strAnyTable;
?>
</td>
<td> </td>
<td><input type="radio" name="anytable"<?php
echo $tablegrant ? " checked" : "";
?>
><?php
echo $strTable;
?>
:
<select name="table" onchange="change(userForm3.table, 'tablegrant')"
>
<?php
if (isset($dbgrant)) {
if (!isset($tablegrant)) {
echo "<option selected></option>";
}
$result = mysql_query("SHOW TABLES from " . backquote($dbgrant));
if (@mysql_num_rows($result)) {
while ($row = mysql_fetch_row($result)) {
$selected = $row[0] == $tablegrant ? "SELECTED" : "";
echo "<option {$selected}>" . $row[0] . "</option>\n";
}
}
}
?>
</select></td>
</tr></table>
<table width="100%"><tr>
<td VALIGN=TOP><input type="radio" name="anycolumn" checked><?php
echo $strAnyColumn;
?>
</td>
<td> </td>
<td VALIGN=TOP><input type="radio" name="anycolumn"><?php
echo $strColumn;
?>
:</td>
<td>
<select name="column" onchange="anycolumn[1].checked = true" multiple>
<?php
if (isset($dbgrant) && isset($tablegrant)) {
$result = mysql_query("SHOW COLUMNS FROM " . backquote($dbgrant) . "." . backquote($tablegrant));
if (@mysql_num_rows($result)) {
while ($row = mysql_fetch_row($result)) {
echo "<option>" . $row[0] . "</option>\n";
}
}
}
?>
</select>
</td>
</tr></table>
<table><tr><td><br><?php
echo $strPrivileges;
?>
:<br></td></tr></table>
<?php
table_privileges("userForm3");
?>
<input type="button" value="<?php
echo $strGo;
?>
" onclick="addGrant(userForm3)"></p>
</form>
</li>
</ul>
</div>
<?php
}
$big_tot_data = 0;
$results_array = array();
// Gets and displays the tables stats per database
for ($i = 0; $i < $num_dbs; $i++) {
$db = $dblist[$i];
$j = $i + 2;
$bgcolor = $i % 2 ? $cfgBgcolorOne : $cfgBgcolorTwo;
if (!empty($db_start) && $db == $db_start) {
$selected_db = $j;
}
$tables = @mysql_list_tables($db);
$num_tables = @mysql_numrows($tables);
$tot_tables += $num_tables;
$common_url_query = 'lang=' . $lang . '&server=' . $server . '&db=' . urlencode($db);
// Gets size of data and indexes
$db_clean = backquote($db);
$tot_data = 0;
$tot_idx = 0;
$tot_all = 0;
$local_query = 'SHOW TABLE STATUS FROM ' . $db_clean;
$result = @mysql_query($local_query);
if (@mysql_num_rows($result)) {
// needs the "@": otherwise, warnings in case of special DB names:
// Warning: Supplied argument is not a valid MySQL result resource in db_stats.php on line 140
while ($row = mysql_fetch_array($result)) {
$tot_data += $row['Data_length'];
$tot_idx += $row['Index_length'];
}
$tot_all = $tot_data + $tot_idx;
$big_tot_all += $tot_all;
$big_tot_idx += $tot_idx;
<?php
/* $Id: tbl_rename.php,v 1.7 2001/08/22 20:42:51 loic1 Exp $ */
/**
* Gets some core libraries
*/
require './grab_globals.inc.php';
require './lib.inc.php';
/**
* A new name has been submitted -> do the work
*/
if (isset($new_name) && trim($new_name) != '') {
$old_name = $table;
$table = $new_name;
include './header.inc.php';
mysql_select_db($db);
$local_query = 'ALTER TABLE ' . backquote($old_name) . ' RENAME ' . backquote($new_name);
$result = mysql_query($local_query) or mysql_die('', $local_query);
$message = sprintf($strRenameTableOK, $old_name, $table);
$reload = 'true';
} else {
include './header.inc.php';
mysql_die($strTableEmpty);
}
/**
* Back to the calling script
*/
require './tbl_properties.php';
close_daily($fp, $keep_days);
// Do we have to do a weekly backup? (separate sql-file for every table)
if (date("w") == $weekday) {
weekly_backup($fname, $keep_weeks);
}
// if (date("w") ...
// Do we have to do a monthly backup? (separate sql-file for every table)
if (date("j") == date("t") or date("j") == $monthday) {
monthly_backup($fname, $keep_months);
}
// if ((date("j") ...
}
// if ($fp = open_daily($fname))
} else {
$sql_file .= "# --------------------------------------------------------\n";
$sql_file .= "# Table: " . backquote($curr_table) . "\n";
$sql_file .= "# --------------------------------------------------------\n";
$sql_file .= $sql_statements;
}
// if ($db_backup_sql_single_file == FALSE)
log_msg(date("H:i:s") . ": Backup of table {$db_name}.{$curr_table} finished.\n");
} else {
log_msg(date("H:i:s") . ": Table {$curr_table} is excluded from backup.\n");
}
// if (!in_array($curr_table, $exclude_tables))
log_msg($sep);
}
// for ($i = 0; $i < mysql_num_rows($tables); $i++)
$sql_file .= $file_footer;
// Do we use only one single sql-file for all tables?
if ($sql_single_file) {
if (!empty($qry_select)) {
$encoded_qry .= urlencode('SELECT ' . $qry_select . "\n");
echo 'SELECT ' . htmlspecialchars($qry_select) . "\n";
}
// 2. FROM
if (!isset($TableList)) {
$TableList = array();
}
if (!isset($qry_from)) {
$qry_from = '';
}
for ($x = 0; $x < sizeof($TableList); $x++) {
if ($x) {
$qry_from .= ', ';
}
$qry_from .= backquote(urldecode($TableList[$x]));
}
// end for
if (!empty($qry_from)) {
$encoded_qry .= urlencode('FROM ' . $qry_from . "\n");
echo 'FROM ' . htmlspecialchars($qry_from) . "\n";
}
// 3. WHERE
$qry_where = '';
$criteria_cnt = 0;
for ($x = 0; $x < $col; $x++) {
if (!empty($curField[$x]) && !empty($curCriteria[$x]) && $x && isset($last_where)) {
$qry_where .= ' ' . strtoupper($curAndOrCol[$last_where]) . ' ';
}
if (!empty($curField[$x]) && !empty($curCriteria[$x])) {
$qry_where .= '(' . $curField[$x] . ' ' . $curCriteria[$x] . ')';
$sql_query .= "\n" . 'ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD INDEX (' . $index . ')';
$result = mysql_query('ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD INDEX (' . $index . ')') or mysql_die();
}
}
// end if
// Builds the uniques statements and updates the table
$unique = '';
if (isset($field_unique)) {
for ($i = 0; $i < count($field_unique); $i++) {
$j = $field_unique[$i];
$unique .= backquote($field_name[$j]) . ', ';
}
// end for
$unique = ereg_replace(', $', '', $unique);
if (!empty($unique)) {
$sql_query .= "\n" . 'ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD UNIQUE (' . $unique . ')';
$result = mysql_query('ALTER TABLE ' . backquote($db) . '.' . backquote($table) . ' ADD UNIQUE (' . $unique . ')') or mysql_die();
}
}
// end if
// Go back to table properties
$message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered;
include './tbl_properties.php';
exit;
} else {
$action = 'tbl_addfield.php';
include './tbl_properties.inc.php';
// Diplays the footer
echo "\n";
include './footer.inc.php';
}
echo show_docu('manual_Reference.html#OPTIMIZE_TABLE') . "\n";
?>
</li>
<?php
echo "\n";
}
// end MySQL < 3.23
?>
<!-- Deletes the table -->
<li>
<a href="sql.php?<?php
echo ereg_replace('tbl_properties.php$', 'db_details.php', $url_query);
?>
&back=tbl_properties.php&reload=true&sql_query=<?php
echo urlencode('DROP TABLE ' . backquote($table));
?>
&zero_rows=<?php
echo urlencode($strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenDropped);
?>
">
<?php
echo $strDropTable . ' ' . htmlspecialchars($table);
?>
</a>
</li>
</ul>
<?php
/**
?>
</td>
</tr>
<?php
}
// end while
echo "\n";
?>
</table>
<?php
/**
* Displays indexes
*/
$local_query = 'SHOW KEYS FROM ' . backquote($table);
$result = mysql_query($local_query) or mysql_die('', $local_query);
if (mysql_num_rows($result) > 0) {
?>
<!-- Indexes -->
<br />
<?php
echo $strIndexes . ' :' . "\n";
?>
<table border="<?php
echo $cfgBorder;
?>
">
<tr>
<th><?php
<!-- Drop database -->
<li>
<a href="sql.php?server=<?php
echo $server;
?>
&lang=<?php
echo $lang;
?>
&db=<?php
echo urlencode($db);
?>
&sql_query=<?php
echo urlencode('DROP DATABASE ' . backquote($db));
?>
&zero_rows=<?php
echo urlencode($strDatabase . ' ' . htmlspecialchars(backquote($db)) . ' ' . $strHasBeenDropped);
?>
&goto=main.php&back=db_details.php&reload=true">
<?php
echo $strDropDB . ' ' . htmlspecialchars($db);
?>
</a>
<?php
echo show_docu('manual_Reference.html#DROP_DATABASE') . "\n";
?>
</li>
<?php
}
echo "\n";
?>
}
for ($i = 0; $i < count($field_unique); $i++) {
$j = $field_unique[$i];
if (!empty($field_name[$j])) {
$unique .= backquote($field_name[$j]) . ', ';
}
}
// end for
$unique = ereg_replace(', $', '', $unique);
if (!empty($unique)) {
$unique = ', UNIQUE (' . $unique . ')';
}
$query_keys = $primary . $index . $unique;
$query_keys = ereg_replace(', $', '', $query_keys);
// Builds the 'create table' statement
$sql_query = 'CREATE TABLE ' . backquote($table) . ' (' . $query . ' ' . $query_keys . ')';
// Adds table type (2 May 2001 - Robbat2)
if (!empty($tbl_type) && $tbl_type != 'Default') {
$sql_query .= ' TYPE = ' . $tbl_type;
}
if (MYSQL_INT_VERSION >= 32300 && !empty($comment)) {
$sql_query .= ' comment = \'' . sql_addslashes($comment) . '\'';
}
// Executes the query
$result = mysql_query($sql_query) or mysql_die();
$message = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenCreated;
include './tbl_properties.php';
exit;
} else {
if (isset($num_fields)) {
$num_fields = intval($num_fields);
// end switch
if (empty($funcs[$encoded_key])) {
$valuelist .= $val . ', ';
} else {
if ($val == '\'\'' && ereg('^(NOW|CURDATE|CURTIME|UNIX_TIMESTAMP|RAND|USER|LAST_INSERT_ID)$', $funcs[$encoded_key])) {
$valuelist .= $funcs[$encoded_key] . '(), ';
} else {
$valuelist .= $funcs[$encoded_key] . "({$val}), ";
}
}
}
// end while
// Builds the sql insert query
$fieldlist = ereg_replace(', $', '', $fieldlist);
$valuelist = ereg_replace(', $', '', $valuelist);
$query = 'INSERT INTO ' . backquote($table) . ' (' . $fieldlist . ') VALUES (' . $valuelist . ')';
$message = $strInsertedRows . ' ';
}
// end row insertion
/**
* Executes the sql query and get the result, then move back to the calling
* page
*/
mysql_select_db($db);
$sql_query = $query;
$result = mysql_query($query);
if (!$result) {
$error = mysql_error();
include './header.inc.php';
mysql_die($error);
} else {
</div>
<div id="el2Child" class="child" style="margin-bottom: 5px">
<?php
// Displays the list of tables from the current database
for ($j = 0; $j < $num_tables; $j++) {
$table = mysql_tablename($tables, $j);
echo "\n";
?>
<nobr><a target="phpmain" href="sql.php?<?php
echo $common_url_query;
?>
&table=<?php
echo urlencode($table);
?>
&sql_query=<?php
echo urlencode('SELECT * FROM ' . backquote($table));
?>
&pos=0&goto=tbl_properties.php">
<img src="browse.gif" border="0" alt="<?php
echo "{$strBrowse}: {$table}";
?>
" /></a>
<a class="tblItem" target="phpmain" href="tbl_properties.php?<?php
echo $common_url_query;
?>
&table=<?php
echo urlencode($table);
?>
">
<?php
echo $table;
