Custom Authentication, Stuck with Database
I'm trying to use the custom authentication to check the user's email and auth code. I looked up many tutorials like
https://forum.photonengine.com/discussion/2697/about-custom-authentication-how-to-do-it-in-php?
https://www.youtube.com/watch?v=DHn5_17D6H4&t=1427s
But I really have zero knowledge about php and database. Right now I'm stuck at the database part. I've created an Oracle Json database (not sure if I created the correct database), but I don't know how to connect the database in php and I also don't know how to add users in the database. Regarding adding users, I learned that I need to use SQL and CREATE statement to do that but I also don't know where I should do this. I tried to access the SQL developer web in Oracle dashboard but I couldn't login. It always says invalid username or password.
Sorry for the dumb questions about backend stuff, but this got me crazy. Can anyone help me out?
https://forum.photonengine.com/discussion/2697/about-custom-authentication-how-to-do-it-in-php?
https://www.youtube.com/watch?v=DHn5_17D6H4&t=1427sBut I really have zero knowledge about php and database. Right now I'm stuck at the database part. I've created an Oracle Json database (not sure if I created the correct database), but I don't know how to connect the database in php and I also don't know how to add users in the database. Regarding adding users, I learned that I need to use SQL and CREATE statement to do that but I also don't know where I should do this. I tried to access the SQL developer web in Oracle dashboard but I couldn't login. It always says invalid username or password.
Sorry for the dumb questions about backend stuff, but this got me crazy. Can anyone help me out?
0
Comments
-
Is there a certain reason you're wanting to use an SQL database through oracle?
Im assuming your game/app is needing multiplayer, so you're using an online database?
If thats so, I'd recommend looking into PlayFab; there's a ton of documentation and tutorials to set it up and its also built to work directly with Unity and Photon (PUN).0 -
Thank you very much LeeroiJenkiins! I tried PlayFab and it worked great and much easier. Before I tried PlayFab, I've already successfully used php and Firebase, and got a server from DigitalOcean, but it didn't work with Photon and I guess it was because I used the server IP address instead of url. Anyway, Photon works great with PlayFab. Thanks.0
