inserting filename to mysql

[justinh]

Everytime someone uploads a file, I need a record to be stored in the table tbl_files

 

 

<?php
session_start();
include("connect.php");



$target_path = "testing/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)){

$userid = $_SESSION['userid'];
$filename = basename($_FILES['uploadedfile']['name']);

$mysql_query("INSERT INTO tbl_files (id,filename,userid) VALUES('','$filename','$userid')") or die(mysql_error());






echo "The file ". basename($_FILES['uploadedfile']['name'])." has been uploaded";
echo "<meta http-equiv=\"Refresh\" content=\"2; url=index.php\">";

} else {
echo "There was an error uploading the file, please try again!";

}

?>

 

This gives me

 

Fatal error: Function name must be a string in /homepages/29/d119570661/htdocs/wmptest.com/stbs/upload.php on line 16

 

I think it's talking about the $filename variable, but it echo's as a string fine. Not sure what the problem is. =/

[premiso]

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']);

 

I think that should be:

$target_path = $target_path . basename( $_FILES['uploadedfile']['tmp_name']);

[justinh]

i did what you suggested, but the error still comes up

 

Fatal error: Function name must be a string in /homepages/29/d119570661/htdocs/wmptest.com/stbs/upload.php on line 16

[premiso]

Scratch that part about the tmp_name, it should be just name.

 

Kindly point out what you see as line 16, with how the code is pasted it is hard to tell. Thanks.

[justinh]

$mysql_query("INSERT INTO tbl_files (id,filename,userid) VALUES('','$filename','$userid')") or die(mysql_error());

[justinh]

oh duh!!! i think its the $ at the begining of mysql_query

[DarkWater]

Yeah, it's the $ sign.  Take that off.