A simple PHP application for exploring databases on a server. This tool allows you to:
- Display a list of databases on the server.
- Display tables from a selected database.
- View the structure of a selected table.
- View table data with pagination.
- Execute custom SQL queries and display the results.
The application uses PDO for database interactions and includes a user-friendly interface with collapsible navigation for better usability.
- Database Selection: Choose a database from a dropdown menu.
- Table Navigation: View tables in the selected database.
- Table Structure: Inspect the schema of the selected table.
- Data Pagination: Browse table data with paginated results.
- Custom Queries: Execute SQL queries and view the results in a formatted table.
- Collapsible Content: Toggle the visibility of table structures and data.
- PHP 5.4 or higher (optimized for PHP 5.x).
- A MySQL or MariaDB server accessible to the application.
- A web server capable of running PHP scripts (e.g., Apache, Nginx).
- Clone the repository or download the PHP file:
git clone https://github.com/kamshory/PHP-Database-Explorer.git