File "recuperation.php"

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

<?php

$host = "analogdepat.mysql.db";   
$dbname = "analogdepat";
$username = "analogdepat"; 	   
$password = "Un92pac007";



// Création de la connexion MySQL avec mysqli
$conn = new mysqli($host, $username, $password, $dbname);

// Vérification de la connexion
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Récupérer les données sérialisées à partir de la base de données
$sql = "SELECT table_task FROM data WHERE id = 1"; // Exemple d'ID = 1

$sql = "SELECT data FROM table_task WHERE id = 1";


echo $sql;

$result = $conn->query($sql);

if ($result->num_rows > 0) 
{
    // Récupérer la ligne du résultat
    $row = $result->fetch_assoc();

    // Désérialiser les données
    $data = unserialize($row['data']);

    // Afficher les données
    print_r($data);
} 
else 
{
    echo "Aucune donnée trouvée.";
}

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

/*header("Content-Type: application/json");


$conn = new mysqli($servername, $username, $password, $database);

if ($conn->connect_error) {
    die(json_encode(["status" => "error", "message" => "Erreur de connexion: " . $conn->connect_error]));
}

echo "plouf";

[
    [
        "Option 1",
        "2",
        0,
        1,
        1,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0,
        0
    ]
]

// Récupérer la dernière entrée JSON
//$sql = "SELECT data FROM tableau_json ORDER BY created_at DESC LIMIT 1";
$sql = "SELECT CAST(data AS CHAR) AS data FROM tableau_data ORDER BY id DESC LIMIT 1";

echo $sql;

$result = $conn->query($sql);

if ($result->num_rows > 0) 
{
    $row = $result->fetch_assoc();
    echo json_decode($row["data"]);

    //echo json_encode(["status" => "success", "data" => json_decode($row["data"])]);
    echo "Zoulou";
} 
/*else 
{
    echo json_encode(["status" => "error", "message" => "Aucune donnée trouvée"]);
}*/
/*
$conn->close();*/
?>