File "explorer022.php"

Full Path: /home/analogde/www/react-native/2024_PHP_02_11_2024/explorer/explorer022.php
File size: 3.65 KB
MIME-type: text/x-php
Charset: utf-8

 
Open Edit   Advanced Editor   Back 
<?php
// Connexion à la base de données
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "your_database_name";

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

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

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Récupérer les données de la table
$sql = "SELECT name, element FROM lists_fichiers";
$result = $conn->query($sql);

$data = [];
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $name = $row['name'];
        $element = $row['element'];
        if (!isset($data[$name])) {
            $data[$name] = [];
        }
        $data[$name][] = $element;
    }
}

$conn->close();

// Convertir le tableau en JSON
$jsonData = json_encode($data);

function scanDirectory($directory) {
    $result = [];
    $files = scandir($directory);
    foreach ($files as $file) {
        if ($file !== '.' && $file !== '..') {
            $path = $directory . DIRECTORY_SEPARATOR . $file;
            if (is_dir($path)) {
                $result[] = [
                    'name' => $file,
                    'type' => 'directory',
                    'children' => scanDirectory($path)
                ];
            } else {
                $result[] = [
                    'name' => $file,
                    'type' => 'file'
                ];
            }
        }
    }
    return $result;
}

function displayTree($tree, $fileData, $level = 0) {
    foreach ($tree as $item) {
        if (isset($fileData[$item['name']])) {
            echo '<ul class="tree-item" style="margin-left: ' . ($level * 20) . 'px; list-style-type: none;">';
            echo '<li>';
            echo '<span class="toggle" onclick="toggleTree(this)">+</span>';
            echo '<span class="name"><i class="fas fa-check-circle green-icon"></i>' . htmlspecialchars($item['name']) . '</span>';
            echo '<ul class="sub-list" style="display: none;">';
            foreach ($fileData[$item['name']] as $subElement) {
//                echo '<li class="sub-element"><i class="fas fa-file sub-element-icon"></i><span class="context-menu-trigger">' . htmlspecialchars($subElement) . '</span></li>';
                echo '<li class="sub-element"><i class="fas fa-sitemap sub-element-icon"></i><span class="context-menu-trigger">' . htmlspecialchars($subElement) . '</span></li>';

                //fa-sitemap
            }
            echo '</ul>';
            echo '</li>';
            echo '</ul>';
        } else {
            echo '<div class="tree-item" style="margin-left: ' . ($level * 20) . 'px;">';
            echo '<span class="toggle" onclick="toggleTree(this)">' . ($item['type'] === 'directory' ? '+' : '') . '</span>';
            //$iconClass = $item['type'] === 'directory' ? 'fas fa-folder directory-icon' : 'fas fa-save floppy-icon';
            
            $iconClass = $item['type'] === 'directory' ? 'fas fa-folder directory-icon' : 'fas fa-file floppy-icon';
            

            echo '<span class="name"><i class="' . $iconClass . '"></i>' . htmlspecialchars($item['name']) . '</span>';
            if (isset($item['children'])) {
                echo '<div class="tree-children" style="display: none;">';
                displayTree($item['children'], $fileData, $level + 1);
                echo '</div>';
            }
            echo '</div>';
        }
    }
}

$directory = 'path/to/your/directory'; // Remplacez par le chemin de votre répertoire

$directory = "/home/analogde/www/2024_PHP/2024_PHP_26_10_2024";

$tree = scanDirectory($directory);
?>

<!DOCTYPE html>
<html lang="fr">
<head>