Tiny File Manager

Back Back Up Advanced Editor

<?php

$image = "07.jpg";

echo '<p><a href="download.php?file=' . urlencode($image) . '">Download</a></p>';

ffff();
    interrogation();

function ffff()
{
     //select *from DemoTable651 where Value LIKE 'course';

//$results = mysqli_query($mysqli, "SELECT * FROM players WHERE firstname LIKE '%test%'");

$db_host = "analogdepat.mysql.db";
     $db_user = "analogdepat";
     $db_pass = "Un92pac007";
     $db_name = "analogdepat";
 
     $conn = new mysqli($db_host, $db_user, $db_pass, $db_name);

$sql = "SELECT * FROM files";
     $results = $conn->query($sql);

if ($results->num_rows > 0) 
     {
            while ($row = $results->fetch_assoc()) 
            {
                  // filename, filesize, filetype
                  echo $row["filename"] ." " .$row["filesize"] ." " . $row["filetype"] ."<br><br>";
            }
      }

$conn->close();

}

function interrogation()
{
    $db_host = "analogdepat.mysql.db";
    $db_user = "analogdepat";
    $db_pass = "Un92pac007";
    $db_name = "analogdepat";

$conn = new mysqli($db_host, $db_user, $db_pass, $db_name);

$find_filename = "07.jpg";

$sql = "SELECT * FROM files WHERE filename LIKE '$find_filename' ";

echo "Query " .$sql;

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

if ($results->num_rows > 0) 
    {
        echo "bingo";
    }

$conn->close();

}