Insert to database gives syntax error

Question

I would appreciate if anyone could tell me why Im getting a syntax error with this code:

if(isset($_POST['submit']))
                                    {   
$dbcon = mysqli_connect("localhost","user1","test1","tutorial");



$stored_file = $_FILES["file"]["name"];

$query="INSERT INTO store (filname, uppladdare, titel) VALUES


**Line 136->**('$_POST[**file**]$stored_file','$_POST[uppladdare]','$_POST[titel]')";
    if(!mysqli_query($dbcon ,$query));
                                        }

Notice: Undefined index: file in/Applications/XAMPP/xamppfiles/htdocs/projekt webb/laddaupp.php on line 136

The function works fine and Im storing all the data that I want. But Im still getting an error. I can always "fix" this by using reporting_error. But I prefer to learn by my mistakes.

/thanks

EDIT: The stars are not part of the coding. Just to show where the error occurs!

The final result:

$query="INSERT INTO store (filname, uppladdare, titel) VALUES ('$stored_file','$_POST[uppladdare]','$_POST[titel]')";

Thanks for the answers pals!:)

`('$_POST[**file**]$stored_file'` WTF #2 - Post actual code. — Funk Forty Niner, Feb 17 '14 at 18:44
`echo '
'.print_r($_FILES, true).'
';` will assist with debugging — MonkeyZeus, Feb 17 '14 at 18:45
You'll also want to [`read this`](http://stackoverflow.com/q/60174/) — Funk Forty Niner, Feb 17 '14 at 18:46
*"EDIT: The stars are not part of the coding. Just to show where the error occurs!"* - Just... **don't** - Make notes in your question, we can read. ;-) — Funk Forty Niner, Feb 17 '14 at 18:47

score 0 · Accepted Answer · answered Feb 17 '14 at 18:47

0

I think you can use variable$stored_file Where you just stored your filename

$query="INSERT INTO store (filname, uppladdare, titel) 
VALUES ('$stored_file','$_POST[uppladdare]','$_POST[titel]')";

There is no $_POST['file']$stored_file in your $_POST As the error says there is no index for $_POST['file']

answered Feb 17 '14 at 18:47

Fabio

23,183
12
55
64

You welcome dude, if you feel the answer was correct don't forget to accept it so you can also help people in the future with similar problems. – Fabio Feb 17 '14 at 18:52
Yeh, just have to wait another 3 minutes;) – Winterwind Feb 17 '14 at 18:54

Insert to database gives syntax error

1 Answers1