Specific Image Upload Problem

daprezjer

I'm trying to upload images into and view images from an SQL database. I've used the tutorials here and on other sites w/ the exact same results. Basically I can't load my images into the database. Here's the code stripped down to it's basics:

Page 1: Form for entering data

<html>
<head><title>Store binary data into SQL Database</title></head>
<body>
<form method="post" action="images2.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data" size="40">
<p><input type="submit" name="submit" value="submit">
</form>
</body>
</html>

Page 2: images2.php , file for processing data

<html>
<head><title>Store binary data into SQL Database</title></head>
<body>

<?php
// code that will be executed if the form has been submitted:
MYSQL_CONNECT("localhost","root","spa1spa1");
mysql_select_db("SPA");
$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));
$result=MYSQL_QUERY("INSERT INTO images (binary_junk,filename,filesize,filetype) VALUES ('$data','$form_data_name','$form_data_size','$form_data_type')");
MYSQL_CLOSE();
print $_POST['form_data_name'];
?>

You did it.

</body>
</html>

Problem: Seems I'm attaching to the database just fine, but it's giving me a bunch of undefinied variable errors:
Notice: Undefined variable: form_data in c:\inetpub\wwwroot\images2.php on line 17

Notice: Undefined variable: form_data in c:\inetpub\wwwroot\images2.php on line 17

Warning: fread(): supplied argument is not a valid stream resource in c:\inetpub\wwwroot\images2.php on line 17

etc.

You can see that I also included print $Post_['form_data_name']; just to see if it came through at all, which it didn't. The page is available at http://spa.ward.american.edu/images.php .

Thanks so much,
J

philipolson

Here's what you should submit your form to (images2.php):

<pre>
<?php
    print_r($_POST);
?>

It will tell you what lives in $_POST. Of course this assumes you are using a PHP version of at least 4.1.0 Also, don't rely on the register_globals directive, EVER, as it's taboo and people will laugh at you for it.

And lastly, please consider storing your images as files and not in a database and instead store the file names/locations in the database, along with a title, a name, and whatever else related to the file. But that's another topic... as is tabs versus spaces! But I digress.

Have a careful read of the PHP manual on this section, it will tell you what to expect and ways to debug. The manual is good (tm) and even explains error codes and the like.

http://www.php.net/features.file-upload

daprezjer

Using print_r($_POST); , I find that the form is submitting everything but the <file> field. Take a look at http://spa.ward.american.edu/images.php. I have no idea why this is happening.

Also, concerning the register_globals directive, I'm guessing you mean to go w/ the new way of declaring w/ $_post['item'] instead of $item, like PHP suggests. I was just copying and pasting what the tuts on this and other forums suggested when I used $item.

philipolson

Oops I forgot one critical piece of information... 😉 For the file information you want to use $FILES so print_r($FILES); to see all file information and use accordingly.

Also be sure to never write $_post again as all variables are case sensitive, it looks funny and I can't help but comment on it. 🙂

daprezjer

Thanks so much. That did it. I had global variables turned off (which is why the examples that used them didn't work for me), and I didn't know about the FILES superglobal, which is why it wasn't working for me otherwise when I tried to use POST.

Thanks again,
Jeremy