Galeria

<?php

$pripojenie = mysql_connect("mysql.tym.cz", "tym_dessert", "xxx");
mysql_select_db("tym_dessert");
$sql = "CREATE TABLE obrazky(";
$sql .= "id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,";
$sql .= "vyska INT,";
$sql .= "sirka INT,";
$sql .= "obrazok BLOB);";
mysql_query($sql) or die ("Nastala chyba !");
mysql_close($pripojenie);

?>

<?php
$nazov_obrazku = "obr.jpg";
$subor = fopen($nazov_obrazku, "r");
$data = fread($subor, filesize($nazov_obrazku));
$data = addslashes($data);
fclose($subor);
$rozmery = GetImageSize($nazov_obrazku);
$vyska = $rozmery[1];
$sirka = $rozmery[0];
$pripojenie = mysql_connect("mysql.tym.cz", "tym_dessert", "xxx");
mysql_select_db("tym_dessert");
$sql = "INSERT INTO obrazky (vyska, sirka, obrazok) VALUES ('$vyska', '$sirka', '$data');";
mysql_query($sql);
mysql_close($pripojenie);

?>

     <?
Header("Content-type: image/jpg");
$pripojenie = mysql_connect("mysql.dessert.tym", "tym_dessert", "xxx");
mysql_select_db("tym_dessert");
$sql = "SELECT * FROM obrazky WHERE id = 1;";
$vysledok = mysql_query($sql);
$obrazok = mysql_fetch_array($vysledok);
echo $obrazok["obrazok"];
mysql_close($pripojenie);
?>

<img src=”vytiahnutie_z_db.php?id=1“>

<? Php 

mysql_connect ("mysql.tym.cz", "tym_dessert", "xxx") or die (mysql_error ());

 mysql_select_db ("tym_dessert") or die (mysql_error ());
get while($row = mysql_fetch_array( $result )) {
$row['obrazky']." - ".$row['vyska'].
 $ result = mysql_query ("SELECT * FROM obrazky '") or die (mysql_error ());
while ($ row = mysql_fetch_array ($ result)) (
 $ row ['obrazky']. "-". $ row ['vyska']. "<br />"; } ?> "<br /> ";)?>