Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by Marcomini · Dec 16, 2014 at 07:47 PM · wwwphp

My script for insert a score is not working

I use a script attached to a UI.Button to run a php script in my server. It works fine when i use it for retrieve the scoreboard, but when i try to use into my insert script it just does no work.

Script to access the PHP insertion script:

 public string url;
     public Text Nome;
     public Text Score;
     public void Run()
     {
         StartCoroutine(Gravar());
     }
     public IEnumerator Gravar() 
     {
         WWW www = new WWW(url+"?name='"+Nome.text+"'&score='"+Score.text+"'");
         Debug.Log (www.url);
         yield return www;
     }

PHP insertion script:

 <?PHP
     require_once 'app_config.php';
     connect();
     
     $Nome = $_GET['name'];
     $Score = $_GET['score'];
 
     $query = 'insert into score(score.Nome, score.Score) values('.$Nome.','.$Score.')';
  $result = mysql_query($query) or die ('ERRO : ' .mysql_error());
     
 ?>

And the PHP script is working, because when i get the url that the console gives me and run it on a browser it work just fine. I can't figure out why its not working in unity.

Comment
Add comment · Show 9
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image gjf · Dec 16, 2014 at 02:12 PM 0
Share

have you tried it without the single quotes in the url?

avatar image Marcomini · Dec 16, 2014 at 02:21 PM 0
Share

I tried now but still not working

avatar image gjf · Dec 16, 2014 at 02:35 PM 0
Share

apart from escaping the single quotes in your php, it should work. did you check whether it's getting to the php and getting the parameters, regardless of posting to mysql or not? that's probably where the problem is.

try returning $result and printing from unity's debug console.

avatar image Marcomini · Dec 16, 2014 at 02:45 PM 0
Share

i've put a echo $result in my php script, and it should return 1 (i've tested in the browser). But my unity does not show anything in de console, not even a empty log.I think that something is giving a error an stopping the script.

avatar image gjf · Dec 16, 2014 at 03:49 PM 0
Share

i added something very much like your code into a test app (specified my own web server, etc.) and it worked as expected with the php reading the parameters, etc. and unity logging the response.

perhaps some firewall issue with your unity app then?

not sure what else to suggest.

Show more comments

1 Reply

· Add your reply
  • Sort: 
avatar image
0

Answer by Marcomini · Dec 17, 2014 at 10:18 AM

I've found the problem, its not on the scripts i've showed. i was using loadlevel immediately after i use the yield www, not giving time for the yield work because it was destroyed in the middle of the process

Comment
Add comment · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

connecting to php? 2 Answers

Network class vs php for authoritative actions? 1 Answer

Why is my PHP echo returning entire PHP file after WWW request? 1 Answer

Retrieving varibale values from a php script? 1 Answer

Necessary Data Rewind Wasn't Possible WWWForm Error 0 Answers


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges