473,406 Members | 2,293 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Script to upload images and add to database?

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
6 10935
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
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
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
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: mandr | last post by:
Bonjour , j'ai un petit pb sur mon script suivant : <?php // Ouverture de la session session_start();
4
by: NohaKhalifa | last post by:
Dear All; I'm developing a web site and i need to make adminisration for this site it's a site for Real Estates . But I don't need the administration to be online .. I want them to fill data...
0
by: SEMIH DEMIR | last post by:
Sitelerden birinde verilen yabancı kaynakli bir scriptti duzenledim yanlız birseyin içinden bir turlu cıkamadım işin aslı ilk defa persistin upload componentini kullanacam yanlız suanki haliyle...
9
by: 8anos | last post by:
Hello, I am new at the community and newbie at programming :) As you may know rapidshare provides a perl script for linux, to upload files at their servers. You can find the original scripts at...
7
tolkienarda
by: tolkienarda | last post by:
hi all I am using a php script to try to upload images to my database. i know i am connecting to my database because the image title is being wirtten to the database. but the image isn't example:...
3
tolkienarda
by: tolkienarda | last post by:
hi all i have a problem i have a script that i got working exactly the way i wanted it. and then i tried to intrigate it into the site and it totaly stopped working. below is the original code ...
1
by: kksandeep | last post by:
i am using this three files to uplod file. i got this file from net but i think these have some error. i am new to this field plz help the script i found is some helpful but not too that i need ...
5
by: camphor | last post by:
hi, I have found an upload script in hotscripts and have implemented it into the website, I followed the installation steps to 'give write permissions to php on the upload folder (which is...
3
by: aRTx | last post by:
I have try a couple of time but does not work for me My files everytime are sortet by NAME. I want to Sort my files by Date-desc. Can anyone help me to do it? The Script <? /* ORIGJINALI
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.