Help with my strarting my final year project

[taherali21]

HI i am going to create a tutorial in MySQL for my final year project. for this i have been searching the internet and on w3schools came a cross a sql tutorial in this i saw that they had created a text box where the user could practice sql commands i thought this was very use full and i would like to incorporate this in to mysql tutorial that i am doing for my final year project. could someone please help.

[WakeMeWithAKiss]

What programming language are you using ?
You might want to put really strict validation it, so people don't put harmful querys in.

[spikeZ]

It wouldnt matter as it would be a dump database that would be refreshed every (x) minutes or restored at the click of a button.

If you think about it, all you are doing is changing a typed query:

select 
      id
    , pageName
from
    myTable
where
    id = 2

and putting into a user inputted value. You dont say what language you are using but in php you would use something like:

$data = $_POST['data'];
mysql_query($data); 

as all you want to do is run the query.
You would need to check special characters and such like that would break the query but its not difficult.

[taherali21]

i am going to be using html and my sql

[guido2004]

i am going to be using html and my sql

To use MySQL, you'll need a server side language, like PHP. The output it creates is HTML. You can't access MySQL with HTML alone.

[taherali21]

i would like to jsp