[PHP] Display a database image from MSSQL database
Hi... I need to display some images that exists inside one MSSQL server in a BLOB datatype field, but my code don't work... My code: And I access this page sending in the URL the text: .../showimage.php?codPessoa=xxx. I receive a strange code like Fh54757eFg554257eFrgtth547d54e7t8h54j87j85fd54ss7f.. Accessing this page by IE nothing happens but when a I try to access in Mozilla Firefox I got an error saying that the image cointain errors and cannot be displayed... If i try to show inside an img TAG in other page like the code display a X error img, like if the image don't exist, but the code keep returning the strange code, so I believe that this is the image in a "string format" and something makes with the conversion for a real image format don't work very well. Sorry my bad english... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fwd: [PHP] Display a database image from MSSQL database
Thankz the atention.
I try to cut out the stripslashes and it also not work, and yes, the
images are valid, i can use it in delphi apps with no errors.
={
2005/5/18, Richard Lynch <[EMAIL PROTECTED]>:
> On Wed, May 18, 2005 10:28 am, Alaor Barroso said:
> > Hi... I need to display some images that exists inside one MSSQL
> > server in a BLOB datatype field, but my code don't work...
> >
> > My code:
>
> ... contains NO error checking. That's bad.
>
> > > $arg = $_GET["codPessoa"];
> > mssql_connect("server", "web", "web");
> > $sql = "SELECT Foto FROM Foto WHERE CodPessoa=$arg";
> > $result = mssql_query($sql);
> > $data = mssql_result($result, 0, "Foto");
> > $data = stripslashes($data);
>
> Nooo!
>
> If you are calling stripslashes() on data coming out of your databsae, you
> have almost for sure really screwed up much earlier in the process, by
> having both Magic Quotes "on" and calling addslashes() (or
> mysql_real_escape_string) or something similar.
>
> You would only do stripslashes() here if you've hacked php.ini to use
> Magic Quotes on data coming *OUT* of the database, which is really quite
> rare to do -- You'd want that only on a site where, what?, you were
> shlepping a bunch of stuff out of one database and into another???
>
> > header("Content-type: image/gif");
> > echo $data;
> > exit;
> > ?>
> >
> > And I access this page sending in the URL the text:
> > .../showimage.php?codPessoa=xxx.
> >
> > I receive a strange code like
> > Fh54757eFg554257eFrgtth547d54e7t8h54j87j85fd54ss7f.. Accessing
> > this page by IE nothing happens but when a I try to access in Mozilla
> > Firefox I got an error saying that the image cointain errors and
> > cannot be displayed... If i try to show inside an img TAG in other
> > page like the code display a X error img,
> > like if the image don't exist, but the code keep returning the strange
> > code, so I believe that this is the image in a "string format" and
> > something makes with the conversion for a real image format don't work
> > very well.
>
> Your stripslashes() corrupted the image, assuming it was valid in the
> first place.
>
> --
> Like Music?
> http://l-i-e.com/artists.htm
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP + MSSQL Problem
Hello guyz, sorry my bad english, im brazilian and i'll try to write in english... I use actually PHP 5.02 with MySQL in my site, but now i have to access an external server that use MS SQL Server running at windows 2000 server edition, firtly i tried to connect and it fails, because i don't have activately properly MSSQL support in php.ini... I changed the php.ini and enabled the support for MSSQL and now i can connect without errors, BUT when make an query to an table the query return NO MATCHES, i have sure that the SQL line is correct (i already used it on(or in? i don't know the difference =P) other site - in other server - and it works AND i have sure that the SQL should return data because the WHERE point to an fiels value that exists... It looks like PHP can't communicate with MSSQL but it connect! Strange... I need help friends, waiting for replys, hugs. Sorry my bad english, cya. ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Merry Christmas ;o]
Merry Christmas and happy new year for all that is part of php community, god bless us. Peace! ___ Yahoo! Acesso Grátis - Instale o discador do Yahoo! agora. http://br.acesso.yahoo.com/ - Internet rápida e grátis -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
