This is a PHP source code that outputs a reasonably readable table when you enter a SQL statement. I made it because it was annoying to have to export each query in phpmyadmin.
MariaDB
Apache
I built it in xampp. This source code is vulnerable because I don't intend to publish it as a web app.(I've taken some simple measures to prevent XSS.)
If you put the whole folder directly under htdocs, it works just like the pictures below.
This is the first screen, where you can enter a database name to specify. Databases that do not exist will be created automatically. You can execute any query such as CREATE TABLE, INSERT, UPDATE, DELETE, SELECT, etc. against the database you have created.
The result of the SELECT statement will be output in an easy-to-read format as shown above.
heabi
If you want to change the look and feel, please tweak the source code yourself. Also, pointing out vulnerable areas and suggestions for fixes are welcome!
Created on November 23, 2021.