Database path store.

viajero5

Alright, how in the world can I do this:

uploadforms.php - A form where you simply input a title, choose a file to upload, add a comment for the file, and select a catagory for the file. All of this info is then passed onto upload.php

upload.php - this takes the info from the forms puts it in a database, I know how to get all the text into the database, but how can i store the file location of the file in the DB (the location of the file on the server)? I cannot seem to get this, and I have been at it for weeks....

bpat1434

1.) You have to use [man]move_uploaded_file/man to move the file to where you want.
2.) You have to define a path for the above function
3.) Just take the path above, and plug it in your INSERT statement for the database.

viajero5

so would it be something along the lines of this:

$filename = $file['tmp_name']
$path = move_uploaded_file($file['tmp_name'], 'images/' . $filename);

$sql = "insert into user_art
		  		(title, caption, path) values
				('$name', '$caption', '$path')";

bpat1434

Close, but not quite right:

 $filename = $file['tmp_name']
$path = 'images/';
if(!move_uploaded_file($file['tmp_name'], $path . $filename))
  die('Could not move the file'); // Good to have error checking.

$sql = "insert into user_art
                  (title, caption, path) values
                ('$name', '$caption', '$path')";

viajero5

<?

$title = $_FILES['title'];
$caption = $_FILES['caption'];
$filename = $file['tmp_name'];
$path = 'art/';
$store_path = $path . $filename;

if(!move_uploaded_file($file['tmp_name'], $path . $filename))
  die('Could not move the file'); // Good to have error checking.

$sql = "insert into user_art
                  (title, caption, path) values
                ('$title', '$caption', '$store_path')"; 
?>

telling me it cant movie it... hmm.

bpat1434

heh... use this line in place of the one like it you have:

if(!move_uploaded_file($_FILES['upload']['tmp_name'], $path . $filename))

Replace "upload" with whatever you named the input box:

<input type="file" name="upload">