Home
Threads
Database: mySQL and Graphics issue

Database: mySQL and Graphics issue

headRush

@headrush-Wnzwdz • Oct 26, 2024

Oct 26, 2024

1.4K

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 11

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Leo

@leo-ZJQlmh • 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.

0
Manish Goyal

@manish-r2Hoep • Nov 11, 2010

this thing can be easily implemented using adobe photoshop and html
but this way of doing is also interesting

0
headRush

@headrush-Wnzwdz • 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!

0
silverscorpion

@silverscorpion-iJKtdQ • 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-#

0
headRush

@headrush-Wnzwdz • Nov 11, 2010

silverscorpionYou 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. 😔

0
Manish Goyal

@manish-r2Hoep • 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

0
Leo

@leo-ZJQlmh • 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.

0
headRush

@headrush-Wnzwdz • Nov 13, 2010

LeoHi 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.

0
Manish Goyal

@manish-r2Hoep • Nov 13, 2010

can i see your code?

0
Deepika Bansal

@deepika-jf1ysv • 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..??

0
themask

@themask-kPDDPY • 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

0