diky vsetkym za pomoc
este sa mi zide ked budem pridavat obrazky do tej DBdatabaza-nejde
obrazky si do db nepridavaj zbytocne ti to zabere miesto v db... skor to sprav tak ze si vytvoris samostatny priecinok a do db si len po uploadnuti obrazku das cestu k nemupecko napísal:malo to byt uplne bez uvodzoviek.uz to slape
diky vsetkym za pomoc
upload.php
Kód: Vybrať všetko
<form enctype="multipart/form-data" action=upload.php method="post">";
<input type="hidden" name="MAX_FILE_SIZE" value="20000000" />
Nahrať súbor: <input type="file" name="userfile" class=textbox>
<input type="submit" value="Upload" class=button name=upload>";
</form>
<?
$size = filesize($_FILES['userfile']['tmp_name']);
$uploaddir = 'data/';
$file = $_FILES['userfile']['name'];
$uploadfile = $uploaddir . basename($file);
if ($_POST['upload'] && ($_POST['upload']=="Upload")) {
if ($size < 200000) {
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploaddir.$_FILES['userfile']['name'])) {
$link = mysql_connect ("host", "user", "pass") or die ("Error pripojenia");
$db = mysql_select_db ("db", $link) or die ("Error databaza");
$result = mysql_query("update tabulka set link = '$uploadfile' where id=1",$link);
mysql_close();
} else {
echo "error pri uploadovani suboru";
}
?>show.php
Kód: Vybrať všetko
<?
$link = mysql_connect ("host", "user", "pass") or die ("Error pripojenia");
$db = mysql_select_db ("db", $link) or die ("Error databaza");
$result = mysql_query("select * from tabulka where id=1",$link);
$row = mysql_fetch_array($result);
$link = $row['link'];
echo "<img src="$link">";
mysql_close();
?>
a ked budem mat otazky sa ozvem 
mam delete a upload obrazkuv jednom php.
mazat ide v pohode ale upload obrazku nejde,som skusal vselico...
mazat ide v pohode ale upload obrazku nejde,som skusal vselico...
Kód: Vybrať všetko
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<HEAD>
<TITLE>Výpis všech zamìstnancù</TITLE>
</HEAD>
<BODY>
<? echo "
<H1>Výpis všech zamìstnancù</H1>
<TABLE BORDER=1 CELLPADDING=2>
<TR><TH>OC</TH><TH>nazov</TH>
<TH>popis</TH>
<TH>cena</TH>
<TH>spz</TH>
<TH>Link</TH>
</TR>";
$link = mysql_Connect("");
$db = mysql_select_db ("ok_auticka", $link) or die ("Error pripojenia k databaze");
$result = mysql("ok_auticka",
"SELECT * FROM ok_auticka", $link);
$pocet = mysql_Num_Rows($result);
echo "V tabulce \"AUTA\" je
$pocet záznamù.\n";
echo "<P>";
for($i=0; $i<$pocet; $i++):
echo "<TR>\n";
echo "<TD ALIGN=CENTER>".
mysql_Result($result, $i, "OC").
"</TD>\n";
echo "<TD>".mysql_Result($result, $i, "Nazov").
"</TD>\n";
echo "<TD>".mysql_Result($result, $i, "Popis").
"</TD>\n";
echo "<TD>".mysql_Result($result, $i, "Cena").
"</TD>\n";
echo "<TD>".mysql_Result($result, $i, "spz").
"</TD>\n";
echo "<TD>".mysql_Result($result, $i, "link").
"</TD>\n";
echo "<TD><FORM ACTION=delete.php>
<INPUT TYPE=HIDDEN NAME=OC
VALUE=".
mysql_Result($result, $i, "OC").">
<INPUT TYPE=Submit VALUE=\"Smazat\"></TD></FORM>";
echo "<td>
<form enctype=multipart/form-data action=delete.php method=post>
<input type=hidden name=MAX_FILE_SIZE value=20000000 />
Nahra súbor: <input type=file name=userfile class=textbox>
<input type=submit value=Upload class=button name=upload>
</td></form>";
$size = filesize($_FILES['userfile']['tmp_name']);
$uploaddir = './data/';
$file = $_FILES['userfile']['name'];
$uploadfile = $uploaddir . basename($file);
if ($_POST['upload'] && ($_POST['upload']=="Upload")) {
if ($size < 200000) {
if (file($_FILES['userfile']['tmp_name'], $uploaddir.$_FILES['userfile']['name'])) {
$link = mysql_connect ("") or die ("Error pripojenia");
$db = mysql_select_db ("ok_auticka", $link) or die ("Error databaza");
$result = mysql_query("update ok_auticka set link = '$uploadfile' where OC='OC'",$link);
mysql_close();
} else {
echo "error pri uploadovani suboru";
}}}
echo "</TR>\n";
endfor;
$vysledek = mysql_query(
"DELETE FROM ok_auticka
WHERE OC = $OC", $link);
if (!$vysledek):
echo "<H1>Záznam se
nepodaøilo smazat!</H1>";
else:
echo "<H1>Záznam byl úspìšnì smazán</H1>";
endif;
mysql_Close();
?>
</TABLE>
</BODY>
</HTML>Kód: Vybrať všetko
...
echo "<TD><FORM ACTION=delete.php method=POST>
<INPUT TYPE=HIDDEN NAME=OC
VALUE=".
mysql_Result($result, $i, "OC").">
<INPUT TYPE=Submit VALUE=\"Smazat\"></TD></FORM>"; #pridane method=post
...
...
$result = mysql_query("update ok_auticka set link = '$uploadfile' where OC='$OC'",$link); #podmienka where OC='$OC'... musi tam byt premenna
... btw je velkost obrazka mensia ako 200kb ? alebo skus zmazat tu bodku z tadetopecko napísal:som to skusil aj tak to neficiiiiii.ked manualne pridam do db cestu k obrazku tak ho pekne ukaze ale pomocou php ho nechce ulozit do db ani uploadnut.
aaaaaaaaaaauz len to mi chyba dorobit
Kód: Vybrať všetko
$uploaddir = './data/'; Kód: Vybrať všetko
$uploaddir = '/data/';