File "fetch_data.php"

Full Path: /home/analogde/www/WORDPRESS/Dev tableau/fetch_data.php
File size: 1.25 KB
MIME-type: text/x-php
Charset: utf-8

<?php
$host = "analogdepat.mysql.db";
$dbname = "analogdepat";
$username = "analogdepat";
$password = "Un92pac007";
$table = "json_data";

// Connexion à la base de données
$conn = new mysqli($host, $username, $password, $dbname);

// Vérifier la connexion
if ($conn->connect_error) {
    die(json_encode(["success" => false, "message" => "Connexion échouée : " . $conn->connect_error]));
}

// Récupérer les données POST
$data = json_decode(file_get_contents('php://input'), true);
$selectedDate = $data['date'];

// Préparer la requête SQL
$sql = "SELECT data_json FROM $table WHERE created_at = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $selectedDate);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    //echo json_encode(["success" => true, "jsonData" => json_decode($row['data_json'])]);
    echo json_encode(["success" => true, "data_json" => json_decode($row['data_json'])]);
    //echo json_encode(['success' => true, 'data_json' => $row['data_json']]);
} else {
    echo json_encode(["success" => false, "message" => "Aucune donnée trouvée pour la date sélectionnée."]);
}

// Fermer la connexion
$stmt->close();
$conn->close();
?>