Creating queries from a form dynamically

[pcristian43]

I was thinking of adding queries using a basic HTML form. To be able to do that I was thinking of having a Query sql table which has all the main create, insert, remove, update, delete and select general syntax into it. The idea is to be able to choose a query based on a HTML select option and add the values to a field, any idea how can you do that dynamically?

[Jacques1]

This sounds super-weird and super-dangerous. If the query table gets compromised, you've just turned your entire application into a kind of phpmyadmin for hackers.

 

What are trying to achieve? I mean the underlying problem, not what you think solves it. Do you want to build a database administration tool? Or do you simply want users to change data?

[pcristian43]

This sounds super-weird and super-dangerous. If the query table gets compromised, you've just turned your entire application into a kind of phpmyadmin for hackers.

 

What are trying to achieve? I mean the underlying problem, not what you think solves it. Do you want to build a database administration tool? Or do you simply want users to change data?

I am trying to build a sql administration app, I know there are some out there but I wanna sharpen my skills.

[QuickOldCar]

You could start by finding all the databases,tables,columns.

SHOW DATABASES

SHOW TABLES

SHOW COLUMNS

 

Loop each to get all the results, easier to make functions for them.

Do normal queries using the data you discovered.

[Barand]

Following on from what QuickOldCar said, here's some code I put together many months ago. It should get you started.

dbAdmin.php

dbAdmin_ajax_c.php

dbAdmin_ajax_p.php

dbAdmin_ajax_t.php