Connect MySQL from Unity | Official Unity Discord | Page 1

stark sage Aug 17, 2022, 5:50 AM

#

I know

#

So you have ID/PW then what is your concern?

#

Of course you’d need read only access ID for client
Or create web server

hollow sundial Aug 17, 2022, 5:52 AM

#

my concern is I have no experience with PHP or MySQL and I've looked through a bunch of tutorials and cant figure this out

stark sage Aug 17, 2022, 5:56 AM

#

Ah then why not use something easier

#

I think Firebase Database can do something like that

hollow sundial Aug 17, 2022, 5:57 AM

#

i've already set up the MySQL databse. I can figure this out. The issue is just I've seen and tried so many tutorials and I don't know best practice

#

I don't wanna build a whole user/pw high score board like all these tutorials

stark sage Aug 17, 2022, 5:59 AM

#

You could use single hardcoded ID/PW with read permission for all client if that is the case

hollow sundial Aug 17, 2022, 6:02 AM

#

i'm most looking for the optimal tutorial to walk me through the process right now.

stark sage Aug 17, 2022, 6:05 AM

#

I don’t know your environment
You want to create PHP web server connecto to MySQL and retrieve the value that I understand?

hollow sundial Aug 17, 2022, 6:05 AM

#

yep

stark sage Aug 17, 2022, 6:07 AM

#

https://www.red-gate.com/simple-talk/development/dotnet-development/using-mysql-unity/

Simple Talk

Lance Talbert

Using MySQL with Unity - Simple Talk

Even games must store data like top scores. In this article, Lance Talbert explains how to save data using MySQL with Unity.

#

Well let’s see I think you need to reference ‘display.php’ part and customize query

#

You don’t need to add score or anything

hollow sundial Aug 17, 2022, 6:10 AM

#

yeah I can change all the top stuff fine. the try catch is the connecting part.

I dont get whats happening starting with $sth and below. is that part pulling the top 5 scores so i just cut all of it

stark sage Aug 17, 2022, 6:12 AM

#

Yeah you can just limit 1 if you want one result associated with request value

hollow sundial Aug 17, 2022, 6:12 AM

#

one row but ~20 fields from the row

stark sage Aug 17, 2022, 6:14 AM

#

And you can make it to json with json_encode and echo to return?

#

So it would be single page and request body with value from client

#

Returns json object of your row

#

That’s pretty much it I think

hollow sundial Aug 17, 2022, 6:17 AM

#

i'm trying to look up these things your saying

idk this is what my data looks like. probably?

#

yes I think json_encode will do what I need if it can find the right row

stark sage Aug 17, 2022, 6:20 AM

#

So select with limit 1 then echo the json encoded row and exit

#

And others are up to client

hollow sundial Aug 17, 2022, 6:24 AM

#

from square one: you think I shoudl write a PHP file, put it on my website. The top area with user and host stuff explains user and pw to the MySQL database. That one file is all I need and I need to edit that file you shared above to now just have that json_encode statement?

stark sage Aug 17, 2022, 6:26 AM

#

Yes that is what I think. If your server set up correctly to process php

hollow sundial Aug 17, 2022, 6:26 AM

#

ok thanks. wish me luck!

stark sage Aug 17, 2022, 6:26 AM

#

I wish you a good luck
It won’t be so hard to test since it’s readonly and all

hollow sundial Aug 17, 2022, 7:16 AM

#

thanks. it's 3am here i'm going to bed and trying again tomorrow morning.

#

i'll get it though 🙂

stark sage Aug 17, 2022, 7:18 AM

#

You will! Have a good rest

#Connect MySQL from Unity