Unity 5 - Easy Database 7 (Login - MySQL conditions)

Hello guys! Today we will post a password and a username and check if the password matches the one on the server.
Thank you all for the nice comments and I hope soon I can upload a bunch of new videos, till then, please stay tunned! Love and Peace!

[satoshisaito]

thank you so much for providing this series of SQL with unity, it was very very helpful and I learned so much that I couldn't find anywhere else . I just want to say thank you ! you are amazing !!

[joost]

Thanks so much my dude! :D Please continue this series as you're probably the only person who can explain the combination of databases and unity so well. Somehow I'm just following along and understanding everything.

I have some (awesome) ideas that I'd love to see you make, would be appreciated :) :
-Splash screen for login (Fields to fill in username, password and a button for register with activation for email etc.)
-Actual multiplayer. Let 2 people join with their account so you can see each other in the simple 2D or 3D game (don't make the game itself, just use a sprite for the players that can only walk)
-Inventory GUI that loads depending from items in DB
-Stats for every player (strength, intelligence, speed etc.)

Thanks once again. Loved the series, just did them all in 1 go just now and it felt like a breeze ^^

[programmedgaming]

Thanks so much for this series! I've been working on trying to post high scores to a website from Unity and then display those high scores in Unity from the website. This is exactly what I've been looking for! Thanks again, can't wait for the next video!

[firebraingames]

Hi guys. Sorry I have not been uploading any videos! My computer dieded and I had to format it. I will upload the video as soon as possible. My database is gone, but hopefully we will get things done.
Apologies!
PS: Next video we will host our database on a real server! Peace.

[bitmammothOG]

Sorry to hear about the downtime I hope you will return to fully operational soon :) Best of luck!

[mortezamohammadifard]

hi dear Lucas thank you for teaching database in unity and PHP, great job keep going.
thanks....

[swopbots]

Brilliant! Exactly what I needed for my game. Thank you so much! Looking forward to the next tutorial.

[atomcai]

Your tutorials are very easy to follow and helpful! Thank you very much!

[joeymiller]

Works perfectly! as usual. How would you go about adjusting Login and DataInserter scripts to take user inputs when built to android?

[Archygoo]

Hello, Lucas.

Could you please create a video showing how we can save data to database with Input Fields?
I'm making an RPG, and I plan to make an admin scene where the admin can create new weapons. They could input the name and the stats to the item, choose the type of the item, and then press Create, and the information gets sent to the database table.

[stevevargas]

the issue at 15:15 was the use of a double "==" instead of a single "=" as used in MySQL - he did mention it - easy mistake going from C# back to MySql

if($row = $user_password) {

/* whole code */
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
if($row = $user_password) {
echo "login success!";
} else {
echo "Password incorrect!";
}
}
} else {
echo "user not found";
}

[bugaboostudio]

Nice tutorial again. Our team is learning a lot ;)

[motionbrain]

using your videos for my bachelor ! (: thanks for sharing your work

[rockstudios]

Your channel is great! I'am definetly going to subscribe. Just a question, were are you from?

@Creagines

[mcblanc]

Great tutorial. I finally know how to make multiplayer game :D

[shemad]

love your tutorials! in the near future, can you please make a tutorial on how to connect to the database through a mobile device (Android/iOS)? Ive tried creating a login system with db for PC before but when I switch to an android platform, it couldn't connect to phpMyadmin.

[Drotttin]

Keep forgetting to add your links! Great videos, would like to see more.

[Pijus]

All the samples are getting the info from variables set in run time manually. This is usefull while developing, but not when the game is deployed. It would be nice to see how to recover the info from input fields created into the canvas and filled by the player while playing the game.
Anyway, good job. Thx.

[CarlosJader]

Hey man, nice series!
Using what I learned from you so far, I was able to create an account creation form inside my game(Unity project), I'm pretty happy with the account creation system but now I would like to send an e-mail to activate the account, I found a tutorial but it seems I would have to have a website.
I think I could use my Unity script to call a php to send the e-mail with the verification link, is there a way so this link points to my localhost and execute the verification? Could you put me on the right path Sir?

[Cyrsztof]

You are awesome, thank you very much! <3