Unity & MySQL Databases, Part 6: Finishing Touches

Improving the user experience of our MySQL login system with gating based on login status, protecting player passwords, and improved controls.

The next (and final) video will talk about avoiding SQL injection for improved security.

Support Board to Bits on Patreon:

[csdiabo]

This series has been not only the best Unity Database tutorials but one of the best Unity tutorials I've seen. I am quite experienced with Unity but knew nothing about php or sql and this series was super super useful and I feel like I learnt a bunch!

[CoreFilms]

this series has GREATLY helped me understand how I should approach implementing a database inside my game. thank you so much!!!!

[claudito]

Man ur channel is for far one of the bests unity learning channels

[crystalbytes]

thank you. these are solid tutorials! please keep up the good work.

[TheSpacecraftX]

Is this the last episode or are you not going to do a bit about sanitising inputs to avoid injections?

[vuklazovic]

thank you so much, great series <3

[yangzuo]

Thank you so much, it’s very useful !

[kanchukasamarakoon]

i have a one question. only one data(one player) can be added. when i tried to add another one it says some array error

[nitheshgurudaas]

Hey there, my game works fine in Unity, but I tried exporting it to WebGL and it still works in Unity, but not on the WebGL, any ideas as to what I've done wrong?

[baohua]

Hi. Can this code work for online server ? I means you use localhost. I wonder if another player access to the same database, how does it works ?

[bit_physics]

I had a serious problem with the editing. You can switch but you can't edit. The problem was with the "Simulator" mode of Unity interface, editing doesn't work in that mode, it only works in "Game" mode.

is causing "Assets\TabBetween.cs(6, 2): error CS0246: The type or namespace name 'RequiredComponent' could not be found (are you missing a using directive or an assembly reference?)
" in Unity 2019.1.10.f1. When y comment this line, all works perfectly. It's like it's not needed or included in other part. (sorry for the ambigous feedback) (i don't forget using UnityEngine.UI; btw)

[alexandernava]

I really love this tutorial, but you do have quite a few code smells. Quite errors are bad, debug what is bad, then disable.

[dumitruiordachi]

Hi,
what if i want to load data like scor, several times? like, i have score int, and high score int. How can i load the both?
I tried but, when i loggin in, score and highscore are loaded *10. For exampe score in database is 10, when i loggin score in game is 100

[marufhasan]

after building app it works perfectly while using my home wifi but in mobile data register page not working, even register page not working in another wifi, any idea why this happening? i was using bluehost for db, here is the error, document.cookie = "humans_21909 =1"

[Syncrenym]

can anyone link me the php? I deleted mamp making room for MW and accidentally deleted the htdocs folder.

[Auho]

Hello, can anyone please help with this? I get an error when I try to login after entering the username and password, the error is IndexOutOfRangeException: Index was outside the bounds of the array.
() (at Assets/Login.cs:25)

when I click on the error, it takes me to the Login C# script in visual studio to this line of code if (www.text[0] == '0')
any help would be appreciated.

[jessicabendecio]

hi may i ask if this is work for offline game

[alexandernava]

public Selectable Next;
private Selectable _myField;

private bool _setNext;

private Button _myField2;

// Start is called before the first frame update
void Start()
{
_myField =
}

// Update is called once per frame
void Update()
{
if != null && == _myField.gameObject &&
{
_setNext = true;
}
}

void LateUpdate()
{
if (!_setNext)
return;

_setNext = false;

Next.Select();
}

[Slagatoras]

So how exactly can we upload it to a server?! i trying to make it work on directadmin, placed the game build in the domain directory made a sqlconnect folder and placed the php file inside and changed the www to be localhost/path to singup.php, set the database and everything but nothing!