By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,780 Members | 1,126 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,780 IT Pros & Developers. It's quick & easy.

Script to upload images and add to database?

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.