Advertisement
Guest User

Untitled

a guest
Aug 9th, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. <?php
  2.  
  3. //SERVER CONNECTION
  4. $server_name = "localhost";
  5. $server_user = "Er.Ellison";
  6. $server_pass = "supersecretPassword";
  7. $server_db = "game_test_db";
  8.  
  9. $connection = new mysqli($server_name , $server_user , $server_pass , $server_db);
  10. if(!$connection) {
  11. die("Connection failed !" . mysqli_connect_error());
  12. }
  13.  
  14. // QUERY
  15. $query = "SELECT * FROM items";
  16. $reuslt = mysqli_query($connection , $query);
  17.  
  18. if(mysqli_num_rows($reuslt) > 0){
  19. while($row = mysqli_fetch_array($reuslt)){
  20. echo "id:" . $row['id'] . "|username:" . $row['username'] . "|type:" . $row['type'] . "|score:" . $row['score'] . ";";
  21. }
  22. }
  23. ?>
  24.  
  25. public class DataLoader : MonoBehaviour {
  26.  
  27.  
  28. public string[] items;
  29.  
  30.  
  31. // Use this for initialization
  32. IEnumerator Start () {
  33. WWW itemsData = new WWW ("http://localhost/_game/test/itemsdata.php");
  34. yield return itemsData;
  35. string itemsDataStrign = itemsData.text;
  36. print (itemsDataStrign);
  37. items = itemsDataStrign.Split (';');
  38. print (GetDataValue(items[0] , "cost:"));
  39. }
  40.  
  41. string GetDataValue(string data, string index) {
  42. string value = data.Substring (data.IndexOf(index) + index.Length);
  43. if (value.Contains ("|")) {
  44. value = value.Remove (value.IndexOf("|"));
  45. }
  46. return value;
  47. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement