Hi again, I guess one really good reason  for not storing images directly in
a db table is performance. When you store a blob in a table it affects the
whole database's performance. It slows it down, that's why the most common
method is to store the images in a dir on the webserver and store only the
path to the image in the databse field. That code I posted  in the previous
will allow uploading of an image to a directory on the server, store the
path to the image in the correct record for retrieval at a later point. It
also retrieves an image for a particular record.

HTH Joe :)


"Zara E Gonzalez" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Not sure if this is off topic for this list or not, but thought I would
try...
>
> I have a Linux server running Redhat 7.0, PHP 4.1.1, and freetds 0.53. My
Linux
> server connects to a Win2k server running MSSQL 2000.
>
> Everything works wonderfully, except, I have an image field in one of my
tables
> and I can't seem to find a way to pull it out without having PHP
completely
> freak out. (i.e. I get no error message at all just "page cannot be
displayed")
>
> So I'm wondering, can you pull image fields out with PHP?
>
> If so, I'm guessing my limitation is freetds. If not, is there any way to
pull
> an image out of a database using php? (i.e. store it in a different type
of
> field not image.)
>
> Any help is appreciated,
>
> Thanks,
>
> Zara



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to