File "get_files.php"

Full Path: /home/analogde/www/Meubles/get_files.php
File size: 1.9 KB
MIME-type: text/x-php
Charset: utf-8

<?php
// Paramètres de connexion à la base de données
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "file_version_db";

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

// Créer une connexion
$conn = new mysqli($servername, $username, $password, $dbname);

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

// Requête pour récupérer les fichiers et leurs versions
//$sql = "SELECT file_name, GROUP_CONCAT(version ORDER BY version SEPARATOR ', ') as versions FROM files_version GROUP BY file_name";

//$sql = "SELECT * FROM files_version";
$sql = "SELECT file_name, version FROM files_version";

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

// Tableau pour stocker les données
$files = [];

/*if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $files[$row['file_name']] = explode(', ', $row['versions']);
    }
}*/

// Tableau pour stocker les données

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $file_name = $row['file_name'];
        $version = $row['version'];
        if (!isset($files[$file_name])) {
            $files[$file_name] = [];
        }
        $files[$file_name][] = $version;
    }
}


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

// Envoyer le JSON au client
header('Content-Type: application/json');
echo $jsonData;

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

/*
CREATE TABLE files_version (
    id INT AUTO_INCREMENT PRIMARY KEY,
    file_name VARCHAR(255) NOT NULL,
    version VARCHAR(50) NOT NULL
);

INSERT INTO files_version (file_name, version) VALUES
('f1', 'v1'),
('f1', 'v2'),
('f1', 'v3'),
('f2', 'v1'),
('f2', 'v2'),
('f3', 'v1'),
('f3', 'v2'),
('f3', 'v3'),
('f3', 'v4'),
('f4', 'v1'),
('f5', 'v1'),
('f5', 'v2'),
('f5', 'v3'),
('f5', 'v4'),
('f5', 'v5');
*/
?>