File "trash02.php"

Full Path: /home/analogde/www/Prog/File explorer/trash02.php
File size: 1.43 KB
MIME-type: text/x-php
Charset: utf-8

<?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();



}

?>