SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Help with my strarting my final year project

    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.

  2. #2
    SitePoint Enthusiast
    Join Date
    Mar 2007
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What programming language are you using ?
    You might want to put really strict validation it, so people don't put harmful querys in.

  3. #3
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,788
    Mentioned
    153 Post(s)
    Tagged
    3 Thread(s)
    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:
    Code:
    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:
    PHP Code:
    $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.
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  4. #4
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i am going to be using html and my sql

  5. #5
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,404
    Mentioned
    149 Post(s)
    Tagged
    4 Thread(s)
    Quote Originally Posted by taherali21 View Post
    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.

  6. #6
    SitePoint Member
    Join Date
    Oct 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i would like to jsp


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •