[Resolved] Copying an image to my server.

[benson]

Hello i'm a dutch boy so be warned for my english😃 .
I have a problem, i making an admin tool for my site owners.
But with that tool i want to upload an image from a Computer.
And then register the file name in a DB.
I have bits and pieces of code that must work but it didn't
below my code.

first my form
<form action="/b/plaver.php" method="post" name="upload">
<input type=file name=userfile size=30><br>
<input type=submit value=" Submit "></form>
then my php code
if ($userfile)
{ 
//The file to be uploaded
$tmpfile = "images/emps/".$userfile_name;
if(!file_exists($tmpfile))
{
move_uploaded_file($_FILES['myfile']['tmp_name'],  $tmp_name);
}
else
{ 
move_uploaded_file($_FILES['myfile']['tmp_name'],  $tmp_name);
}
//Update the database table for the new record
$db = mysql_connect($Host,$Gebruiker,$Passwoord);
$sql="UPDATE $tabelnaam SET plaatje1='$userfile_name WHERE plaatje1="*"";
mysql_query($sql, $db);
}
?>

[Natty_Dreadlock]

your form should begin like this:
<form enctype="multipart/form-data" action="/b/plaver.php"method="post">

Second: U should not mix the gloabal $userfile and $FILES . It's better to always access the uploaded file via $FILES["userfile"].

Third: What about this if-statement?? I don't see the difference in the else-section.

Your code might look like this:

<?php
if ($_FILES["userfile"])
{ 
//The file to be uploaded
$tmpfile = "images/emps/".$_FILES["userfile"]["name"];
if(!file_exists($tmpfile))
{
move_uploaded_file($_FILES['userfile']['tmp_name'],  $tmp_name);
}
else
{ 
// What's different here?? U have to chekc it out once more
move_uploaded_file($_FILES['userfile']['tmp_name'],  $tmp_name);
}
//Update the database table for the new record
$db = mysql_connect($Host,$Gebruiker,$Passwoord);
$sql="UPDATE $tabelnaam SET plaatje1='" . $_FILES["userfile"]["tmp_name"] ."';";
mysql_query($sql, $db);
}
?>

There can be still something wrong with your code cause I did not test ist, but I hope my code gave u a starting point
Hasta siempre

[benson]

Thanks,
I'm trying now.
I had edited some pieces of previous the code to see what will hapen.
Think that was a dumb option.
But i'm trying you're script now.

[benson]

I've tryed the script but it still gives a fault:

Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to access in /home/virtual/site185/fst/var/www/html/b/plaver.php on line 10

I didn't changed the script at al...

And if i retrieve the variable in the DB it shows "/home/virtual/site185/fst/tmp/phpfvc5It"
And the uloaded file name was "17121308263ebcff2d998ba.jpg"

I just don't get it....

[Natty_Dreadlock]

The difference in the original and the database name occurrs due to the usage of name and tmp_name: The query is $FILES["userfile"]["tmp_name"] and u wanna store the real name in the db, so use $FILES["userfile"]["name"].
and the move_uploaded_file part should look like this:move_uploaded_file($_FILES['userfile']['tmp_name'], $tmpfile);

[benson]

Hello i don't work !!!
I think it is al in the DB piece.
But when i check my images folder i can't see the pics that i've been uploading..
here is my code

if ($_FILES["userfile"])
{ 
//The file to be uploaded
$tmpfile = "images/emps/".$_FILES["userfile"]["name"];
if(!file_exists($tmpfile))
{
 move_uploaded_file($_FILES['userfile']['name'], $tmpfile);
}
//Update the database table for the new record
$db = mysql_connect($Host,$Gebruiker,$Passwoord);
$sql="UPDATE $tabelnaam SET plaatje1=$_FILES['userfile']['name']";
mysql_query($sql, $db);
}

I hope you can do something with it..

[benson]

Bad and Good news...:
The Good news is that the script stores the filename correctly...!!!
The Bad news is that the file wil not upload !

I hope you can help me

if ($_FILES["userfile"])
{ 
//The file to be uploaded
$tmpfile = "images/".$_FILES["userfile"]["name"];
if(!file_exists($tmpfile))
{
move_uploaded_file($_FILES['userfile']['name'], $tmpfile);
}
//Update the database table for the new record
$db = mysql_connect($Host,$Gebruiker,$Passwoord);
$sql="UPDATE $tabelnaam SET plaatje1='" . $_FILES["userfile"]["name"] ."'";
mysql_query($sql, $db);
}

[benson]

It finally worked
so for others who are with the same problem...here is the code..

if ($_FILES["userfile"])
{ 
//The file to be uploaded
$tmpfile = "images/".$_FILES["userfile"]["name"];
if(!file_exists($tmpfile))
{
move_uploaded_file($_FILES['userfile']['tmp_name'], $tmpfile);
}
//Update the database table for the new record
$db = mysql_connect($Host,$Gebruiker,$Passwoord);
$sql="UPDATE $tabelnaam SET plaatje1='" . $_FILES["userfile"]["name"] ."'";
mysql_query($sql, $db);
}

echo "<form action=\"$PHP_SELF\" method=\"post\" enctype=\"multipart/form-data\" >";
echo "<input type=file name=userfile size=30><br>";
echo "<input type=submit value=\" Submit \">";