PDO Multi-DB Info Manager is an application developed in PHP that allow you admin your SQL Server, PostgreSQL SQLite 3 and MySQL databases without the need of write any code(no php, neither sql) in an easy way, using an attractive web interface. You can do local and remote connection, export data from your tables in several file formats as CSV , Excel (XLS, XLSX), PDF, XML and SQL files. You can import information from CSV, Excel (XLS, XSLX) and SQL files, directly in the table that you choose. The application also allows you to consult, insert and edit the data saved in your database tables in a easy way and make customized searches on it, you can consult and export information from join tables without write sql code, also you can save your previous queries for consult them later. If you are skilled in SQL you can execute your own queries (Insert, Update, Select, Delete, Drop, Create, etc.) And export your results in CSV, XML, excel (XLS, XLSX) and PDF files. And finally you can create backup of the structure and data of your database, and restore it later. Or you can restore backups created for another application.
Features:
- Easy Installation
- Connect to a Database with PDO
- Allows local and remote connections
- You can save your connections settings from different databases. You only have to remember a password for use all your databases(SQL Server, PostgreSQL, SQLite 3 and MySQL)
- Compatible with MySQL, PostgreSQL, SQLite 3 and SQL Server Databases
- Support Windows and SQL Server Authentication for SQL Server Databases
- Export information to Excel(XLS, XLSX), XLM, CSV, PDF, XML and SQL files
- Export Custom Query Results in Excel(XLS, XLSX), XLM, CSV, PDF
- Import information from Excel(XLS, XLSX), CSV, and SQL files
- Create and Recover Backups
- Consult and edit tables in an easy way with pagination included
- Consult and export data from your customized join table queries in an easy way
- SQL Queries Visualization and Execution(Select, Insert, Update, Delete, Create, etc.)
- Implemenst Twitter Bootstrap
Requirements
- IE 8.x, Firefox, Chrome, Safari or Opera Navigator
- A Web Server to run PHP
- PHP 5.2 or later
- Any edition of MySQL 5 or later
- For use SQLite you will need a SQLite 3 database file (.s3db)
- Any edition of PostgreSQL 9 or later(You have to enable the extension php_pgsql.dll)
- Any edition of SQL Server 2005 or later (You have to download and install The Microsoft Drivers 3.0 for PHP and for PHP 5.4 or later you will need Microsoft® SQL Server® 2012 Native Client too)
- You need to have writing permissions in the directory where you will place the application.