[RESOLVED] Uploading file and posting its name to a mysql database?

eurotrashkid

Hi All,

I have an upload form that posts files (Images) to a certain folder on my site.

I'm wondering if it's possible to also post the file name to a MySQL database table.

Here's what I have:

FORM:

<form name="Pics" enctype="multipart/form-data" action="getfile.php" method="post"></form>
  <input type="hidden" name="MAX_FILE_SIZE" value="300000" />
<p class="ArGr16">Select the picture file: <input name="uploadedFile" type="file"></p>
<input name="addPics" type="submit" value="Upload Picture">
</form>

The getfile.php SCRIPT:

<?php

$uploaddir = '/Images/Pictures/';
$uploadfile = $uploaddir . basename($_FILES['uploadedFile']['name']);

echo '

';
if (move_uploaded_file($_FILES['uploadedFile']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "Possible file upload attack!\n";
}s

echo 'Here is some more debugging info:';

print_r($_FILES);

print "

";

?>

Any suggestions on how best to have the File Name also posted to MySQL?

Thanks for your help

bogu

Where u have this echo :

echo "File is valid, and was successfully uploaded.\n";

Just make your UPDATE or INSERT into DB with your file name ($uploadfile) ...

eurotrashkid

bogu wrote:
Where u have this echo :
echo "File is valid, and was successfully uploaded.\n";
Just make your UPDATE or INSERT into DB with your file name ($uploadfile) ...

Could you please make an example?

Thanks!

eurotrashkid

bogu wrote:
Where u have this echo :
echo "File is valid, and was successfully uploaded.\n";
Just make your UPDATE or INSERT into DB with your file name ($uploadfile) ...

Ok bogu, it worked quite fine.

Here's how it was solved, for anyone else who has same problem:

<?php
$uploaddir = './Images/';
$uploadfile = $uploaddir . basename($_FILES['uploadedFile']['name']);
echo '<pre>';
if (move_uploaded_file($_FILES['uploadedFile']['tmp_name'], $uploadfile)) {
   echo "The pictue was successfully uploaded.\n";
   $sql = "INSERT INTO Pictures (URL) VALUES ('$uploadfile')";
   $result = mysql_query($sql);
} else {

   echo "There was a problem uploading the file, please try again.\n";
}
print '<pre>';
?>

The $uploadfile POSTed into my DB is posted as following:

./Images/filename.ext

Now I need to change this into an URL before is posted, can anyone help?

I was thinking to add an hidden input field as text in the form and give it a default value; http://www.mysite.com/ and post it into the same db table as 'baseurl'.

Then combine the two fields 'baseurl and 'url' by using echo as the img src in the picture gallery page.

If anyone has any ideas, I'd be grateful.

Cheers!

eurotrashkid

Ok, here's how I solved it:

<?php
$uploaddir = './Images/Picture_gallery/';
$uploadfile = $uploaddir . basename($_FILES['uploadedFile']['name']);
$uploadfilename = basename($_FILES['uploadedFile']['name']);
echo '<pre>';
if (move_uploaded_file($_FILES['uploadedFile']['tmp_name'], $uploadfile)) {
   echo "The pictue was successfully uploaded.\n";
   $sql = "INSERT INTO Pictures (URL) VALUES ('$uploadfilename')";
   $result = mysql_query($sql);
} else {

   echo "There was a problem uploading the file, please try again.\n";
}
print '<pre>';
?>

bogu

U dont need to keep all the url in database, u know where the files are store, so u just need to know the file name and when u extract them, u add the url to the files ...