Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Oct 2008
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Getting SQL data into web page - what language?

    My questions are: 1)Can I get the data from sql database onto a web page? 2) Can I accomplish this using html, java, or java script? 3) Where should I go, or what terms should I be googling to study up?

    I want to get the data from sql into either a web page or an applet. The end result will probably be a graph or small math transformation. I just don't know where to begin on accomplishing this. I've been googling and have seen everything from ajax, php, java, javascript, java server-lets, asp, olap. Its just super unclear to me how I can do this using the languages I already know.

    So I'll preface this by stating that I took a class for sql DBM and I'm handy with html.

    I am learning javascript and java on my own and am up to arrays and methods/functions. No object modeling. Still a baby in these two.

    I've been using search terms "parse sql to java" "data driven applet" with no luck..

    Regards!
    Last edited by needMajorHelp; 10-31-2008 at 08:58 AM.

  • #2
    Regular Coder
    Join Date
    May 2008
    Location
    Oxford, UK
    Posts
    422
    Thanks
    14
    Thanked 27 Times in 27 Posts
    I've never used java, but you can create a JSP web application.

    Read more about Java Server Pages here

    Also check out www.connectionstrings.com and choose your database type to get a sample connection string.

  • #3
    Senior Coder
    Join Date
    Oct 2008
    Location
    Long Beach
    Posts
    1,196
    Thanks
    36
    Thanked 164 Times in 164 Posts
    PHP/ASP is probably the easiest to learn (pick which one based on whether your server is windows or linux). Java works on both, but in my opinion is a bit trickier.

  • #4
    Senior Coder gnomeontherun's Avatar
    Join Date
    Sep 2007
    Location
    Houston
    Posts
    2,846
    Thanks
    10
    Thanked 238 Times in 229 Posts
    Quote Originally Posted by needMajorHelp View Post
    My questions are: 1)Can I get the data from sql database onto a web page? 2) Can I accomplish this using html, java, or java script? 3) Where should I go, or what terms should I be googling to study up?
    HTML, and JavaScript have no ability to connect with a Database without another language. They can work with another language to make it happen.

    Now Java, I don't know much about it, but I think its not the solution as I believe it might be able to do some SQL but I don't see many Java applets that just grab SQL data. As was mentioned above JSP (which runs Java on the server instead of on the local computer) may be an option and I presume would be easy to learn from your stance with Java.

    Otherwise, PHP is my suggestion. To connect to a database you need a programming language that runs on the server, which PHP does (or ASP if you like .net) and has functions for database connections.

    Personally, I would get a book rather than just googling things. I know so much data is online now, but books are still the best way to learn indepth about something.
    jeremy - gnomeontherun
    Educated questions often get educated answers, and simple questions often get simple answers.

  • #5
    Supreme Master coder! _Aerospace_Eng_'s Avatar
    Join Date
    Dec 2004
    Location
    In a place far, far away...
    Posts
    19,291
    Thanks
    2
    Thanked 1,043 Times in 1,019 Posts
    I suggest PHP as well. Java can be bulky and you will need to find a jsp server. To even begin making web applications with java you need have a long way to go.
    ||||If you are getting paid to do a job, don't ask for help on it!||||


  •  

    Posting Permissions

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