Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

[PHP-DB] Image and Mysql capabilities From: Felipe Moreno (fmoreno <email protected>)
Date: 05/14/01

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 <email protected>]
Enviada em: segunda-feira, 14 de maio de 2001 10:51
Para: Dragan Dinic; php-db <email protected>
Assunto: RE: [PHP-DB] php -> MSSQL

> -----Original Message-----
> From: Dragan Dinic [mailto:dinic <email protected>]
> Sent: Monday, May 14, 2001 5:11 AM
> To: php-db <email protected>
> 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 <email protected>)  ||  "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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>