Upload file and send to databese ? Pls Help

[Rootkit]

Hello.

first of all, i can not speak english very well. I hope, you understand me, what i mean. 🙂

My question;

When i selected a file (for example: image.jpg) from my pc and click to upload button;

This file send my ftp account, to the /images file and by the way, the file name insert into the database (for example: http://www.site.com/images/image.jpg)

What can i do ? Please help me 🙁

[jwlnewsome]

take a look at this
http://www.php-mysql-tutorial.com/php-mysql-upload.php

it may help but i dont really know what you are asking
hope this helps
john

[etully]

I think what you are asking for is this: You want the file to be saved in your images directory and you want the name of the file inserted into your data base.

First, assume that your HTML form looks like this:

<form method="POST" action="upload2.php" ENCTYPE="multipart/form-data">
<input TYPE="file" NAME="FILE1"><input type=submit value="Upload"></form>

Then the PHP code should look like this:

<?
// This saves the file on your web server:
@copy("$FILE1" , "/the/path/to/your/web/site/docs/images/$FILE1_name");

// Then connect to your database
mysql_connect("localhost","username","password");
@mysql_select_db("your_database") or die( "Unable to select database");

// Then insert this new filename into your table like this:
$query = "insert into uploaded_images (name) values ('$FILE1_name')";
$result = MYSQL_QUERY($query);

?>

When you read the filename out of the database, it's just going to be "image.jpg" so you're going to have to build the whole URL like this:

<img src="<? print "http://www.site.com/images/$filename"; ?>">

[Rootkit]

guys , very thanks for replies. But, etully this form action to upload2.php. what must be in upload2.php ? :queasy:

[etully]

This part goes in upload2.php:

<?
// This saves the file on your web server:
@copy("$FILE1" , "/the/path/to/your/web/site/docs/images/$FILE1_name");

// Then connect to your database
mysql_connect("localhost","username","password");
@mysql_select_db("your_database") or die( "Unable to select database");

// Then insert this new filename into your table like this:
$query = "insert into uploaded_images (name) values ('$FILE1_name')";
$result = MYSQL_QUERY($query);

?>

Of course, this code assumes that you have a table called "uploaded_images" with a field called "name". You will need to create that table before you can use my sample code.

[Rootkit]

thank you so much , i understand 🙂 thanks again.