File "recuperation2.php"

Full Path: /home/analogde/www/Dev tableau/recuperation2.php
File size: 3.95 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);
    }

    //["1","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 les données JSON à partir de la base de données
    //$sql = "SELECT contenu FROM tableau WHERE id = 1"; // Exemple avec un ID précis
    $sql = "SELECT contenu FROM tableau ORDER BY id DESC LIMIT 1"; // Assurez-vous que "id" est bien la clé primaire auto-incrémentée
    $result = $conn->query($sql);

    /*$sql = "SELECT contenu FROM tableau WHERE id = 1";
    $result = $conn->query($sql);

    // Vérifier si des données sont retournées
    if ($result->num_rows > 0) 
    {
        $row = $result->fetch_assoc();
    
        // Décoder le JSON
        $contenuArray = json_decode($row['contenu'], true);

        // Vérifier si le JSON est valide
        if (json_last_error() === JSON_ERROR_NONE) 
        {
            echo "<pre>";
            print_r($contenuArray); // Affiche sous forme de tableau PHP
            echo "</pre>";
        } 
        else 
        {
            echo "Erreur lors du décodage JSON : " . json_last_error_msg();
        }
    } 
    else 
    {
        echo "Aucune donnée trouvée.";
    }*/

    if ($result->num_rows > 0) 
    {

        $row = $result->fetch_assoc();
        //echo $row['contenu']; // Assurez-vous que le champ `contenu` contient bien un JSON valide

        //$row['contenu'] = json_decode($row['contenu'], true); // Convertit le texte JSON en tableau PHP

        echo $row['contenu'];

        // Récupérer la ligne du résultat
        //$row = $result->fetch_assoc();
        // Afficher les données JSON brutes pour vérifier
        //echo "<pre>" . $row['contenu'] . "</pre>"; // Affiche les données avant le décodage

        /*$decoded = json_decode($row['contenu'], true);
        if (is_array($decoded)) 
        {
            echo "Tableau JSON détecté : ";
            print_r($decoded);
            echo "\n";
        }*/

        /*foreach ($row['contenu'] as $element) {
        $decoded = json_decode($element, true);
        
        if (is_array($decoded)) 
        {
            echo "Tableau JSON détecté : ";
            print_r($decoded);
            echo "\n";
        }
        }*/

        // Décoder le JSON en tableau PHP
        //$data = json_decode($row['contenu'], true);
        // Afficher les données
        // print_r($data);
    } 

    else 
    {
        echo "Aucune donnée trouvée.";
    }

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

    // Convertir le tableau PHP en chaîne JSON
    //$json_data = json_encode($data);
    //echo $json_data;

?>