|Last Updated||Ratings||Unique User Downloads||Download Rankings|
|2011-01-29 (6 years ago)||Not yet rated by the users||Total: 565||All time: 5,198 This week: 723|
|sqlmin 1.0||GNU General Publi...||5.0||PHP 5, Databases, Systems administration|
This package can be used to access and administer MySQL and SQLite databases.
+============+ | SQLmin.php | +============+ SQLmin is a minimalist administrator for SQLite and MySQL databases. The main script is sqlmin.php, where the administrator handling is implemented. This script imports another script that provides the class to handle a specific database, e.g. sqlite.class.php provides the handler for sqlite database. In order to install SQLMin, please follow the following steps: 1. Put the php files extracted from sqlmin.tar.gz in the main directory of the target web server. 2. Use your favorite browser to run the sqlmin.php script hosted in the web server. 3. The first time, the script will ask you to create an administrator login. 4. You MUST define a rule in file .htaccess to DENY user access to file 'sqlmin.cfg'. Scripts ======= sqlmin.php: main script sqlite.class.php: db handler for SQLite mysql.class.php: db handler for MySQL Requirements ============ The enclosed scripts run on PHP 5.x with SQLite or MySQL and GD support. +==================+ | IMPORTANT NOTICE | +==================+ This software is licensed under the terms of the GNU GENERAL PUBLIC LICENSE, please read the enclosed file license.txt or http://www.gnu.org/licenses/licenses.html Note that this software is freeware and it is not designed, licensed or intended for use in mission critical, life support and military purposes. The use of this software is at the risk of the user. +===================+ | SECURITY WARNINGS | +===================+ 1) after having installed this script on a web server, you MUST execute it as soon as possible in order to create the configuration file 'sqlmin.cfg' 2) you MUST define a rule in file .htaccess to DENY user access to file 'sqlmin.cfg', e.g. insert the following lines in .htaccess file: <Files ~ "\.cfg$"> Deny from all </Files> +=========+ | History | +=========+ version 1.00, 20-01-2011, stable release +===================+ | Known limitations | +===================+ 1) The rename of tables is not working with old sqlite versions. Solution: sqlite 3.1.2 or higher required. 2) Create new table not implemented 3) The listing of mysql databases may take long time on a web server with thousands of mysql databases and may return an error "500 Server Error". +========+ | Author | +========+ Livio (firstname.lastname@example.org)
|Version Control||Unique User Downloads||Download Rankings|