• 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 /
  • Help Room /
avatar image
0
Question by ZaphodBeeblebrox21 · Aug 27, 2020 at 10:36 PM · wwwwebrequestwwwformsqlsqldatabase

UnityWebRequest returns an empty string

Version: 2019.3.11f1

I tried to add a simple online leaderboard to my game. I created a SQL database and wrote a PHP script which accesses it. So far so good.


The PHP script's URL is the following: https://starcaders.com/leaderboard.php


As you can see, the PHP script is working and displays the table's entries (only two test entries atm). My goal is to read the text on the page and save it as a string in Unity.


Unfortunately, the code below returns an empty string. The isDone bool is also false.


I also tried to add a "SendWebRequest()" after yield return leaderboard, but that leads to the following error message: Curl error 51: Cert verify failed: UNITYTLS_X509VERIFY_FLAG_EXPIRED and also returns "hahaha TEST 123", my placeholder string.


I also tried to retrieve text from other sites, but that returns an empty string as well. At this point, I am basically completely at a loss, which is why I created this thread.


Thank you for your time, below you can see my code.

 using System.Collections;
 using System.Collections.Generic;
 using UnityEngine;
 
 using UnityEngine.Networking; // for UnityWebRequest
 
 public class Leaderboard : MonoBehaviour
 {
     void Start()
     {
         StartCoroutine("RequestLeaderboard");
     }
 
     IEnumerator RequestLeaderboard()
     {
         UnityWebRequest leaderboard = UnityWebRequest.Get("http://starcaders.com/leaderboard.php"); //sends http request --> php script reads sql database
         yield return leaderboard; //waits until request is done
         string leaderboardString = "hahaha TEST 123";
         if(!leaderboard.isNetworkError && !leaderboard.isHttpError)
         {
             leaderboardString = leaderboard.downloadHandler.text;
         }
 
         Debug.Log(leaderboardString);
     }
 }








Comment
Add comment
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

1 Reply

· Add your reply
  • Sort: 
avatar image
0

Answer by ZaphodBeeblebrox21 · Aug 28, 2020 at 10:49 AM

EDIT: I updated to Version 2020.1.3f1, the problem is still the same

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.

Welcome to Unity Answers

The best place to ask and answer questions about development with Unity.

To help users navigate the site we have posted a site navigation guide.

If you are a new user to Unity Answers, check out our FAQ for more information.

Make sure to check out our Knowledge Base for commonly asked Unity questions.

If you are a moderator, see our Moderator Guidelines page.

We are making improvements to UA, see the list of changes.



Follow this Question

Answers Answers and Comments

211 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

www request Error unity 2018 0 Answers

UnityWebRequest.Post() has multipart/form-data strangely formatted when sending request 5 Answers

Why current culture is always en-US and what is the alternative ? 5 Answers

SQL Connection security (Android) 1 Answer

How to get image from server folder through its reference in mysql database 0 Answers

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges