Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Unity 5 - Interact with the Database Like a Pro - PHP & MySQL
Development
File Downloads
01 Download the Unity project and open the scene (1:26)
02 How to play the game server and client and test them (3:52)
03 Overview of the scene assets and resources (3:42)
04 Designing the Login user interface in Unity (5:09)
05 Designing the registration UI (5:00)
06 Connecting the authentication UI to the code (8:22)
07 Swapping between Registration panel and login panel (7:21)
08 Adding a feedback message field (4:05)
09 Overview of the Authentication system (2:15)
10 installing mySql and Php on MAC and Windows the easy way (3:52)
11 Installing the mySql editor (5:20)
12 Create the SQL database and user table (7:08)
13 Inserting new users using the mysql editor (4:11)
14 Download Php text editors MAC and Windows (1:26)
15 Connect the php script to mySql database (6:45)
16 Programming the database login script (9:31)
17 Loging user connecting Unity login to database (10:53)
18 Programming the registration in Unity (5:30)
19 Triggering the user registration from Unity (8:34)
20 Creating a serializable json user object in Unity (8:19)
21 Refactoring the request endpoints (5:00)
22 Launching the game client after successful login and registration (4:26)
23 Testing Game Host and Client Login (1:39)
24 Hide password fields and add user ID to User (6:56)
25 Programming the player gear storage class (2:26)
26 Create the SQL gear storage table (8:40)
27 Programming PHP code to retrieve player gear (4:33)
28 Retrieving stored player gear in Unity (5:07)
29 Equipping the helmet retrieved from the server (7:30)
30 Adding the item attributes (9:00)
31 Equipping the sword from the database (7:10)
32 Equipping the database off hand (shield) (4:09)
33 Equipping the shoulders from the database in Unity (6:56)
34 Adding a reference to the ground objects (5:52)
35 Programming Unity to send player gear to database (8:43)
36 Storing the player gear in the database (13:38)
37 Refactoring item equipping (5:48)
38 Create the backpack SQL script (4:42)
39 Programming PHP script to retrieve backpack items (3:40)
40 Programming php script to store backpack item data (2:34)
41 Coding Unity script to get player backpack items from server (8:36)
42 Programming the code that stores backpack data in DB server (7:23)
43 INSERT gear and backpack entries at registration (5:46)
27 Programming PHP code to retrieve player gear
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock