obrazky upload

CREATE TABLE IF NOT EXISTS `obrazky` (
  `id` int(11) NOT NULL auto_increment,
  `datum` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `foto` text collate utf8_czech_ci NOT NULL,
  `jmeno` varchar(255) collate utf8_czech_ci NOT NULL,
  `zprava` text collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `jmeno` (`jmeno`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

<form method = "post" enctype="multipart/form-data" action="upload.php">
<table cellspacing = "0" cellpadding = "2">
<tr><td>Fotka:&nbsp;</td> <td><input type = "file" name = "photo" /></td></tr>
<tr><td>Jméno fotky:&nbsp;</td> <td><input type = "text" name = "jmeno" /></td></tr>
<tr><td colspan = "2"><input type = "submit" name = "upload" value = "Nahrát fotku" /></td></tr>
</table>
</form>

$t_slozka = "small";
$n_slozka = "upload";
$o_slozka = "original";
function diakritika($obr)
{
static $tbl = array("\xc3\xa1"=>"a","\xc3\xa4"=>"a","\xc4\x8d"=>"c","\xc4\x8f"=>"d","\xc3\xa9"=>"e","\xc4\x9b"=>"e","\xc3\xad"=>"i","\xc4\xbe"=>"l","\xc4\xba"=>"l","\xc5\x88"=>"n","\xc3\xb3"=>"o","\xc3\xb6"=>"o","\xc5\x91"=>"o","\xc3\xb4"=>"o","\xc5\x99"=>"r","\xc5\x95"=>"r","\xc5\xa1"=>"s","\xc5\xa5"=>"t","\xc3\xba"=>"u","\xc5\xaf"=>"u","\xc3\xbc"=>"u","\xc5\xb1"=>"u","\xc3\xbd"=>"y","\xc5\xbe"=>"z","\xc3\x81"=>"A","\xc3\x84"=>"A","\xc4\x8c"=>"C","\xc4\x8e"=>"D","\xc3\x89"=>"E","\xc4\x9a"=>"E","\xc3\x8d"=>"I","\xc4\xbd"=>"L","\xc4\xb9"=>"L","\xc5\x87"=>"N","\xc3\x93"=>"O","\xc3\x96"=>"O","\xc5\x90"=>"O","\xc3\x94"=>"O","\xc5\x98"=>"R","\xc5\x94"=>"R","\xc5\xa0"=>"S","\xc5\xa4"=>"T","\xc3\x9a"=>"U","\xc5\xae"=>"U","\xc3\x9c"=>"U","\xc5\xb0"=>"U","\xc3\x9d"=>"Y","\xc5\xbd"=>"Z");
return strtr($obr, $tbl);
}

$t_width = 150;
$t_height = 150;
$n_width = 400;
$n_height = 400;

if(isset($_POST['upload'])){
if(is_uploaded_file($_FILES['photo']['tmp_name'])){
$pathinfo = pathinfo($_FILES['photo']['name']);
$permited_file_types = array('jpg','JPG','JPEG','jpeg','gif','GIF','png','PNG');
if(in_array($pathinfo['extension'],$permited_file_types)){
if(list($sirka, $vyska) = getimagesize($_FILES['photo']['tmp_name'])){
if ($_FILES['photo']['size'] > 512*1024*3) {
echo"Můžeš nahrávat pouze obrázky do 1.5MB <br /><br>";
}else{
$exist=preg_replace('/(.)\\1{2,}/', '\\1',diakritika($_FILES['photo']['name']));
if(!file_exists("$o_slozka/$exist")){
if(move_uploaded_file($_FILES['photo']['tmp_name'],$o_slozka."/".preg_replace('/(.)\\1{2,}/', '\\1',diakritika($_FILES['photo']['name'])))){
$obr=preg_replace('/(.)\\1{2,}/', '\\1',diakritika($_FILES['photo']['name']));
if($obr){
/* ========================== JPG =========================== */
$jpg = array('jpg','JPG','JPEG','jpeg');
if(in_array($pathinfo['extension'],$jpg)){
//Thumbnail
$im=imagecreatefromjpeg("$o_slozka/$obr");
$pomer=imagesx($im)/imagesy($im);
$pvyska=$n_width/$pomer;
$s_obrazek=imagecreatetruecolor($t_width,$t_height) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($s_obrazek,$im,0,0,0,0,$t_width,$t_height,imagesx($im),imagesy($im)); // zmensime obrazek
imagejpeg($s_obrazek,"$t_slozka/$obr");
imagedestroy ($im);
//obraz
$im=imagecreatefromjpeg("$o_slozka/$obr");
$obrazek=imagecreatetruecolor($n_width,$pvyska) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($obrazek,$im,0,0,0,0,$n_width,$pvyska,imagesx($im),imagesy($im)); // zmensime obrazek
if(imagejpeg($obrazek,"$n_slozka/$obr")){

$db->query("INSERT INTO obrazky VALUES('', '','$obr', '{$_POST['jmeno']}', '{$_POST['zprava']}''')");
echo "<center><img src='$t_slozka/$obr'></center><br />Soubor byl uploadován a zpracován<br /><br>";
imagedestroy ($im);
}
}
/* ======================= /JPG\ ==============================*/

/* =======================PNG ==============================*/
$png = array('png','PNG');
if(in_array($pathinfo['extension'],$png)){
//Thumbnail
$im=imagecreatefrompng("$o_slozka/$obr");
$pomer=imagesx($im)/imagesy($im);
$pvyska=$n_width/$pomer;
$s_obrazek=imagecreatetruecolor($t_width,$t_height) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($s_obrazek,$im,0,0,0,0,$t_width,$t_height,imagesx($im),imagesy($im)); // zmensime obrazek
imagejpeg($s_obrazek,"$t_slozka/$obr");
imagedestroy ($im);
//obraz
$im=imagecreatefrompng("$o_slozka/$obr");
$obrazek=imagecreatetruecolor($n_width,$pvyska) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($obrazek,$im,0,0,0,0,$n_width,$pvyska,imagesx($im),imagesy($im));
// zmensime obrazek
if(imagepng($obrazek,"$n_slozka/$obr")){
$db->query("INSERT INTO obrazky VALUES('', '','$obr', '{$_POST['jmeno']}', '{$_POST['zprava']}''')");
echo "<center><img src='$t_slozka/$obr'></center><br />Soubor byl uploadován a zpracován<br /><br>";
imagedestroy ($im);
}
}
/* ========================== /PNG\ ==============================*/
/* =========================== GIF ===============================*/
$gif = array('gif','GIF');
if(in_array($pathinfo['extension'],$gif)){
//Thumbnail
$im=imagecreatefromgif("$o_slozka/$obr");
$pomer=imagesx($im)/imagesy($im);
$pvyska=$n_width/$pomer;
$s_obrazek=imagecreatetruecolor($t_width,$t_height) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($s_obrazek,$im,0,0,0,0,$t_width,$t_height,imagesx($im),imagesy($im)); // zmensime obrazek
imagegif($s_obrazek,"$t_slozka/$obr");
imagedestroy ($im);
//obraz
$im=imagecreatefromgif("$o_slozka/$obr");
$pomer=imagesx($im)/imagesy($im);
$pvyska=$n_width/$pomer;
$obrazek=imagecreatetruecolor($n_width,$pvyska) or die("Nemohou se načíst nové GD předvolby <br />");
imagecopyresampled($obrazek,$im,0,0,0,0,$n_width,$pvyska,imagesx($im),imagesy($im));
// zmensime obrazek
if(imagegif($obrazek,"$n_slozka/$obr")){
$db->query("INSERT INTO obrazky VALUES('', '','$obr', '{$_POST['jmeno']}', '{$_POST['zprava']}''')");
echo "<center><img src='$t_slozka/$obr'></center><br />Soubor byl uploadován a zpracován<br /><br>";
imagedestroy ($im);
}
}
/* ============================= /GIF\ ============================== */
}else echo "Soubor se bohužel nenahrál. Zkontrolujte zda vyhovuje všem podmí­nkám.<br /><br>";
}
}else echo"Obrázek tohoto názvu již existuje<br /><br>";
}
}else echo"Můžete nahrávat pouze obrázky' <br /><br>";
}else echo"Jsou povoleny pouze soubory jpg, gif, png <br /><br>";
}else echo"Nebyl zadán soubor<br /><br>";
}
}

try {
  //vykonny chod
} catch (Exception $ex) {
  //osetreni vyhozene vyjimky
}

try {
  OtevriDB();
} catch (Exception $ex){
  echo $ex->getMessage();
  die();
}

try {
    $db = new mysqli('hostitel', 'uzivatel', 'heslo', 'tabulka');
    $db->query("SET NAMES 'utf8';");
    if(mysqli_connect_errno()){
        throw new Exception('connect databases faild!');
    }
}
catch (Exception $e){
    echo  $e->getMessage();
}

print "{$info['jmeno']}<p><a href=\"http://s-anime.webovka.eu/galerie/upload/{$info['foto']}\" target='_blank'><img src=\"http://s-anime.webovka.eu/galerie/small/{$info['foto']}\"></A>";

print "{$info['jmeno']}<p><img src=\"http://s-anime.webovka.eu/galerie/small/{$info['foto']}\"> Zobrazit obrázek: 
<a href=\"http://s-anime.webovka.eu/galerie/upload/{$info['foto']}\" target='_blank'> 50% </A>
<a href=\"http://s-anime.webovka.eu/galerie/original/{$info['foto']}\" target='_blank'> 100% </A>
";