Tiny File Manager

Back Back Up Advanced Editor

<?php
/*
CREATE TABLE base_fichier (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `nombre_revision` id INT(6) NOT NULL,
  `courante` id INT(6) NOT NULL,
  `identifiant` varchar(100) NOT NULL,
  PRIMARY KEY (id)
) 
uniqid();

$name = "P1000122.JPG";
  $identifant = uniqid();

$sql = "INSERT INTO base_fichier (name, identifiant) VALUES ('$name', '$identifiant' )";

//insertion();

//query();

$dbHost = "analogdepat.mysql.db";   
    $dbUsername = "analogdepat"; 	   
    $dbPassword = "Un92pac007";	    
    $dbName = "analogdepat";

//$conn = mysqli_connect('analogdepat.mysql.db', 'analogdepat', 'Un92pac007', 'analogdepat');
    //$sql = "SELECT * FROM aww";
    //$result = mysqli_query($conn, $sql);
    //$files = mysqli_fetch_all($result, MYSQLI_ASSOC);

$mysqli = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
    if($mysqli->connect_errno ) 
    {
      printf("Connect failed: %s", $mysqli->connect_error);
      exit();
    }

$search = "P1000122.JPG";

//$query = "SELECT * FROM aww WHERE name = 'P1000122.JPG'";

$query = "SELECT * FROM aww WHERE name = '$search'";

echo "Requete  " .$query;

echo "<br><br><br>";

$result = $mysqli->query($query);

if ($result->num_rows > 0) 
      {
        echo "Le champ 'nom' avec la valeur 'patrice' existe dans la table.";
        } 
        else 
        {
        echo "Le champ 'nom' avec la valeur 'patrice' n'existe pas dans la table.";
        }

if($result = $mysqli->query($query))
    {

// Renvoie le nombre de lignes 
      $rowcount = mysqli_num_rows( $result );

echo $rowcount ."<br>";

while($row = mysqli_fetch_row($result))
      {
        echo $row[1] ." " .$row[2] ." " .$row[3] ."<br>";
      }
   }

if($mysqli->error)
   {
      printf("Failed..!" , $mysqli->error);
   }
   
   $mysqli->close();

/*
   $livres = [];

// Étape 1 : Déclaration des valeurs
$titre1 = "1984";
$auteur1 = "George Orwell";
$annee1 = 1949;

$titre2 = "Le Petit Prince";
$auteur2 = "Antoine de Saint-Exupéry";
$annee2 = 1943;

$livres[] = [
    'titre' => $titre1,
    'auteur' => $auteur1,
    'annee' => $annee1,
];

$livres[] = [
    'titre' => $titre2,
    'auteur' => $auteur2,
    'annee' => $annee2,
];

// Affichage du tableau
echo "<pre>";
print_r($livres);
echo "</pre>";

function generer_multidimentional()
{

$files = [
              'document.txt' => ['version1', 'version2', 'version3'],
              'image.png' => ['version1', 'version2'],
            'script.php' => ['version1']
          ];

// Initialisation du tableau multidimensionnel
          $multidimensionalArray = [];

foreach ($files as $file => $versions) 
          {
              // Création de l'entrée pour chaque fichier
              $entry = [
                'fichier' => $file,
                'children' => []
              ];

// Ajout des versions au tableau children
              foreach ($versions as $version) 
              {
                $entry['children'][] = [
                  'fichier' => $version
                ];
              }

// Ajout de l'entrée au tableau principal
              $multidimensionalArray[] = $entry;
            
          }

// Affichage du résultat
          return $multidimensionalArray;

}

function insertion()
{
    $dbHost = "analogdepat.mysql.db";   
    $dbUsername = "analogdepat"; 	   
    $dbPassword = "Un92pac007";	    
    $dbName = "analogdepat";	
    $conn = mysqli_connect('analogdepat.mysql.db', 'analogdepat', 'Un92pac007', 'analogdepat');

$name = "P1000122.JPG";
    $name = "credipart.pdf";
    $nombre_revision = 3;
    $courante = 2;
    $identifiant = uniqid();
    
    $sql = "INSERT INTO base_fichier (name, nombre_revision, courante, identifiant) VALUES ('$name', '$nombre_revision', '$courante' , '$identifiant' )";

if (mysqli_query($conn, $sql)) 
    {
      echo "Nouveau enregistrement créé avec succès";
    } 
    else 
    {
      echo "Erreur : " . $sql . "<br>" . mysqli_error($conn);
    }
  
    mysqli_close($conn);

echo "Done";

}

function query()
{
    $dbHost = "analogdepat.mysql.db";   
    $dbUsername = "analogdepat"; 	   
    $dbPassword = "Un92pac007";	    
    $dbName = "analogdepat";	
    //$conn = mysqli_connect('analogdepat.mysql.db', 'analogdepat', 'Un92pac007', 'analogdepat');

$mysqli = new mysqli( $dbHost ,  $dbUsername ,  $dbPassword , $dbName);

if ($mysqli -> connect_errno) 
    {
      echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
      exit();
    }

$sql = "SELECT * FROM base_fichier"; // ORDER BY Lastname";
    $result = $mysqli -> query($sql);

// Associative array
    //$row = $result -> fetch_assoc();
    //printf ("%s (%s)\n", $row["Lastname"], $row["Age"]);

while($obj = mysqli_fetch_assoc($result))
    {

echo " **** " .$obj["id"] ." " .$obj["name"] ." " .$obj["nombre_revision"] ." " .$obj["courante"] ." " .$obj["identifiant"];
        echo "<br>";

//print("ID: ".$obj["id"]."\n");
        //print("Name: ".$obj["name"]."\n");

//print("Courante: ".$obj["courante"]."\n");
      
        //print("Rev: ".$obj["nombre_revision"]."\n");

//print("Identifiant: ".$obj["identifiant"]."\n");
      
    }

// Free result set
    $result -> free_result();

$mysqli -> close();

}

<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8" />
  <link rel="stylesheet" href="style.css">
  <title>Download files</title>

td {
  text-align: center;
  vertical-align: middle;
}

ul {
            list-style-type: none;
            padding-left: 20px;
        }
        .toggle {
            cursor: pointer;
            color: blue;
            text-decoration: underline;
        }

</style>

// const filesData  = <?php echo json_encode( generer_multidimentional() ) ?>;

function createTree(files) {
        const ul = document.createElement('ul');

files.forEach(file => {
            const li = document.createElement('li');
            const span = document.createElement('span');
            span.classList.add('toggle');
            span.textContent = file.name;

li.appendChild(span);

if (file.children) {
                const childUl = createTree(file.children);
                li.appendChild(childUl);
            }

ul.appendChild(li);
        });

return ul;
    }

/*const fileTree = createTree(filesData);
    document.getElementById('fileTree').appendChild(fileTree);