Get image name into Database

[Kane2o02]

Hello

I have an upload form
<input type="file" name="img1" size="30"></p>

<P><input type="submit" name="submit" value="Upload File"></p>

and the upload works but how do u get the filename of the file being uploaded and put it into a mysql database?? ive tried this

<?PHP
if ("SUBMIT" == $submit) {
$query = mysql_query("INSERT INTO Gallery(ImgName) VALUES('$img1')") or die(mysql_error());
};
?>

but it doesnt work... 😕 lol
Any1?

Kane2oo2

[goa103]

Hi,

if ("SUBMIT" == $submit)

Your submit button's name is "submit", not "SUBMIT". I wonder where you guys found that thing. I saw it many times on the forum:

if ($_POST ['submit'] == "submit") is correct, the other is nonsense. Read the introduction to forms and variables section from the PHP manual. It's the first thing to do when you want to learn a new language, trust me.

and the upload works but how do u get the filename of the file being uploaded and put it into a mysql database??

There's a good article on PHPBuilder about it. To sum things up, don't upload the images to your db. Upload them on your web account as files. And create a table to link your DB/Application to the files. I use the id of the entry to identify the files. So the n-th pictures of my Pictures table represents the n-th.jpg file of my website. I also use a Categories table to sort my files.

JM

[Kane2o02]

Hello

There's a good article on PHPBuilder about it. To sum things up, don't upload the images to your db. Upload them on your web account as files. And create a table to link your DB/Application to the files

i think you will find the subject of my question is get image NAME into database!!

and i have searched the site but cannot find n e links on how to do this!

Thanks
Kane2oo2

[John_Canyon]

<?PHP 
if ("SUBMIT" == $submit) { 
$query = mysql_query("INSERT INTO Gallery(ImgName) VALUES('". $_FILES['img1']['name']
 ."')") or die(mysql_error()); 
}; 
?> 

You can access the File variables using the above method.
print_r($FILES);

will give you a list of what is there.

Cheers

[Kane2o02]

Help!!! lol

i still cant get it to work! 🙁

this is the code for the form
<form enctype="multipart/form-data" method="post" action="index.php?file=do_upload">

<p><strong>File to Upload:</strong><br></font>
<input type="file" name="img1" size="30"></p>

<P><input type="submit" name="submit" value="Upload File"></p>

and this is the code to insert the name into the database

<?PHP
if ("submit" == $submit) {
$query = mysql_query("INSERT INTO Gallery(ImgName) VALUES('". $_FILES['img1']['name']
."')") or die(mysql_error());
};
?>

This is the code for the do_upload page
<?

if ($_FILES['img1'] != "") {

copy($_FILES['img1']['tmp_name'], "uploads/".$_FILES['img1']['name']) 
	or die("Couldn't copy the file!");  

} else {

die("No input file specified");

}

?>
I know how to open the file from the name once its in the database ...it just wont go into the database!!!((tested by doing SELECT * FROM Gallery))

I just cant figure it out ((although i am a n00b lol))

Thanks
Kane2oo2

[goa103]

Hi,

<form enctype="multipart/form-data" method="post" action="index.php?file=do_upload">

You should use a text field for the file=do_upload:
<input type="text" name="file" value="do_upload">

if ("submit" == $submit) {

Use _POST to get the variables posted by the form.
A IF should always have a ELSE, if your condition is FALSE, then nothing happens!

Only upload the file is the form was posted.

JM

[Kane2o02]

hello

why do i need a text field for the file=do_upload???

cos this just puts a input box on the screen with do_upload on !!!

😕

Also the type of table which contains the filename should it be TEXT?
mysql> DESCRIBE gallery;
+---------+---------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+----------------+
| ID | int(11) | | PRI | NULL | auto_increment |
| ImgName | text | YES | | NULL | |
+---------+---------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

and could it be to do with that the filename in the upload text box is in the format "C:\folder\folder\image." for example??

[goa103]

Hi,

Sorry INPUT TYPE should be HIDDEN not TEXT. I just try to hide as much as I can from the user/visitor.

For your image path, use a TINYTEXT, TEXT is far too huge! You can use a VARCHAR too (fixed it to 256).

JM