pcristian43 Posted December 13, 2014 Share Posted December 13, 2014 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? Link to comment https://forums.phpfreaks.com/topic/293071-creating-queries-from-a-form-dynamically/ Share on other sites More sharing options...
Jacques1 Posted December 13, 2014 Share Posted December 13, 2014 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? Link to comment https://forums.phpfreaks.com/topic/293071-creating-queries-from-a-form-dynamically/#findComment-1499474 Share on other sites More sharing options...
pcristian43 Posted December 13, 2014 Author Share Posted December 13, 2014 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. Link to comment https://forums.phpfreaks.com/topic/293071-creating-queries-from-a-form-dynamically/#findComment-1499477 Share on other sites More sharing options...
QuickOldCar Posted December 13, 2014 Share Posted December 13, 2014 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. Link to comment https://forums.phpfreaks.com/topic/293071-creating-queries-from-a-form-dynamically/#findComment-1499478 Share on other sites More sharing options...
Barand Posted December 13, 2014 Share Posted December 13, 2014 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 Link to comment https://forums.phpfreaks.com/topic/293071-creating-queries-from-a-form-dynamically/#findComment-1499489 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.