Breaking News: Grepper is joining You.com. Read the official announcement!

Unity_SQL

Karrtik Ma answered on June 27, 2024 Popularity 2/10 Helpfulness 1/10

answer Unity_SQL

related Unity_SQL

Unity_SQL

Comment

using UnityEngine;
using System;
using System.Net;
using System.Collections.Generic;
using Newtonsoft.Json;

public class DatabaseConnector : MonoBehaviour
{
    [Serializable]
    public class SensorReading
    {
        public string sensor_id;  // Changed from int to string
        public float reading_value;
    }

    public string apiUrl = "http://localhost/sensor_data/test.php";
    public float updateInterval = 1f;
    private List<SensorReading> sensorReadings = new List<SensorReading>();

    private void Start()
    {
        // Disable certificate validation (use only for testing with localhost)
        ServicePointManager.ServerCertificateValidationCallback += (sender, cert, chain, sslPolicyErrors) => true;

        // Start fetching data
        InvokeRepeating("FetchData", 0f, updateInterval);
    }

    private void FetchData()
    {
        try
        {
            using (WebClient client = new WebClient())
            {
                string jsonResult = client.DownloadString(apiUrl);
                Debug.Log("Received JSON: " + jsonResult);

                sensorReadings = JsonConvert.DeserializeObject<List<SensorReading>>(jsonResult);
                DisplaySensorReadings();
            }
        }
        catch (WebException e)
        {
            Debug.LogError("WebException Error: " + e.Message);
            if (e.Response != null)
            {
                using (var errorResponse = (HttpWebResponse)e.Response)
                {
                    Debug.LogError("HTTP Status Code: " + errorResponse.StatusCode);
                    using (var reader = new System.IO.StreamReader(errorResponse.GetResponseStream()))
                    {
                        string errorText = reader.ReadToEnd();
                        Debug.LogError("Error Response Body: " + errorText);
                    }
                }
            }
        }
        catch (JsonException je)
        {
            Debug.LogError("JSON Parsing Error: " + je.Message);
        }
        catch (Exception ex)
        {
            Debug.LogError("General Error: " + ex.Message);
        }
    }

    private void DisplaySensorReadings()
    {
        foreach (SensorReading reading in sensorReadings)
        {
            Debug.Log($"Sensor ID: {reading.sensor_id}, Value: {reading.reading_value}");
        }
    }
}

Popularity 2/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c#

Link to this answer
Share Copy Link

Contributed on Jun 27 2024

Karrtik Ma

0 Answers Avg Quality 2/10

Closely Related Answers

Unity_SQL

Comment

<?php

header('Content-Type: application/json');

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "sensor_data";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die(json_encode(["error" => "Connection failed: " . $conn->connect_error]));
}

$sql = "SELECT sensor_id, reading_value FROM sensor_readings";
$result = $conn->query($sql);

$sensor_data = [];

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        $sensor_data[] = [
            'sensor_id' => $row['sensor_id'],
            'reading_value' => $row['reading_value']
        ];
    }
}

echo json_encode($sensor_data, JSON_PRETTY_PRINT);

$conn->close();
?>

Popularity 2/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: php

Link to this answer
Share Copy Link

Contributed on Jun 27 2024

Karrtik Ma

0 Answers Avg Quality 2/10

Unity_SQL

Contents

More Related Answers

Unity_SQL

Closely Related Answers

Unity_SQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.