Store the image url in the database not just the file in folder

[superchrisc]

Hey, i need help storing an image in my database via the URL(image location) at the moment my php code is storing the image in a folder on the directory called upload. here is the code:

<?php

// Where the file is going to be placed

$target_path = "upload

/";

 

/* Add the original filename to our target path. 

Result is "uploads/filename.extension" */

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

$target_path = "upload/";

 

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

 

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

    echo "The file ".  basename $_FILES['uploadedfile']['name']).

    " has been uploaded";

} else{

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

}

?>

 

Click <a href="products.php">HERE</a> to go back to form

 

 

if someone could help me i'd be very grateful

[superchrisc]

if anyone needs to see any more of the code thats no problem, and if anyone could solve my problem i'd be very grateful

[PFMaBiSmAd]

You didn't exactly state what problem you were having when you attempted to do this. All you posted was a statement of what you wanted to do.

[superchrisc]

Sorry, my problem is. i have a form with four inputs,

 

• product  name
  
• product price
  
• product  image
  
• product description
  

 

at the moment, my code will upload the image to the upload folder, but i need help or a point in the direction of how i'd store that information including the image URL in my db table.

 

Hope this is a little clearer sorry for the previous post

[PFMaBiSmAd]

http://w3schools.com/php/php_mysql_insert.asp

[superchrisc]

i'll try that thanks very much, will that insert the image url to? within a varchar record type

[superchrisc]

another small problem, it won't insert or upload the image, was wondering if someone could hint or tell me where am going wrong with this code

<?php 
// Where the file is going to be placed 
$target_path = "upload
/";

/* Add the original filename to our target path.  
Result is "uploads/filename.extension" */
$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 
$target_path = "upload/";

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

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}
?>
<?php


$sql="INSERT INTO products (ProductName, ProductDescription, ChooseImage)
VALUES
('$_POST[produtname]','$_POST[produtdes]','$_POST[uploadedfile]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";


?>

Click <a href="products.php">HERE</a> to go back to form

[superchrisc]

the form code is

<form enctype=”multipart/form-data” action=”uploader.php” method=”post”>
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
ProductName: <input type="text" name="productname" />
ProductDescription: <input type="text" name="productdes"/>
ChooseImage: <input name="uploadedfile" type="file" /><br />
<input type="submit" value="Submit" />
</form>

[litebearer]

As a start...

 

in your form the field names have a 'c'

ie productdname

whereas in your process (query) there is NO 'c'

ie $_POST[produtname]