Upload image file to MySQL as BLOB

csun · #1 (**permalink**) Aug 16th, 2007, 17:33

hello,

i have this code below in which to upload image and store if in the database but it occurs an error upon running the program please help me im stack in here .. thankss

Code: Select all

<body>
<?
if (!isset($_REQUEST["submit"])) {

?>
<form method="POST" action="<?= $_SERVER["PHP_SELF"] ?>" enctype="application/x-www-form-
urlencoded">
<table>
<tr><td>Type</td><td><select name="imgtype"><option value="image/gif">GIF</option><option
value="image/jpeg">JPEG</option></select></td></tr>
<tr><td>File</td><td><input type="file" name="imgfile"></td></tr>
<tr><td></td><td><input type="submit" name="submit" value="upload"><input type="reset"></td></tr>
</table>
</form>

<?
//-- save image to db --
} else {
  /*
  the code below is a suggestion from California Strong...
  */
  $hndl=fopen($_REQUEST["imgfile"],"r");
  $isize=sizeof($_REQUEST["imgfile"]);

  $imgdata="";
  while(!feof($hndl)){
    $imgdata=fread($hndl,$isize);
  }; 

  /*
  my code was...
 
  $hndl=fopen($_REQUEST["imgfile"],"r");
  $imgdata=fread($hndl,filesize($_REQUEST["imgfile"]));
  */
  
   $imgdata=addslashes($imgdata); 

  $dbconn = @mysql_connect(localhost,simply22,msiatech8) or exit("SERVER Unavailable");
  @mysql_select_db(simply22_simplyok,$dbconn) or exit("DB Unavailable");


  $sql = "INSERT INTO tblimage VALUES(NULL,'". $_REQUEST["imgtype"] ."','". $imgdata ."')";
 
  @mysql_query($sql,$dbconn) or exit("QUERY FAILED!");

  mysql_close($dbconn);

  fclose($hndl);

  echo "<a href=\"test_imagedb_view.php\">view image</a>";

};
?>
</body>

errors:

Warning:fopen: failed to open stream: No such file or directory in
Warning: feof(): supplied argument is not a valid stream resource in on line 26

jimz · #2 (**permalink**) Aug 17th, 2007, 16:32

your error message is basically saying that there is no image, so $_REQUEST["imgfile"] has no image 'in it'

remove your current enctype:
enctype="application/x-www-form-urlencoded"

if you want to upload any file with a form you must have this attribute:
enctype="multipart/form-data"

don't worry, I think this gets EVERY php developer when they're starting out...

that should do the trick

Kropotkin · #3 (**permalink**) Aug 21st, 2007, 14:44

Jim

Doesn't he need to use $_FILES rather than $_REQUEST to get the uploaded file ?

Justin

jimz · #4 (**permalink**) Aug 22nd, 2007, 10:39

I stand corrected! sorry...

Quote:

Since PHP 4.3.0, FILE information from $_FILES does not exist in $_REQUEST.

More info on request here: http://ca.php.net/manual/en/language...predefined.php

I don't use and would not advise using $_REQUEST at all and instead use $_GET or $_POST. I didn't want to confuse csun by giving to much info.

Kropotkin · #5 (**permalink**) Aug 22nd, 2007, 13:14

Hi Jimz

I didn't know it ever did.

Justin

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP+SQL+File Upload	joshlindem	PHP Forum	5	May 10th, 2008 16:48
file upload	berry05	Job Opportunities	0	Mar 19th, 2008 19:09
[SOLVED] Image Upload with PHP/MySQL	kidreapertronV	PHP Forum	5	Jan 31st, 2008 17:08
asp file upload script having problems with MYSQL	paulmcn	Classic ASP	2	Oct 5th, 2005 18:45
file upload asp-mysql database	fluff	Classic ASP	7	Aug 19th, 2004 10:45

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Upload image file to MySQL as BLOB