AJAX [Returning Multiple Values]

Post reply

❤Follow Topic(4)

Email subscribe

0 favourites

7 posts

- Kettlewell
- - Joined 10 Jun, 2015
  - 8 topics • 19 posts
- 1
- 10 Jun, 2015
- Quote
I've learned how to use AJAX, PHP and MySql to return database values but how do you handle multiple values?

Does AJAX.lastvalue return an array or is there something I have to do to receive multiple values?

In PHP do I have to do something special or simply;
```
echo $var1
echo $var2[/code:2vyw9z40]
```
- deathangel1479
- - Joined 16 Feb, 2015
  - 13 topics • 158 posts
- 1
- 11 Jun, 2015
- Quote
I cant say you what happens, but I can say you how you can try:

--AJAX On "yourTag" completed

-->Browser Log in console AJAX.LastData

You have to experiment a bit.
- Magistross
- - Joined 4 Jul, 2011
  - 8 topics • 1,112 posts
- 1
- 11 Jun, 2015
- Quote
You can return a tokenized string or a JSON object that C2 can interpret.
- Kettlewell
- - Joined 10 Jun, 2015
  - 8 topics • 19 posts
- 1
- 11 Jun, 2015
- Quote
You can return a tokenized string or a JSON object that C2 can interpret.

Could you possibly give me a small example and I'll work the rest out from there, thanks Magi
Try Construct 3

Develop games in your browser. Powerful, performant & highly capable.
Try Now Construct 3 users don't see these ads

Kyatric Construct Team Support
Moderator
- Joined 18 Aug, 2010
- 278 topics • 7,858 posts
1

11 Jun, 2015
Quote

Make your PHP script to return a concatenated line like

echo $var1 . "|" . $var2[/code:2yudkrsv]
( the dot "." should be the way to concatenate in PHP IIRC, to make sure, be sure to look into the PHP manual or a website about PHP programming).

When you receive your AJAX line you can use the [url=https://www.scirra.com/manual/126/system-expressions]system expressions[/url] "tokenat", "tokencount", etc... to manipulate the string, according to the separator (in my example the "|" character).

tokenat(AJAX.lastdata,0,"|") should allow you to only retrieve $var1; tokenat(AJAX.lastdata,1,"|") => $var2

deathangel1479
- Joined 16 Feb, 2015
- 13 topics • 158 posts
1

11 Jun, 2015
Quote

Multible values by json:

Multi row:

$arr = array();
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
{
        arr[] = $row;
}
echo json_encode($arr);
[/code:hfj250k1]
AJAX.LastData -> [{"name":"Bob","secondName":"Meyer","isMember":1},{"name":"Dieter","secondName":"Miller","isMember":1}]
[img="https://dl.dropboxusercontent.com/u/95601836/multiphp2json.png"]

Single row(first result):
[code:hfj250k1]
$arr = array();
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
{
        arr[] = $row;
}
echo json_encode($row[0]);
[/code:hfj250k1]
AJAX.LastData -> {"name":"Bob","secondName":"Meyer","isMember":1}
[img="https://dl.dropboxusercontent.com/u/95601836/singlephp2json.png"]

Then use a json plugin to work with this strings. For example: [url=https://www.scirra.com/forum/plugin-tools-object-array-in-construct-based-on-json_t147493]Tools[/url]
Some examples:
[img="https://dl.dropboxusercontent.com/u/95601836/getLastData.png"]

Sorry for spam, but my server is down and i am boring...

- Kettlewell
- - Joined 10 Jun, 2015
  - 8 topics • 19 posts
- 1
- 11 Jun, 2015
- Quote
Thank you for all the help, I got my code working and managed to edit it to what I wanted.

Great help again, thank you.