<?php
# Make sure an ID was passed
if(isset($_GET['id']))
{
# Get the ID
$id = $_GET['id'];
# Make sure the ID is in fact a valid ID
if(!is_numeric($id) || ($id <= 0)) {
die("The ID is invalid!");
}
# Connect to the database
$dbLink = mysqli_connect("127.0.0.1", "user", "pwd", "dbName");
if(mysqli_connect_errno()) {
die("MySQL connection failed: ". mysqli_connect_error());
}
# Fetch the file information
$query = "
SELECT FileMime, FileName, FileSize, FileData
FROM fileStorage
WHERE FileID = {$id}";
$result = @mysqli_query($dbLink, $query)
or die("Error! Query failed: <pre>". mysqli_error($dbLink) ."</pre>");
# Make sure the result is valid
if(mysqli_num_rows($result) == 1)
{
# Get the row
$row = mysqli_fetch_assoc($result);
# Print headers
header("Content-Type: ". $row['FileMime']);
header("Content-Length: ". $row['FileSize']);
header("Content-Disposition: attachment; filename=". $row['FileName']);
# Print data
echo $row['FileData'];
}
else
{
echo "Error! No image exists with that ID.";
}
# Free the mysqli resources
@mysqli_free_result($result);
@mysqli_close($dbLink);
}
else
{
echo "Error! No ID was passed.";
}
?>
Inace je kod preuzet sa jednog tutorijala, svi se hvale da radi ok, kod mene nece ni u jednom browseru da radi kako treba...
#include <beer.h>
#include <girls.h>
main(){ run(partytime);}
www.vrnjackabanjacaffe.com