php010

<?php

MYSQL_CONNECT("localhost", "root", "");
MYSQL_SELECT_DB("fotos");

if(array_key_exists("img", $_FILES)) {
    $tmpname = $_FILES["img"]["tmp_name"];
    $type = $_FILES["img"]["type"];
    $hndFile = fopen($tmpname, "r");
    $data = addslashes(fread($hndFile, filesize($tmpname)));

    $sql = "INSERT INTO fotos (imgdata,imgtype) VALUES ('$data', '$type')";
    MYSQL_QUERY($sql);
    echo mysql_error();
}

?>

<!DOCTYPE HTML>
<title>Fotos</title>
<meta charset="utf-8">
<script src="fancybox/lib/jquery-1.10.1.min.js"></script>
<script src="fancybox/source/jquery.fancybox.js?v=2.1.5"></script>
<link rel="stylesheet" href="fancybox/source/jquery.fancybox.css?v=2.1.5" media="screen" />

<script>
    $(document).ready(function() { $('.fancybox').fancybox(); });
</script>

<?php

$sql = "SELECT id, title FROM fotos";
$res = MYSQL_QUERY($sql);

while ($row = MYSQL_FETCH_OBJECT($res)) {
    $id = $row->id;
    $title = $row->title;
    if($row->title != null) { echo "<a class='fancybox' href='get_img.php?id=$id' data-fancybox-group='gallery' title='$title'><img src='get_img.php?id=$id' alt='$title'></a><br>"; }
    else { echo "<a class='fancybox' href='get_img.php?id=$id' data-fancybox-group='gallery' title='Bild $id'><img src='get_img.php?id=$id' alt='Bild $id'></a>"; }
}

?>

<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">

<br>Bilddatei:<br>
<input type="file" name="img" size="40"><br>
<input type="submit" name="submit" value="Abschicken">

</form>