You are here: Re: image into mysql and out of mysql « PHP SQL « IT news, forums, messages
Re: image into mysql and out of mysql

Posted by Andreas Edin on 10/25/05 21:50

Feudalac! wrote:

> Andreas Edin wrote:
>
> > Feudalac! wrote:
> >
> > > Andreas Edin wrote:
> > >
> > >
> >
> >
> >
> > Now you have sent all the information your browser need. But you
> > don't really have to send "Content-Disposition" and
> > "Content-Description" it works well without them.
> >
> > The next step is to send the file from the database. And that's easy
> > just "echo $data;" in this example.
> >
> > But if the browser doesn't know how to open the file by it's
> > content-type, it will automaticly open a download prompt.
> >
> > If you want more detailed description just say it.
> > Best regards Andreas Edin, Sweden
>
> but i must display some text and then the image, after that some more
> text and another image...
>
> the example above is very helpful but the main problem stil exists...
>
> I have a catalog with very small images (filesize no more that 2k) and
> want to store those images in a database. when the catalog is
> displayed - every image must be next to the corresponding type of
> product...

Just create two table's in your MySQL database. One with you images and
one with the meta information about the image. Decide witch one you are
going to use as primary listing. And for each itteration in the primary
table you do a sub query in the other table. And for each itteration
you create a new output to the webbrowser.


If you want more detailed description just say it.
Best regards Andreas Edin, Swede
--

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация