Unity: MySQL Database Management

Create a Login & Registration system for your game in 1 hour!

Created byArmin Sarajlic

Last updated 7/2018

English

English [Auto],

What you'll learn

Make a fully functional Login & Registration system for your game
Host your database online for free

Course content

2 sections • 10 lectures • 1h 18m total length

Introduction1:06
Explore how to connect to a MySQL database, create a database and tables, read and write data, and build a functional registration and login system in Unity.
Databases6:26
Explore how databases organize data into entities and attributes, define primary keys, and model relationships with ER diagrams, using SQL and phpMyAdmin to create, query, and manage data.
Unity-to-Database Connection Concept2:02
Explore a Unity-to-database connection concept by creating a MySQL database and a simple web page, then build a Unity script to fetch data for login and register.

Setup9:23
Set up a local MySQL database with XAMPP, start Apache and MySQL, create a unity database and a users table with user_id, user_name, password, and email, then insert sample data.
Accessing MySQL with PHP12:00
Learn how to connect to a MySQL database using PHP, set up connection variables, run a select query on the users table, and display results on a web page.
MySQL to Unity13:23
Learn how to set up a Unity login UI and fetch user data from a local web service, parse it into username and password arrays, and prepare for user login.
Login with Unity9:25
Create a Unity login flow by wiring username and password inputs, validating emptiness, and displaying status messages based on a current id after checking stored usernames and passwords.
Data Entry with PHP6:11
Learn how to create a PHP insert script to write post data (username, email, password) into the users table in MySQL, with appropriate field mapping and basic error handling.
Register with Unity10:42
Design a Unity registration UI with username, password, and email fields and a register button. Validate inputs on the front end and submit via a WWW form to register user.
Hosting the Database8:05
Publish your Unity game's database online using free or paid hosting. Create a MySQL database with a users table and upload read.php and insert_user.php scripts.

Requirements

Basic knowledge of Unity Game Engine
Basic knowledge of C#

Description

Game Development is becoming a growing trend in the modern world. With the rise of Indie developers, this is finally becoming a viable career choice for many young people (What a time to be alive!). If you are constantly looking to learn something new which will help you advance on the game developer journey - Then you are at the right place.

Build a User Login & Registration system for your game in 1 hour!

Learn about databases on real examples
Use database management tools
Connect Unity with a MySQL database
Master CRUD operations with Unity
Create local and public databases
Host your database online for free

The problem with learning about game development without formal education is that the fields, which it covers, are ranging from simple IF statements to complicated topics such as networking, databases, etc. Without someone to guide you through this process and tell you exactly what's important, you could be stuck learning useless concepts for years. That's exactly the mistake that I did, and that's the reason I'm here now - to prevent other people from wasting their precious time!

Who this course is for:

Beginner Unity game developers who want to connect their game with a database
Database experts who don't know how Unity works with databases

Unity: MySQL Database Management

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 10min

The Project7 lectures • 1hr 9min

Requirements

Description

Who this course is for: