Inventory

<?php

include 'connect2.php';

// get POST data

$item1 = $_POST["item1"];

$item2 = $_POST["item2"];

$item3 = $_POST["item3"];

//$item1 = 2;

//$item2 = 1;

//$item3 = 3;

/* $name = "jjk";

$email = "jjk@gmail.com";

$pass = "1234";

$age = 14; */

// insert data

//INSERT INTO userprofile(userId, name, email, age, password, dateJoin) VALUES ('','hhh','hhh@gmail.com',12,'1234','2025-03-04');

//$sql = "INSERT INTO users (username, password) VALUES ('$user', '$pass')";

//$sql = "INSERT INTO userprofile(userId, name, email, age, password, dateJoin) VALUES ('','$name','$email',$age,'$pass','2025-03-04')";

$sql = "UPDATE `inventory` SET `item1`=$item1,`item2`=$item2,`item3`=$item3 WHERE `userId`=2;";

//echo $sql;

if ($conn->query($sql) === TRUE) {

    echo "Game saved.";

} else {

    echo "Game unable to save";

}

$conn->close();

?>

using UnityEngine;

[CreateAssetMenu(fileName = "itemSO", menuName = "Scriptable Objects/itemSO")]

public class itemSO : ScriptableObject

{

    public string itemName;

    public int itemID;

    public int itemCount;

    public Sprite icon;

    public int sellingPrice;

}

using UnityEngine;

public class Inventory : MonoBehaviour

{

    public void AddItem(itemSO item, int amount)

    {

        item.itemCount += amount;

    }

}

using UnityEngine;

public class PickupItem : MonoBehaviour

{

    public Inventory inventory;

    public itemSO item;

    // Start is called once before the first execution of Update after the MonoBehaviour is created

    void OnTriggerEnter(Collider hit)

    {

       // Debug.Log("CharacterController ");

        if (hit.gameObject.CompareTag("Player"))

        {

            inventory.AddItem(item, 1);

            //Debug.Log("CharacterController collided with item!");

            Destroy(gameObject);

        }

    }

}

using System.Collections;

using TMPro;

using Unity.VisualScripting;

using UnityEngine;

using UnityEngine.Networking;

public class saveGame : MonoBehaviour

{

    public itemSO[] allItems;

    string url = "http://localhost/saveGame.php";

    int[] itemQuantity;

    // Start is called once before the first execution of Update after the MonoBehaviour is created

    public void SaveGame()

    {

        StartCoroutine(saveInventory(allItems[0].itemCount, allItems[1].itemCount, allItems[2].itemCount));

    }

    /*

    public void SendData(int item1, int item2, int item3)

    {

        StartCoroutine(saveInventory(item1, item2, item3));

    }

    */

    IEnumerator saveInventory(int item1, int item2, int item3)

    {

        WWWForm form = new WWWForm();

        form.AddField("item1", item1);

        form.AddField("item2", item2);

        form.AddField("item3", item3);

        UnityWebRequest www = UnityWebRequest.Post(url, form);

        yield return www.SendWebRequest();

        if (www.result != UnityWebRequest.Result.Success)

        {

            Debug.Log("Error: " + www.error);

        }

        else

        {

            Debug.Log("Server Response: " + www.downloadHandler.text);

        }

    }

}