How to allow Unity3D to communicate with mySQL

[Volkof]

Hi all,

I am working on a Project that requires creating a survey using Unity3D, and uses mySQL to store results.

Problem is, Unity3D does not seems to be able to communicate directly with mySQL, and requires a middleman (like PHP) to do so.

Is there any way to NOT use a middleman?

 

[UndeadDragon]

I doubt there would be an easy way to directly communicate.

If you wanted to use PHP it would be very simple like so: (very basic form)

<?php
 
mysql_connect('MYSQL_HOST', 'MYSQL_USERNAME', 'MYSQL_PASSWORD');
mysql_select_db('MYSQL_DB');
 
mysql_query('INSERT INTO users VALUES ('username', 'password');

 

[Magentix]

From what I understand, you shouldn't connect through Unity3D because people could then get hold of your DB credentials.

Here's some information on how to do it more safely:
http://wiki.unity3d.com/index.php?title=Server_Side_Highscores

 

[Volkof]

Thanks guys.

After much discussion with my group members, we decided to go with PHP

 

[GetTriggerUnit-]

Make sure you use mysqli or pdo, because the basic php mysql api is deprecated.

 

[DrEvil]

From what I understand, you shouldn't connect through Unity3D because people could then get hold of your DB credentials.

Here's some information on how to do it more safely:
http://wiki.unity3d.com/index.php?title=Server_Side_Highscores

I still don't understand how this is safe.
So we are assuming people can look through the code to find the DB credentials... they will find the urls to set/get highscores and the md5 hash to be used. Therefore allowing them to set whatever highscores they want.

I'm not sure if I am missing the point of it, but I cannot seem to make sense of it.

 

[tooltiperror]

Make sure you use mysqli or pdo, because the basic php mysql api is deprecated.

Why do you say that?

 

[GetTriggerUnit-]

Why do you say that?

This is considered deprecated my many php developers. It does the job but it's a very old API. There are much more interesting functions with mysqli or pdo, for instance multi query / stored procedures.