Script to upload images and add to database?

jmev7

Is there a script that will allow upload of multiple images at once to
a FTP server, and simultaneously write that list to a MySQL table? I
need to allow users to do something like this.

Thanks.

Jul 17 '05 #1

Pedro

jmev7 wrote:

Is there a script that will allow upload of multiple images at once to
a FTP server, and simultaneously write that list to a MySQL table? I
need to allow users to do something like this.

I doubt it very much.
Probably the best approximation you'll be able to dig out
will upload the multiple files *sequentially*.

Apart from that, yes, I'm pretty sure there is.

--
I have a spam filter working.
To mail me include "urkxvq" (with or without the quotes)
in the subject line, or your mail will be ruthlessly discarded.

Jul 17 '05 #2

jmev7

Pedro <he****@hotpop.com> wrote in message news:<bn*************@ID-203069.news.uni-berlin.de>...

jmev7 wrote:

Is there a script that will allow upload of multiple images at once to
a FTP server, and simultaneously write that list to a MySQL table? I
need to allow users to do something like this.

I doubt it very much.
Probably the best approximation you'll be able to dig out
will upload the multiple files *sequentially*.

Apart from that, yes, I'm pretty sure there is.

Actually, sequentially makes sense. I don't mind limiting myself to,
say, 5 textboxes with "browse" buttons next to them. Then, the user
selects 1-5 images, clicks "UPLOAD" (or submit, or whatever), and the
upload begins, with the SQL statement to follow. I can figure out the
SQL statement (I think) better than I can the array to step through.

Any suggestions on code to lookup?

Thanks

Jul 17 '05 #3

Clubberboy

Op 3 Nov 2003 07:17:38 -0800 schreef jm***@yahoo.com (jmev7):

Actually, sequentially makes sense. I don't mind limiting myself to,
say, 5 textboxes with "browse" buttons next to them. Then, the user
selects 1-5 images, clicks "UPLOAD" (or submit, or whatever), and the
upload begins, with the SQL statement to follow. I can figure out the
SQL statement (I think) better than I can the array to step through.

I think this script is what your looking for
http://www.techtronix.be/demos/im/index2.php

username: demo
password: demo

Jul 17 '05 #4

Bob

jm***@yahoo.com (jmev7) wrote in message news:<c7**************************@posting.google. com>...

Pedro <he****@hotpop.com> wrote in message news:<bn*************@ID-203069.news.uni-berlin.de>...

jmev7 wrote:

Is there a script that will allow upload of multiple images at once to
a FTP server, and simultaneously write that list to a MySQL table? I
need to allow users to do something like this.

I doubt it very much.
Probably the best approximation you'll be able to dig out
will upload the multiple files *sequentially*.

Apart from that, yes, I'm pretty sure there is.

Actually, sequentially makes sense. I don't mind limiting myself to,
say, 5 textboxes with "browse" buttons next to them. Then, the user
selects 1-5 images, clicks "UPLOAD" (or submit, or whatever), and the
upload begins, with the SQL statement to follow. I can figure out the
SQL statement (I think) better than I can the array to step through.

Any suggestions on code to lookup?

Thanks

Hi, First are you sure you wanna to use FTP, I think the best way is
to use file upload build in in PHP or/and use GD2 wich is comes with
php latest versions
Here some exampe how to upload one photo :

if (is_uploaded_file($_FILES['photo']['tmp_name'])) {

$imtype=$_FILES["photo"]["type"];
$imsize=$_FILES["photo"]["size"];
$imname=$_FILES["photo"]["name"];
$imtemp=$_FILES['photo']['tmp_name'];

$im = add_image($imtype , $title, $description, $sub_cat)
or die("couldnt add photo");
move_uploaded_file($imtemp, "im1/$im.$extension");

where function add_image adding imaage to DB!
If you wanna to add multi. immages just use for()....
Check my web site:
http://haifa.us

Jul 17 '05 #5

jmev7

Hi, I think I follow this code, but as a newbie to PHP, not for sure.
Is this all I'll need, or do I need to write an "add_image()" function
to write to the database. If so, I'll have to stay up late figuring
out the first line :)

Thanks

Hi, First are you sure you wanna to use FTP, I think the best way is
to use file upload build in in PHP or/and use GD2 wich is comes with
php latest versions
Here some exampe how to upload one photo :

if (is_uploaded_file($_FILES['photo']['tmp_name'])) {

$imtype=$_FILES["photo"]["type"];
$imsize=$_FILES["photo"]["size"];
$imname=$_FILES["photo"]["name"];
$imtemp=$_FILES['photo']['tmp_name'];

$im = add_image($imtype , $title, $description, $sub_cat)
or die("couldnt add photo");
move_uploaded_file($imtemp, "im1/$im.$extension");

where function add_image adding imaage to DB!
If you wanna to add multi. immages just use for()....
Check my web site:
http://haifa.us

Jul 17 '05 #6

Bob

Hi
First:

if (is_uploaded_file($_FILES['photo']['tmp_name'])) {
This line checks if you already have this image!

Second: The pictures will be stored on your server,if that what you
need! You may store your photos in DB as blob!

this function will add file, name, ... to db:

function add_image($file, $title, $description, $uid, $jid, $pswd) {
$query="INSERT INTO t_images .......";
execution....
}


jm***@yahoo.com (jmev7) wrote in message news:<c7**************************@posting.google. com>...

Hi, I think I follow this code, but as a newbie to PHP, not for sure.
Is this all I'll need, or do I need to write an "add_image()" function
to write to the database. If so, I'll have to stay up late figuring
out the first line :)

Thanks

Hi, First are you sure you wanna to use FTP, I think the best way is
to use file upload build in in PHP or/and use GD2 wich is comes with
php latest versions
Here some exampe how to upload one photo :

if (is_uploaded_file($_FILES['photo']['tmp_name'])) {

$imtype=$_FILES["photo"]["type"];
$imsize=$_FILES["photo"]["size"];
$imname=$_FILES["photo"]["name"];
$imtemp=$_FILES['photo']['tmp_name'];

$im = add_image($imtype , $title, $description, $sub_cat)
or die("couldnt add photo");
move_uploaded_file($imtemp, "im1/$im.$extension");

where function add_image adding imaage to DB!
If you wanna to add multi. immages just use for()....
Check my web site:
http://haifa.us

Jul 17 '05 #7