File "mysql01.php"

Full Path: /home/analogde/www/FTP/Monsta-FTP-master/mysql01.php
File size: 6.96 KB
MIME-type: text/x-php
Charset: utf-8

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

  <style>
table, th, td {
  border:1px solid black;
  border-collapse: collapse;
}

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



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

</style>

<script>

       // 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);

    
    document.querySelectorAll('.toggle').forEach(item => {
        item.addEventListener('click', event => {
            const nextUl = item.nextElementSibling;
            if (nextUl) {
                nextUl.style.display = nextUl.style.display === 'none' || nextUl.style.display === '' ? 'block' : 'none';
            }
        });
    });*/