inserting image locations

Okami

I have been trying for awhile to insert the loctation of images into my databasa with no luck. Here is my code:

<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Frick Family Alblumb</title>
</head>
<body>
<form enctype="multipart/form-data" method="post" action="FamilyAlblum.php">
Description: <input type = "text" name = "description" value = "<?php $POST['description']; ?>"><br>
File: <input type = "File" name = "picture" size = "25" value = "<?php $POST['picture']; ?>">
<input type="submit" name="submit" value="Upload">
</form>

 <?php
	include 'connectFA.php';

	$description = $_POST['description'];
	$picture = $_POST['picture'];

		if (!empty($description)) {

  		  $sql_insert = "insert into frickphotos values('$description','$picture_name')";
		  mysql_query($sql_insert,$conn) or die("Error3");

		   copy($picture, "c:/apache/Apache/htdocs/FamilyAlblum/image/$picture_name"); 

   		   echo "Description: $description<br>\n";
   		   echo "temp file: $picture<br>\n";
  		   echo "file name: $picture_name<br>\n";
  		   echo "file size: $picture_size<br>\n";
  		   echo "file type: $picture_type<br>\n";
  		   echo "<br>\n";
  		   echo "<img src=images/$picture_name><br>\n";
		}

</body>
</html>

Can anyone help?

cgraz

can you be more specific? Are you getting an error? is it just no inserting? inserting into the wrong fields? What's the problem?

Suggestions:

print $picture_name to make sure it has a value
print your query string to make sure it looks alright
add in the fields you're inserting into

INSERT INTO table (name, email) VALUES('joe', 'me@domain.com')

rather than

INSERT INTO table VALUES('joe', 'me@domain.com')

use mysql_error() when executing your query string.

maybe you wanna use $POST['picture_name'] (i think that's different than setting $picture = $POST['picture']). Echo out the variables first and if it's empty, then use $POST['picture_name'] or set $picture_name to equal $POST['picture_name']

Cgraz

Okami

It will insert whats in the description field into the database, but not what is the upload field.

cgraz

did you echo $picture_name to see if it has a value? Once you can get it to echo, then it should insert properly.

echo $picture_name;
echo $_FILES['picture']['name']

You should also be able to get the name using $_POST

I believe it's

$_POST['picture']['name']

Play around until you get it to echo. Once it works, then put it in your INSERT query and your insert will work properly.

Cgraz