Simple Upload Issue

pseudocool

I am very new to php and am trying to create a simple application that uploads a PDF file to a database. I have one field for the Volume Number and on file field for the PDF to be uploaded. My issue is i can't get the PDF to upload or insert the name of the pdf (eg volume1.pdf) into the data base.

Here is what i have, please go easy on me this is my first round at php:

<?php
if(isset($_POST['submit'])){
$vol_num = $_POST['vol_num'];
$pdf = $_FILES['pdf']['name'];
		$path = '../pdf/'.$_FILES['pdf']['name'];
		move_uploaded_file($_FILES["pdf"]["tmp_name"], $path);
        mysql_query("INSERT INTO volumes set vol_num='$vol_num', vol_link='$pdf'") or die (mysql_error());
		echo "<script>location.href='add_volume.php'</script>";
}
?>

what am i doing wrong here?

Thanks in advance

Derokorian

Are you sure you have write permissions to that folder?

Also make this the top of your scirpt to get a better idea whats going on

<?php
error_reporting(E_ALL);
if(isset(... //fill in the rest :P

bradgrafelman

You should also be doing some error-checking when processing uploaded files. For example, you should first check to see if the value of $_FILES['pdf']['error'] is equal to the constant UPLOAD_ERR_OK and, if not, handle whatever error code was returned instead.

See this manual page for more info on the upload error codes: [man]features.file-upload.errors[/man].

pseudocool

The only problem i am having with the script is that the Filename is not being placed in the database... in other words my table looks like this:

id | vol_num | vol_link
1 | 1 |

The Error i am receiving is this:
Undefined index: pdf in /home1/oregoner/public_html/add_volume.php on line 37

Derokorian

is the name of your file field PDF or pdf? I believe it will be case sensitive in when calling it in the $_FILES array.

pseudocool

this is the code for my form

<form action="add_volume.php"  method="post">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
  <tr> 
    <td width="50%" height="30" valign="middle" class="right">Volume Number<span class="red">* : </span></td>
    <td width="50%"><input type="text" name="vol_num" /></td>
  </tr>
  <tr>
    <td height="30" valign="middle" class="right">Volume PDF<span class="red">*</span> :</td>
    <td><input type="file" name="pdf"  ></td>
  </tr>
  <tr>
    <td colspan="2" class="center"><input type="submit" name="submit"/></td>
    </tr>
</table>
</form>

pseudocool

I also had the php echo the $pdf variable and for some reason it is returning null....

Derokorian

I dunno know if it makes a difference by try $_FILES["pdf"]['name'] notice the change in quotes.

pseudocool

Nadda, I even tried changing the data types of the sql....

Derokorian

Next I would verify the following in php.ini:

;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;

; Whether to allow HTTP file uploads.
; http://php.net/file-uploads
file_uploads = On <-- make sure this is On!

; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
; http://php.net/upload-tmp-dir
upload_tmp_dir = "" <-- make sure you know this location and can read it


; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 2M  <-- Make sure this is set higher than your expected pdf size

pseudocool

Well, the file uploads just fine to the directory....The problem i am having now is that my INSERT statement isn't inserting the filename....

For example i want the name of the file i upload "volume1.pdf" to be inserted into the table under the "vol_link" column....

Derokorian

Oh I thought neither the upload or the query worked. My bad trying to solve a problem you dont have....

pseudocool

haha its ok I really appreciate it anyway...perhaps you have some suggestions on the new issue? I have been at it for 6 hours straight to no avail...perhaps i can export the SQL and PHP to a zip and send it your way if you can't think of anything off the top?

again, all help is extremely appreciated.

Derokorian

I'm actually stumped and here's why:

<?php
$pdf = $_FILES['pdf']['name']; 
$path = '../pdf/'.$_FILES['pdf']['name'];

How can the path be set correctly and yet the $pdf variable isn't? I'm totally confused on that, I'll think about it but hopefully someone else stumbles along and sees the problem.