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.

[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.

[jmev7]

Pedro <hexkid@hotpop.com> wrote in message news:<bnpg41$148ntn$2@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

[Clubberboy]

Op 3 Nov 2003 07:17:38 -0800 schreef [email]jmev7@yahoo.com[/email] (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
[url]http://www.techtronix.be/demos/im/index2.php[/url]

username: demo
password: demo

[Bob]

[email]jmev7@yahoo.com[/email] (jmev7) wrote in message news:<c72a6456.0311030717.2e8cd97a@posting.google. com>...

> Pedro <hexkid@hotpop.com> wrote in message news:<bnpg41$148ntn$2@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:
[url]http://haifa.us[/url]

[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:
> [url]http://haifa.us[/url]

[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....
}




[email]jmev7@yahoo.com[/email] (jmev7) wrote in message news:<c72a6456.0311121156.2bd853b9@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:
> > [url]http://haifa.us[/url]