Encountered ERROR

ddtpmyra

Anybody have ever encounter the error below and what's the meaing of it?This happens when I upload a file using the PHP on my SQL.

"Notice: Undefined index: approval1 in Vol3:/DM/add_file2.php on line 150"

Atli

This isn't technically and error. It's a notice.
The message really says it all.

Your code is trying to read an undefined array index on line 150 of your code, called "approval1".

I'm guessing, since this has something to do with file uploads, that this index is being read from the $_POST super-global, but the field in question has either not been posted, or was left out in your <form>.

What does line 150 of your code look like?

ddtpmyra

It pointed to my sql query

Expand|Select|Wrap|Line Numbers

         $query = "

            INSERT INTO fileStorage (

                FileName, FileMime, FileSize, FileData, Created, Description,Author, Requestor, DeadLineFeedback, category

            )

            VALUES (

                '{$name}', '{$mime}', {$size}, '{$data}', NOW(), '{$description}', UPPER('{$author}'), UPPER('{$requestor}'), '{$DateInput}','{$category}'

            )";

Atli

Are you sure?
The notice is complaining about an index named "approval1".

Where is that being used?

ddtpmyra

Hi Atli,

Just a follow up question on your code was posted on 'How to' section, how can I do multiple upload this time?

thanks,
DM

Atli

You upload multiple files just like you upload a single file, you just use more <input> fields.

For example, using this form:

Expand|Select|Wrap|Line Numbers

 
<form action="process.php" method="post" enctype="multipart/form-data">

  <input type="file" name="file1" /><br />

  <input type="file" name="file2" /><br />

  <input type="submit" />

</form>

The two files the would be uploaded could be found in the $_FILES array in your proccess.php page:

Expand|Select|Wrap|Line Numbers

 
<?php

$_FILES['file1']; // The first file would be here

$_FILES['file2']; // The second would be here.

?>

Is that what you are looking for?

ddtpmyra

I did this first adding of couse the additional input form for th user to browse, then I tried putting it on my variables like below but didn't work

:(

Expand|Select|Wrap|Line Numbers

  
 $name1 = mysql_real_escape_string($_FILES['file1']['name'], $dbLink);

 $mime1 = mysql_real_escape_string($_FILES['file1]['type'], $dbLink);

 $size1 = $_FILES[file1']['size'];

 $data1 = mysql_real_escape_string(file_get_contents($_FILES  ['file1']
 
 $name2 = mysql_real_escape_string($_FILES['file2']['name'], $dbLink);

 $mime2 = mysql_real_escape_string($_FILES['file2]['type'], $dbLink);

 $size2 = $_FILES['file2']['size'];

 $data2 = mysql_real_escape_string(file_get_contents($_FILES  ['file2']

['tmp_name']), $dbLink);

and the query

Expand|Select|Wrap|Line Numbers

 
$query = "INSERT INTO fileStorage (FileName1,FileMime1,FileSize1,FileData1,

    FileName2,FileMime2,FileSize2,FileData2)

            VALUES     (

                    '{$name1}','{$mime1}',{$size1},'{$data1}',

                    '{$name2}','{$mime2}',{$size2},'{$data2}'

                                )";

Atli

That's not a very good way to do this.
Your query would essentially require you to duplicate each column of the table for each additional file, which would cause all sorts of problems.

What you should be doing is add a new row for each file, not new columns to each row for each new file.

A multiple insert query should look like:

Expand|Select|Wrap|Line Numbers

 
INSERT INTO myTable (col1, col2, colN) VALUES

('value11', 'value12', 'value1N'),

('value21', 'value22', 'value2N'),

('valueN1', 'valueN2', 'valueNN');

Which you could use to add as many new rows as you like to your table without having to change the structure of it.

Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

re: Encountered ERROR

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about