Tiny File Manager

Back Back Up Advanced Editor

<?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;