Databases and High Score storing.

[Manfred]

I'm trying to figure out how to store high scores in a MySQL DB.  From the research I've done, I would have to download and install some some JDBC drivers for MySQL.  

Problem is that my web page host won't allow for the running of any java on their server.  The tech didn't seem to knowledgable on the subject(or maybe that was me), just said no to the JDBC drivers, and said to use Perl or PHP.  

Is there any way to bridge the gap?  Send a score to a Perl script or use PHP somehow(also not my field of expertise)?  

[mhale]

If you have a mysql database on a web server, then a java client can connect to it using jdbc with no java required on the server. That is, the JDBC driver is on the client not the server side.

To get yourself started, download JDBC MySQL connector from www.mysql.com, and play with client code like:


String host,database,username,password;

String url = "jdbc:mysql://"+host+"/"+database+"?user="+username+"&?password="+password;
Class.forName("com.mysql.jdbc.Driver");
Connection con =DriverManager.getConnection(url);
.
.
.

[oNyx]

http://www.java-gaming.org/cgi-bin/JGNetForums/YaBB.cgi?board=2D;action=display;num=1093643008;start=3#3

I've already explained that kind of stuff 3 times now and I won't do that again

@mhale

That's really scary. Everyone could just connect and delete the whole database etc (they have user+password).

Games published by our own members! Check 'em out!

[mhale]

Yes, it is scary. But, MySQL allows you to setup permissions for SQL statements, so you can prevent people from executing arbitrary sql statements.

[Manfred]

I must have misunderstood what I was reading.  Thanks for your help folks.

[crystalsquid]

We use PHP pages to do this.

The Java client can simply request a specific php page like hiscore.php and supply the arguments for the name, number, etc. The PHP on the server side can then do whatever database processing you like and return a fake 'page' to the applet, complete with the top 10 scores, and your rank.