temp image name

[Kane2o02]

Hello
I have managed to get the filename into the database now. But instead of being the uploaded filename its the temporary filename.

This is my code:

<form name="form1" method="post" action="" enctype="multipart/form-data">
<input type="file" name="imagefile">

<input type="submit" name="Submit" value="Submit">
<?
if(isset( $Submit ))
{
//If the Submitbutton was pressed do:

if ($FILES['imagefile']['type'] == "image/gif"){
copy ($FILES['imagefile']['tmp_name'], "files/".$FILES['imagefile']['name'])

or die ("Could not copy");
echo "";

echo "Name: ".$FILES['imagefile']['name']."";

echo "Size: ".$FILES['imagefile']['size']."";

echo "Type: ".$FILES['imagefile']['type']."";

echo "Copy Done....";

}
else {
echo "";
echo "Could Not Copy, Wrong Filetype (".$_FILES['imagefile']['name'].")";
}
}
?> </form>
<?php

mysql_connect (localhost);

mysql_select_db (Gallery);

mysql_query ("INSERT INTO gallery (ImgName)
VALUES ('$imagefile')
");
?>

(sorry for the long post)
Thanks
Kane2oo2

[daphreeek]

try changing this:
mysql_query ("INSERT INTO gallery (ImgName) VALUES ('$imagefile') ");

to this:
mysql_query ("INSERT INTO gallery (ImgName) VALUES ('files/'.$_FILES['imagefile']['name'])");

Hope that helps
- Matt

[Kane2o02]

Hello i changed the line and it now reads:
<?php

mysql_connect (localhost);

mysql_select_db (Gallery);

mysql_query ("INSERT INTO gallery (ImgName) VALUES ('files/'.$_FILES['imagefile']['name'])");
?>

but now i get an error when the page loads:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in c:\apache\htdocs\up.php on line 40

(line 40 is the line i changed)

Any ideas?

Thanks
Kane2oo2

[stolzyboy]

the name of the file can simple be found, if you have your text file browse field is named filetoupload, on the next page, you can get it information like

$filetoupload // will be the temp name of file
$filetoupload_name // actual name of file
$filetoupload_size // size of file
$filetoupload_type // mime type of file

good luck

[Kane2o02]

Thanks for that

BUT!!

i managed to get it working...and everytime a picture is uploaded 2 rows are created in the mysql database. One has the filename but the other is empty!!

code to insert name into database:
<?php

mysql_connect (localhost);

mysql_select_db (Gallery);

mysql_query ("INSERT INTO gallery (ImgName)
VALUES ('$imagefile_name')
");
?>

hmmmm!!

Any ideas???

Thanks alot people

Kane2oo2

[daphreeek]

yeh - sorry bout my last post - i meant this:

mysql_query ("INSERT INTO gallery (ImgName) VALUES ('files/" . $_FILES['imagefile']['name'] . "'"));

oops 🙂 that'll teach me not to check my posts!

anyways - you got it working.

for your repeat problem - check that you haven't got the query in a loop or function called more than once. I'm sure you don't but it cant hurt to double check.

try making a new php page and running just the code below (set the $ImgName variable to whatever first at the top of the script). If that works then it must be something else in your code.

sorry - thats all I can think of unless you maybe hit the submit twice (but that shouldn't make a blank entry)

• Matt