U bazi imam sledecu tabelu images i u polje "image" hocu da upisem naziv slike a u polje "image_blob" upisem sliku.
Tabela "images":
Code:
CREATE TABLE `images` (
`id` int(11) NOT NULL auto_increment,
`image` varchar(100) collate utf8_unicode_ci default NULL,
`image_blob` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE `images` (
`id` int(11) NOT NULL auto_increment,
`image` varchar(100) collate utf8_unicode_ci default NULL,
`image_blob` longblob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Forma sa koje unosim sliku izmedju ostalog ima polje za upload slike:
Code:
<form action="upis.php" method="post">
<input name="image" type="file">
<input type="submit" name="Submit" value="Unesi u bazu" >
</form>
<form action="upis.php" method="post">
<input name="image" type="file">
<input type="submit" name="Submit" value="Unesi u bazu" >
</form>
Upit kojim unosim podatke u bazu izgleda ovako:
Code:
$sql = "insert into images (id, image, image_blob)
values
(NULL, '".$_FILES['image']['name']."','".addslashes(fread(fopen($_FILES['image']['tmp_name'], "rb"),100000))."')";
$sql = "insert into images (id, image, image_blob)
values
(NULL, '".$_FILES['image']['name']."','".addslashes(fread(fopen($_FILES['image']['tmp_name'], "rb"),100000))."')";
Ali upis nije moguc jer mi javlja sledecu gresku:
Warning: fread(): supplied argument is not a valid stream resource in C:\wamp\www\upis.php on line 92
, a u tom redu stoji upit koji sam gore napisao.
Da li neko moze da mi pomogne.
Ps. Da li neko zna kako da u jos jedno polje "extenzija" u tabeli mogu da upisem extenziju slike.Tj da li ima neka f-ja koja vraca extenziju slike?
djLapac