how to run sql statement using php and form

jrahma

Hi,

I want to ask how can I let the user enter sql statement such as select * from employees and when clicking submit button it shows the result in a <table>?

Thanks,
Jassim

laserlight

Err... why do you want to do this?

If you are looking to write a web based database administration tool, then perhaps you should install phpMyAdmin for MySQL or something similiar for whatever database system you have in mind, instead of writing your own. Or, it might be the case that you can actually access the database from some console interface, in which case you might well do that instead of installing a web based database administration tool.

jrahma

laserlight;11039115 wrote:
Err... why do you want to do this?

I have MySQL, SQl Server and PostgreSQL and I just want to build a simple SQL query tool for myself 🆒

Derokorian

so you want to enter a string into a textbox, press a submit button, pass that string to a database engine and display the results. This is no different than any other sql statement, but instead of defining the string in your code, you get it from $GET or $POST depending on how you set up your form.

So then... what have you tried that you are having issues with?

bradgrafelman

There's also the consideration of not trying to start all over with inventing the wheel... in other words, why not use existing products - phpMyAdmin, phpPgAdmin, etc. ?

jrahma

Derokorian;11039127 wrote:
So then... what have you tried that you are having issues with?

yes it's clear until here but the part of processing the sql statement and displaying the resulted columns

bradgrafelman

How is it different from any other SQL query you've ever executed and then processed its result set for display?