467,923 Members | 1,576 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

how to upload pictures and relate them to specific users

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
  • viewed: 2376
Share:
2 Replies
"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
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.

Similar topics

4 posts views Thread by Tihon | last post: by
2 posts views Thread by Ken | last post: by
3 posts views Thread by Kitt Langkilde | last post: by
7 posts views Thread by Shelly | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.