Trying to get float to MySQL, it gets rounded.

[doodler345]

Hello guys,

I want to use a PHP-file to get new scores into MySQL. But it always rounds the float.
I already tried to change the comma to a dot. Didn’t work.
In the MySQL table when manually adding a float with a dot, it works.

This is the essential .PHP part

    // Get the user's name and store it
    $name = mysqli_escape_string($connection, $_POST['name']);
    $name = filter_var($name, FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
    // Get the user's score and store it
    $score = $_POST['score'];

    // Create prepared statement
    $statement = $connection->prepare("INSERT INTO highscoreTableMySQL (name, score) VALUES (?, ?)");
    $statement->bind_param("si", $name, $score);

    $statement->execute();
    $statement->close();

This is the Unity-Script

    public void PostScores(string name, float score)
    {
        StartCoroutine(DoPostScores(name, score));
    }

    IEnumerator DoPostScores(string name, float score)
    {
        WWWForm form = new WWWForm();

        form.AddField("name", name);
        form.AddField("score", score.ToString().Replace(",", "."));
    }

[Kurt-Dekker]

What goes out over the wire is just pure text.

It is up to you to format it properly for whatever your backend is expecting.

Anything going over the network can be debugged like this:

Networking, UnityWebRequest, WWW, Postman, curl, WebAPI, etc:

Using Unity for subscription lists

As with all network code, get it working with Postman or curl first. That makes it NOT a Unity problem. Solve the networking first. You must solve that or anything else is irrelevant. Once you have that working, then try and port it to UnityWebRequest. If it still doesn't work, one handy debug solution is to hook up a proxy like Charles and compare the functioning output from Postman / curl to the output from Unity, and from that reason about where your issues are.

Unity web request acting stupid.

Always get network stuff working outside of Unity in either curl or PostMan, then connect a proxy such as Charles and start trying to replicate the traffic shape with UnityWebRequest. Any other way risks wasting a lot of your time for trivial issues that only the above way will instantly reveal.

And setting up a proxy can be very helpful too, in order to compare traffic:

Using Charles Proxy with Unity

[Bunny83]

Don’t do this:

score.ToString().Replace(",", ".")

Use the invariant culture instead use

.ToString(CultureInfo.InvariantCulture)

(requires using System.Globalization; at the top)

Apart from that, you specify "si" as the parameter types, so you restrict the first parameter to be a string and the second to be an integer. You probably want to use either "sd" or "ss".

I barely use the mysqli interface and just use the standardized PDO interface that php provides. There you usually don’t have to provide type strings and you usually would use named variables inside the query. Though that’s up to you.

Of course there could be other issues on the line. For example what’s the actual datatype of the score column?

[doodler345]

@Bunny83

Apart from that, you specify “si” as the parameter types, so you restrict the first parameter to be a string and the second to be an integer. You probably want to use either “sd” or “ss”.

That solved my problem.
Thank you very much…