To know the size of the images you could use a library like GD or something
like that.
You can also store one big image in your database and use the graphics
library to create a temporary image that will be send to the client with the
size / scale you want to send to the client. This way your 50k or 5000k
image will be used to create a small image ~5k that will be send to the
client.
Hope this helps
----- Original Message -----
From: "Nikos Gatsis" <nikos@xxxxxxx>
To: "PHP-mailist" <php-db@xxxxxxxxxxxxx>
Sent: Monday, February 16, 2004 2:23 PM
Subject: Re: - Resizeing Images stored in mysql db
> Thanx
> but, first I dont know the real size of the stored pictures and second I
> dont think that is a good idea to shrink a 50k photo.
>
> ----- Original Message -----
> From: "Frisley Velasquez" <frisleyv@xxxxxxxxxxxx>
> To: "Nikos Gatsis" <nikos@xxxxxxx>
> Sent: Monday, February 16, 2004 4:16 PM
> Subject: Re: - Resizeing Images stored in mysql db
>
>
> > Hi, the only thing you need to do, is to add a varible where you specify
> the
> > width and the height of the pics. then add the var in the query. This to
> be
> > parsed not just as a <img src=".."> but as <img src="..." width="..."
> > height="...">, so your images will be the width and height you want.
> >
> > Or if you would like dif. sizes, add a column in the table so you can
> enter
> > the width and height of each one, so you can call this ones(width and
> > height) in each case.
> >
> > ----- Original Message -----
> > From: "Nikos Gatsis" <nikos@xxxxxxx>
> > To: "PHP-mailist" <php-db@xxxxxxxxxxxxx>
> > Sent: Monday, February 16, 2004 6:56 AM
> > Subject: - Resizeing Images stored in mysql db
> >
> >
> > > Hello list
> > >
> > > I store images in a mysql table and use then in a web site.
> > >
> > > Is possible to change the size of these images;
> > >
> > >
> > > Following the code I'm allredy use.
> > >
> > > $query="SELECT photoxl FROM books WHERE books_id = '$books_id'";
> > > $result=mysql_db_query($database, $query, $conn) or Die
> > > ("...".mysql_error());
> > > list($photoxl)=mysql_fetch_row($result);
> > > $type = $photoxl_type;
> > > if (!empty($photoxl)) {
> > > header("Content-Type: {$type}");
> > > echo $photoxl;
> > > }
> > >
> > > Thank you in advance
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
