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 kongsoon · Jun 17, 2015 at 07:22 PM · webplayermysqlphp

In unity web player, how i can connect to mysql server by php?

i want to connect to mysql server. and it works when i build my project as pc, mac & linux standalone mode. however it does not work in web palyer mode. it dose not send any data to mysql server.

it is my c# code.

using UnityEngine; using UnityEngine.UI; using UnityEngine.Events; using System; using System.Collections; using System.Collections.Generic;

public class DBManager : MonoBehaviour {

 private string inname;
 private int inscore;


 public void PressButton()
 {

     GameObject NameIn = GameObject.Find ("InputName");
     GameObject DisText = GameObject.Find ("TotalScoreText");
     InputField INValue = NameIn.GetComponent<InputField> ();
     GUIText GDT = DisText.GetComponent<GUIText> ();

     int.TryParse (GDT.text, out inscore);
     Debug.Log (inscore);
     inname = INValue.text;
     Debug.Log (inname);

     Awake ();
 }

 private void Awake()
 {

     StartCoroutine (SubmitHighScore ());
 }

 private IEnumerator SubmitHighScore()
 {
     int _score = inscore;
     string _name = inname;

     WWW webRequest = new WWW ("http://my ip address/insertScore.php?Name=" + _name + "&Score=" + _score);
     yield return webRequest;

 }



and it is my php code

 $link = mysql_connect('localhost', 'genie', 'genie');
 mysql_select_db('run_score');

 
 $name = @$_GET['Name'];
 $score = @$_GET['Score'];
 
 if(!$name)
     die("No name.");
 if(!$score)
     die("No score.");

 $data = $name."_".$score;
 
 mysql_query("INSERT INTO ranking (Name, Score) VALUES ('$name', '$score')");
 echo "success";

 mysql_close($link);

Comment
Add comment · Show 1
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 Graham-Dunnett ♦♦ · Jun 17, 2015 at 07:24 PM 1
Share

Is it a sandboxing problem? Without any Player.log data it's impossible to know what's not happening.

1 Reply

· Add your reply
  • Sort: 
avatar image
0

Answer by DavidZendle · Jun 17, 2015 at 09:29 PM

It sounds like you're running into Unity's infamous Webplayer sandboxing issues.

Basically, Webplayer builds will only talk via WWW to domains with valid crossdomain policies.

The fix?

A quick test to see if this is your problem is to put a file called 'crossdomain.xml' on the root of the server hosting your php. This file should contain the following code:

 <?xml version="1.0"?>
 <cross-domain-policy>
 <allow-access-from domain="*"/>
 </cross-domain-policy>

If this fixes the problem, you can go back and replace the "*" with the specific domain that you're trying to access the php from to make things more secure.

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

3 People are following this question.

avatar image avatar image avatar image

Related Questions

Design - Web Player Facebook app with Godaddy hosting and MySQL 1 Answer

Unity to PHP/MySQL: password and username security 1 Answer

WWW class and PHP security issues 1 Answer

HOW Unity store game saves? Are mySQL a valid option to store such data? How about javascript framework or php? 0 Answers

PHP Android WWW Unknown Error 1 Answer


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