PHP Classes
elePHPant
Icontem

sqlmin: Access and administer MySQL and SQLite databases

Recommend this page to a friend!
  Info   View files View files (7)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2011-01-29 (5 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 563 This week: 2All time: 5,170 This week: 591Up
Version License PHP version Categories
sqlmin 1.0GNU General Publi...5.0PHP 5, Databases, Systems administration
Description Author

This package can be used to access and administer MySQL and SQLite databases.

There two classes, one for MySQL and SQLite that can perform several types of database access and administration functions.

Currently it can connect to a database, execute queries, retrieve the results into arrays, retrieve the tables of the database, retrieve the fields of the table, create a new database, generate a backup of a database with SQL statements, and import data into database table from a CSV file.

Picture of Livio Carmine
Name: Livio Carmine <contact>
Classes: 1 package by
Country: Italy Italy

Details
+============+
| 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 (javalc6@gmail.com)
  Files folder image Files  
File Role Description
Plain text file license.txt Lic. License
Plain text file mysql.class.php Class mysql class
Plain text file readme.txt Doc. readme
Plain text file sqlite.class.php Class sqlite class
Plain text file sqlmin.php Appl. Main script
Image file sqlmin.png Icon sqlmin 1.0 logo
Image file sshot_table_view.jpg Screen Administration view

 Version Control Unique User Downloads Download Rankings  
 0%
Total:563
This week:2
All time:5,170
This week:591Up