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

how to upload pictures and relate them to specific users

P: n/a
Please help me understand the big picture of allowing users to upload
pictures and keep them separate and tied to their record in the database.

I want the whole thing automated and I'm just trying to get my arms around
what all is entailed.

Each user will upload about 20 - 100 pictures and each will be related to a
different database record.

I see the process in general as this:
- when the user registers, a picture directory should be automatically
created
- user creates a record in the database using a form AND uploads a picture
for that record (how is that picture marked as related to that record?)

I'd appreciate any big picture advice AND links to code for any part of this
process.

Any security concerns? How do I handle those?

Many thanks!
Jul 17 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"NotGiven" <no****@nonegiven.net> wrote in message news:<bb*****************@bignews6.bellsouth.net>. ..
Please help me understand the big picture of allowing users to upload
pictures and keep them separate and tied to their record in the database.

I want the whole thing automated and I'm just trying to get my arms around
what all is entailed.

Each user will upload about 20 - 100 pictures and each will be related to a
different database record.

I see the process in general as this:
- when the user registers, a picture directory should be automatically
created
mkdir($username)
- user creates a record in the database using a form AND uploads a picture
for that record (how is that picture marked as related to that record?)
relate the picture however you like. you could for instance store the
path/filename in your db-record or - if you have a primary key - just
rename the picture to $primary_key.jpg.

best way in my opinion, cause it saves you having writeable
directories in your site, store the pictures in the db as well (look
at BLOB-fields).

let's suppose we uploaded the picture from a form field called 'image'
(uses mysql):

$image_string = addslashes(file_get_contents($_FILES['image']['tmp_name']));
//convert image into a string, addslashes() to mask special chars that
mess up the query

$type = exif_imagetype($_FILES['bild']['tmp_name']);
//find out the image type (i.e. jpg)

$query = mysql_query("INSERT INTO table SET type = '$typ', image =
'$image_string'");

now the db contains the image as a string. to get it out and display
it:

$ih = imagecreatefromstring($image_string);

switch ($type)
{
case 1: //gif
header("Content-type: image/gif");
imagegif($ih);
break;
case 2: //jpeg
header("Content-type: image/jpeg");
imagejpeg($ih);
break;
case 3: //png
header("Content-type: image/png");
imagepng($ih);
break;
}
this little script can be used in html-img-tags just like an image(img
src="this_script.php")
I'd appreciate any big picture advice AND links to code for any part of this
process.

Any security concerns? How do I handle those?
well, directorys where people can just automatically upload files

Many thanks!

Jul 17 '05 #2

P: n/a
thansk!

"chotiwallah" <ch*********@web.de> wrote in message
news:78*************************@posting.google.co m...
"NotGiven" <no****@nonegiven.net> wrote in message news:<bb*****************@bignews6.bellsouth.net>. ..
Please help me understand the big picture of allowing users to upload
pictures and keep them separate and tied to their record in the database.
I want the whole thing automated and I'm just trying to get my arms around what all is entailed.

Each user will upload about 20 - 100 pictures and each will be related to a different database record.

I see the process in general as this:
- when the user registers, a picture directory should be automatically
created


mkdir($username)
- user creates a record in the database using a form AND uploads a picture for that record (how is that picture marked as related to that record?)


relate the picture however you like. you could for instance store the
path/filename in your db-record or - if you have a primary key - just
rename the picture to $primary_key.jpg.

best way in my opinion, cause it saves you having writeable
directories in your site, store the pictures in the db as well (look
at BLOB-fields).

let's suppose we uploaded the picture from a form field called 'image'
(uses mysql):

$image_string =

addslashes(file_get_contents($_FILES['image']['tmp_name'])); //convert image into a string, addslashes() to mask special chars that
mess up the query

$type = exif_imagetype($_FILES['bild']['tmp_name']);
//find out the image type (i.e. jpg)

$query = mysql_query("INSERT INTO table SET type = '$typ', image =
'$image_string'");

now the db contains the image as a string. to get it out and display
it:

$ih = imagecreatefromstring($image_string);

switch ($type)
{
case 1: //gif
header("Content-type: image/gif");
imagegif($ih);
break;
case 2: //jpeg
header("Content-type: image/jpeg");
imagejpeg($ih);
break;
case 3: //png
header("Content-type: image/png");
imagepng($ih);
break;
}
this little script can be used in html-img-tags just like an image(img
src="this_script.php")
I'd appreciate any big picture advice AND links to code for any part of this process.

Any security concerns? How do I handle those?


well, directorys where people can just automatically upload files

Many thanks!

Jul 17 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.