Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //SERVER CONNECTION
- $server_name = "localhost";
- $server_user = "Er.Ellison";
- $server_pass = "supersecretPassword";
- $server_db = "game_test_db";
- $connection = new mysqli($server_name , $server_user , $server_pass , $server_db);
- if(!$connection) {
- die("Connection failed !" . mysqli_connect_error());
- }
- // QUERY
- $query = "SELECT * FROM items";
- $reuslt = mysqli_query($connection , $query);
- if(mysqli_num_rows($reuslt) > 0){
- while($row = mysqli_fetch_array($reuslt)){
- echo "id:" . $row['id'] . "|username:" . $row['username'] . "|type:" . $row['type'] . "|score:" . $row['score'] . ";";
- }
- }
- ?>
- public class DataLoader : MonoBehaviour {
- public string[] items;
- // Use this for initialization
- IEnumerator Start () {
- WWW itemsData = new WWW ("http://localhost/_game/test/itemsdata.php");
- yield return itemsData;
- string itemsDataStrign = itemsData.text;
- print (itemsDataStrign);
- items = itemsDataStrign.Split (';');
- print (GetDataValue(items[0] , "cost:"));
- }
- string GetDataValue(string data, string index) {
- string value = data.Substring (data.IndexOf(index) + index.Length);
- if (value.Contains ("|")) {
- value = value.Remove (value.IndexOf("|"));
- }
- return value;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement