Dissecting MYSQL data through PHP using WWW

Unity Engine
1

Hello. How would I assign the data that I have retrieved from PHP using WWW into a temporary string/int variable. Like for example, the data I receive are ‘item_ID’ and ‘item_name’. I want to connect ‘item_ID’ and ‘item_name’ to ‘int received_ID’ and ‘string received_name’ separately and Debug.Log them in a for loop because I will be expecting to receive multiple ‘item_ID’ and ‘item_Name’ datas

The data I receive from PHP is in plain text.

1 test01
2 test02
3 test03

Where 1, 2, 3 are what I want to be put into an ‘int received_ID’ and test01, test02, test03 are what I want to be put into a ‘string received_name’ using a for loop.

Is there a way to do this or should I use XML instead?

2

if you can change the php, return it as CSV values (or your preferred string separator - pipe, semicolon, etc) then use string split functions

1 Like
3

I kinda figured it out already but thank you so much