Not submitting data to server

Hi all,

On the pc, my app runs fine. It collects some info from choices made in the app and submits to my sql/phpmyadmin. The data shows up and i know it works.

However, the data does not send when it's running on my android. I have changed some of the network permissions but no joy.

When the submit button is clicked i have a - on get complete - action.

This sends: get url "http://www.fakeaddress.co.uk/primary/new.php" + "?name=" + Combo Select$( "Combo Box" ) + "&school=" + Combo Select$( "Combo Box 2" ) + "&worklog=" + Edittext$( "Edit Box" ) + "&time=" + string$( "Time" )

it also refreshes the frame.

As i said, on PC it works fine but android doesn't appear to send at all... any ideas?

Make sure you turn on the internet permissions in the Android properties.

Attachment 17192

Ah I think I missed that. I even Checked a previous game that does something similar - I must have missed the Internet option. Cheers Jeff.

Unfortunately this didn't work =(

If anyone could have a check that would be great.. thanks.

Attachment 17211

Just bizarre works fine on PC but android is a no no.

try with this example, http://community.clickteam.com/threads/87185-Online-High-Score-Tutorial
http://sparckmanforums.weebly.com/up...23785_orig.jpg
this works fine for mobile devices.
The server is down but just connect it to your own server the files are in the .rar file
your can use the ones from the original tutorial from Jeff
http://community.clickteam.com/threads/84503-A-Guide-to-saving-high-scores-online

:pacman:

thanks i'm pretty sure i already looked at that. I've already got a game that submits scored on google play, so i don't know why this app isn't working isn't sending data. As i have said, on pc it's fine..

How are you feeding scores into google play without the extension?

This is using php to submit data to a database, not Google play.

How do we make your example above work on a PC?
It doesn't do much when I run it.

Hi Jeff,I guess without looking at phpmyadmin you wouldn't see much.
Basically all the app does it gather details - name, school, notes and time and submits these to a server.

It works fine on the pc, but none of the results get through to the server on the android. I just guess i wanted to see if i had set up the properties/events properly. Just weird it works on pc and not android thats all.

I am looking at event line 4
Not sure how that is suppose to work.

When I run the MFA in windows I never get the submit button to light up so I can click it.

Another thing - I had a problem like that with html5 -
it would work for PC but not for html5 -
And it was because CORS was not enable in my server.
Sometimes you need to enable that in your php code.

Try it out that might be the problem. here is the video how to do it.

https://youtu.be/dqXMKLvAR8E

XD

I just tried your application and realized that the values passed to the url from the combo boxes and text should be URL encoded, or else you will have problems on android.
Special characters like space have to be converted to %20 for example...
This could be easily fixed by using the GET object function called URLEncode$( "Get object", >The text from the inputs<)

Your URL should look like:
"http://fakedomain.com/primary/new.php" + "?name=" + URLEncode$( "Get object", Combo Select$( "Combo Box" ) ) + "&school=" + URLEncode$( "Get object", Combo Select$( "Combo Box 2" ) ) + "&worklog=" + URLEncode$( "Get object", Edittext$( "Edit Box" ) ) + "&time=" + URLEncode$( "Get object", string$( "Time" ) )

Replace the fakedomain.com with your server domain

You will still have some issues with text using single quotes... you should convert the single quotes character by using the html equivalent code ( &#39; ) just to be safe and prevent some hacking attempts.
I did not test it, but try replacing ' with &#39;
You can use the String Parser object for this and you should use it on the Edit Box value because this is the only field with custom values from the user.

Thanks guys. It's not the CORS thing - tried that.

I also replaced the code with MPnetbox suggestion, although now data doesn't seem to post from android or PC.

Someone must have got it working as there are four entries in my database ("double quote test", "working on mobile device") etc (assuming that was MPnetbox) I'll keep trying though!

I just downloaded your file and tested it on PC... but it doesn't seem to be working. Can you post another file? :pacman:

strange..

(this is the basic file without the URL ENCODES)

Attachment 17223

in any case, you need to choose a name, school and press the start and then stop and have some text in the edit box before the submit button shows up.

to view results, use http://www.boallama.co.uk/primary/display.php

thanks again

Quote:

---

Originally Posted by Redsquirrel

Thanks guys. It's not the CORS thing - tried that.

I also replaced the code with MPnetbox suggestion, although now data doesn't seem to post from android or PC.

Someone must have got it working as there are four entries in my database ("double quote test", "working on mobile device") etc (assuming that was MPnetbox) I'll keep trying though!

---

Those were my entries using my phone, so i know that it was working (except when using the single quotes because it would probably break the sql query)
I will take another look into this and i will reply in a few minutes with the working example.

I just finished fixing your application and is now submitting the data to the server. I even fixed the single quoting issues so that it won't break the sql query.

Attachment 17226

Hope that this will fix all your submitting issues ;)

absolute legend! working great thanks and i learnt a bit along the way.