CrazyEngineers
CrazyEngineers

  • Database: mySQL and Graphics issue

    headRush

    Member

    Updated: Oct 26, 2024
    Views: 1.1K
    I am creating a database using mySQL and PHP. The database is about solar system having entities star, planets, asteroids, comets with their respective attributes (size, mass, Position, etc). My end goal of the project is to create a graphic user interface which will be just like the solar system with sun in the middle and planets revolving around it. The end product will be in where a user clicks on the sun and it displays the attributes of the sun. Or user clicks on the planet and displays the attributes of it.

    Currently, I have no idea on how to do the graphics part. What is the best and the easiest way to solve this issue? What programming language can I use to build the graphics part and link it to the database? Any suggestions?
    Thanks.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • Leo

    Member • Nov 11, 2010

    Hi Rush so far as i know graphics in java will be best to opt for graphical frontend for your application. Rest is just up to you.
    Are you sure? This action cannot be undone.
    Cancel

  • Manish Goyal

    Member • Nov 11, 2010

    this thing can be easily implemented using adobe photoshop and html
    but this way of doing is also interesting
    Are you sure? This action cannot be undone.
    Cancel

  • headRush

    Member • Nov 11, 2010

    @leo
    I have indeed created a Java file which lets me revolve a planet around sun. But the problem is I have no idea how to connect it to the database.

    @goyal420
    Do you have any helpful links from where I can learn and implement something like this?
    Thanks!
    Are you sure? This action cannot be undone.
    Cancel

  • silverscorpion

    Member • Nov 11, 2010

    You can use JDBC to connect to a database from Java. It's very easy..

    You can google JDBC and lots of tutorials are there to get you started..

    #-Link-Snipped-#
    Are you sure? This action cannot be undone.
    Cancel

  • headRush

    Member • Nov 11, 2010

    silverscorpion
    You can use JDBC to connect to a database from Java. It's very easy..

    You can google JDBC and lots of tutorials are there to get you started..

    #-Link-Snipped-#
    Ok This looks quite interesting.
    Thanks

    I am currently reading up on HTML5 and JQuery. I have no idea about them either. 😔
    Are you sure? This action cannot be undone.
    Cancel

  • Manish Goyal

    Member • Nov 11, 2010

    Look first create a simple image or animation of planets revolving around sun or whatever you want to show in your image

    then have a look at this link
    #-Link-Snipped-#
    and try <map> tag of html

    This is one of the most basic way ,there are other ways too
    Are you sure? This action cannot be undone.
    Cancel

  • Leo

    Member • Nov 12, 2010

    Hi Rush connecting database is really very easy, you must not ask for such kind of help in programming. Its better to try before than directly asking for help.
    Are you sure? This action cannot be undone.
    Cancel

  • headRush

    Member • Nov 13, 2010

    Leo
    Hi Rush connecting database is really very easy, you must not ask for such kind of help in programming. Its better to try before than directly asking for help.
    Like I said before, I created a Java graphics file with Sun and planet revolvoing and I don't know how to connect those elements to the tables in my database. I already know how to create/edit/update attributes from a website. I'm asking something else.
    Are you sure? This action cannot be undone.
    Cancel

  • Manish Goyal

    Member • Nov 13, 2010

    can i see your code?
    Are you sure? This action cannot be undone.
    Cancel

  • Deepika Bansal

    Member • Nov 17, 2010

    headRush
    @leo
    I have indeed created a Java file which lets me revolve a planet around sun. But the problem is I have no idea how to connect it to the database.
    Hello Rush. Can u please let me know how do you created such graphics using java.?? Did you use only j2ee concepts or something additional to it..??
    Are you sure? This action cannot be undone.
    Cancel

  • themask

    Member • Nov 25, 2010

    With HTML5, JQuery it self you can get the interactivity. You can use the canvas for this.
    Also you can use PHP,MySQL to store the data and retrieve it
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register