PHP实例开发源码-phpSQLiteAdmin 2 在线数据库管理php程序.zip

<?php /** phpSQLiteAdmin is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. phpSQLiteAdmin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with phpSQLiteAdmin; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA Copyright 2004 Richard Heyes Copyright 2006-2009 Marius Stanciu <marius.stanciu@code-purity.com> */ /** * Enter description here... * * @package phpSQLiteAdmin * @author Marius Stanciu Sergiu <marius.stanciu@code-purity.com> * @copyright Copyright (c) 2006-2009, Code Purity www.code-purity.com * @link http://blog.code-purity.com/pages/phpsqliteadmin * @since Version 0.1.0 */ include('config/config.php'); include($config['base_dir'].'include/initialize.php'); $do = intval($_GET['do']); switch ($do) { case 9: if (empty($_SESSION['database']['name'])) { common::redirect('index.php?do=9', common::lang('No database name given!')); } $DB = &database::singleton($_SESSION['database']['params']); $tables = sqlite::get_table_list(); $totalRecords = 0; $views = sqlite::get_view_list(); $filemtime = filemtime($_SESSION['database']['path']); $xDaysAgo = number_format((time() - $filemtime)/86400, 1).common::lang(' days ago'); $template = 'database.tpl'; break; case 1: if (empty($_SESSION['database']['name'])) { common::redirect('index.php?do=9', common::lang('No database name given!')); } if (isset($_GET['table'])) { $tableName = htmlspecialchars($_GET['table']); } else if (isset($_POST['table'])) { $tableName = htmlspecialchars($_POST['table']); } $DB = &database::singleton($_SESSION['database']['params']); if (!empty($_POST['sql'])) { $sql = $origSql = trim($_POST['sql']); $identifier = '([a-z][a-z0-9_]*|\[[a-z][a-z0-9_]*\])'; if (!preg_match('/\s+FROM\s+[a-z]/i', $sql) OR preg_match('/(NATURAL)?\s*(LEFT|RIGHT|FULL)?\s*(OUTER|INNER|CROSS)?\s*JOIN/i', $sql) OR preg_match("/\s+FROM\s+$identifier\s*,/i", $sql) OR preg_match('/^SELECT.+\(.+FROM/Ui', $sql)) { $showEditDelete = false; } else { preg_match("/\s+FROM\s+$identifier\s*/i", $sql, $matches); $tablename = $matches[1]; $showEditDelete = ($tablename != 'sqlite_master' ? true : false); } if (!preg_match('/LIMIT\s+([0-9]+)(\s+OFFSET\s+([0-9])+)?$/i', $sql, $matches) AND preg_match('/^SELECT/i', $sql)) { $sql .= ' LIMIT 30 OFFSET 0'; $limitNumber = 30; $offsetNumber = 0; } else { $limitNumber = @$matches[1]; $offsetNumber = @$matches[3]; } if (preg_match('/^select /i', $sql) AND $showEditDelete) { $sql = preg_replace('/^(select) /i', '$1 _ROWID_, ', $sql); } $result = $DB->query($sql); $querySuccessful = is_object($result) OR $result; $queryHasResults = is_object($result) AND $result->num_rows() > 0; if ($queryHasResults) { $resultsTable = array(); $headers = array(); while ($row = $result->fetch_row()) { $resultsRow = array(); if (empty($headers)) { $headers = array_slice(array_keys($row), $showEditDelete ? 1 : 0); } foreach ($row as $k => $v) { if ($k == '_ROWID_' AND empty($resultsRow) AND $showEditDelete) { $resultsRow[] = sprintf('<nobr><a href="%s" title="%s"><span class="ui-icon ui-icon-document"></span></a> <a href="%s" title="%s" onclick="return confirm(\'%s\')"><span class="ui-icon ui-icon-trash"></a></nobr>', common::url("index.php?do=3&action=edit&table=$tablename&rowid=$v&redirect=".rawurlencode(common::url())), common::lang('Edit'), common::url("index.php?do=3&action=delete&table=$tablename&rowid=$v&redirect=".rawurlencode(common::url())), common::lang('Delete'), common::lang('Are you sure you want to delete this row?')); } else { $resultsRow[] = $v; } } $resultsTable[] = $resultsRow; } } } $origSql = "SELECT * FROM ".htmlspecialchars($tableName); $template = 'query.tpl'; break; case 2: if (empty($_SESSION['database']['name'])) { common::redirect('index.php?do=9', common::lang('No database name given!')); } if (empty($_GET['table'])) { common::redirect('index.php?do=9', common::lang('No table given!')); } else { $tableName = htmlspecialchars($_GET['table']); } $DB = &database::singleton($_SESSION['database']['params']); switch (@$_GET['action']) { case 'addindex': if (!empty($_GET['column']) AND !empty($_GET['index'])) { $index = htmlspecialchars($_GET['index']); $column = htmlspecialchars($_GET['column']); $unique = !empty($_GET['unique']) ? 'UNIQUE' : ''; $result = $DB->query("CREATE $unique INDEX $index ON $tableName ($column)"); $message = $result ? null : common::lang('Failed to create index, SQLite said: ').$DB->get_last_error(); common::redirect("index.php?do=2&table=$tableName", $message); } else common::redirect("index.php?do=2&table=$tableName", common::lang('Column or index name missing - cannot create index')); break; case 'dropindex': if (!empty($_GET['index'])) { $index = htmlspecialchars($_GET['index']); $result = $DB->query("DROP INDEX $index"); $message = $result ? null : common::lang('Failed to create index, SQLite said: ').$DB->get_last_error(); common::redirect("index.php?do=2&table=$tableName", $message); } else { common::redirect("index.php?do=2table=$tableName", common::lang('Index name missing - cannot drop index')); } break; case 'empty': $result = $DB->query("DELETE FROM $tableName"); $message = $result ? sprintf(common::lang('Table %s was emptied'), $tableName) : common::lang('Failed to empty table!'); $redirect = !empty($_GET['redirect']) ? htmlspecialchars($_GET['redirect']) : 'index.php?do=9'; common::redirect($redirect, $message); break; case 'drop': $result = $DB->query("DROP TABLE $tableName"); $message = $result ? sprintf(common::lang('Table %s was dropped'), $tableName) : 'Failed to empty table!'; $redirect = !empty($_GET['redirect']) ? htmlspecialchars($_GET['redirect']) : 'index.php?do=9'; common::redirect($redirect, $message); break; default: $structure = sqlite::get_table_structure($tableName); $rowCount = count($structure); $indexes = sqlite::get_index_list($tableName, true); break; } $template = 'table.tpl'; break; case 3: if (empty($_SESSION['database']['name'])) { common::redirect('index.php?do=9', common::lang('No database name given!')); } if (empty($_GET['table'])) { common::redirect('index.php?do=9', common::lang('No table given!')); } else { $tableName = htmlspecialchars($_GET['table']); } if ($_GET['action'] != 'insert') { if (empty($_GET['rowid'])) { common::redirect("index.php?do=2&table=$tableName", common::lang('No row ID given!')); } else { $rowID = htmlspecialchars($_GET['rowid']); } } switch ($_GET['action']) { case 'delete': $result = sqlite::delete_row($rowID, $tableName); common::redirect(htmlspecialchars($_GET['redirect']), $result ? common::lang('Row deleted') : common::lang('Failed to delete row!')); break; case 'edit': $isUpdate = true; $isInsert = false; $DB = &database::singleton($_SESSION['database']['params']); sqlite::get_user_functions(); if (!empty($_POST))