Re: Image and Mysql capabilities

In Oracle reports, this strategy is used (storing the path of the image file in the DB and storing the actual image file in the OS) to display images and for the same reason - performance of the DB. I think it is good approach. Lokesh Felipe Moreno wrote: > > Hi list Members, > > I have a real doubt regarding the storage of images in the My sql > database. Anyone know the alternatives to manipulate the insert and query > with images? Well, let me explain...I have a lot of images that correspond > to some "cars" names. I want, everytime a user select the respective car, to > "bring" the respective car image with the informations of that car. I was > reading about mysql, and found that it don't store images in the fields, but > we can create a BLOB field and store it in binary. But, I'm afraid of the > performance of the DB, cause sometimes you have thousands os images, and I > know that it will occupy a lot of space!...So, I thought about putting a > reference path to that image!...And print this path in a <img> tag...What do > you think about it? > > Thanks 4 your attention, > > Regards, > > Felipe Moreno > > -----Mensagem original----- > De: Mark Roedel [mailto:MarkRoedel@letu.edu] > Enviada em: segunda-feira, 14 de maio de 2001 10:51 > Para: Dragan Dinic; php-db@lists.php.net > Assunto: RE: [PHP-DB] php -> MSSQL > > > -----Original Message----- > > From: Dragan Dinic [mailto:dinic@knez.uis.kg.ac.yu] > > Sent: Monday, May 14, 2001 5:11 AM > > To: php-db@lists.php.net > > Subject: [PHP-DB] php -> MSSQL > > > > > > Is there any possible way to connect PHP (running on apache > > 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running > > on Windows 2000) ? > > Yep. > > As someone else has noted, the ODBC functions are one way. > > Another way, particularly if you prefer to talk to the database directly > rather than through a translation layer, is to install the FreeTDS > libraries (http://www.freetds.org/) on your Linux machine and then build > PHP with the --with-sybase configuration parameter. This will enable > the mssql_* functions. > > --- > Mark Roedel (roedelm@letu.edu) || "There cannot be a crisis next week. > Systems Programmer / WebMaster || My schedule is already full." > LeTourneau University || -- Henry Kissinger > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net