watching now
291 Students

40 Lessons

Beginner

What You Will Learn?

  • Build a Professional Backend Layer to Store and Retrieve Data for Your Unity Video Game
  • Understand How to Use MySQL and PHP as a Solid Data Layer to Communicate with Unity
  • Learn Basics of PHP
  • Learn Basics of MySQL
  • Learn Quick Setup of PHP and MYSQL for Unity

Curriculum

3h 57m
Section 1: Unity tutorials: Unity 5 Interact with the database like a pro - PHP MySQL
41:12
Section 2: Installing MySQL
1:21:10
Installing MySQL and PHP on MAC and Windows the easy way
03:52
Installing the MySQL editor
05:20
Create the SQL database and user table
07:07
Inserting new users using the MySQL editor
04:11
Download PHP text editors MAC and Windows
01:26
Connect the PHP script to MySQL database
06:45
Programming the database login script
09:31
Logging user connecting Unity login to database
10:53
Programming the registration in Unity
05:30
Triggering the user registration from Unity
08:34
Refactoring the request endpoints
05:00
Launching the game client after successful login and registration
04:26
Testing Game Host and Client Login
01:39
Hide password fields and add user ID to User
06:56
Section 3: Equipping
1:27:14
Create the SQL gear storage table
08:40
Retrieving stored player gear in Unity
05:06
Equipping the helmet retrieved from the server
07:30
Adding the item attributes
09:00
Equipping the sword from the database
07:10
Equipping the database off hand (shield)
04:09
Equipping the shoulders from the database in Unity
06:56
Adding a reference to the ground objects
05:52
Programming Unity to send player gear to database
08:43
Storing the player gear in the database
13:38
Refactoring item equipping
05:48
Create the backpack SQL script
04:42
Section 4: Programming PHP
27:58
Programming PHP script to retrieve backpack items
03:39
Programming PHP script to store backpack item data
02:34
Coding Unity script to get player backpack items from server
08:36
Programming the code that stores backpack data in DB server
07:23
INSERT gear and backpack entries at registration
05:46

Description

Requirements

  • Basic knowledge of Unity is Recommended but not Necessary
  • Unity Game Engine
  • Windows PC, MAC, or Linux

About the Instructor

Yohann Taieb

Apps/Games Developer
Reviews 189
Students 139,170
Massive audience
Courses 18

Yohann Taieb is one of the leading teachers in mobile game programming. Yohann has been a College instructor for over ten years. He has a unique style. Yohann has enabled more than 50000 students to publish their apps and reach the top spots.
Yohann ideas turned him into an entrepreneur, and now he is sharing his knowledge and experience by teaching iPhone Development, Swift 3, Unity 3D, Photoshop for programmers, and Android.

BitDegree platform reviews

Our students say Excellent
9.5 out of 10
trustpilot logo 1 trustpilot logo