PHP + MSSQL [英] PHP+MSSQL

查看:83
本文介绍了PHP + MSSQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好frenz


最近我尝试使用MSSQL和PHP,当PHP尝试使用''image''读取MSSQL字段时出现问题数据类型,

header(" Content-type:image / jpeg"); //充当jpg文件到浏览器


我尝试使用普通工作文件将BLOB存储为MSSQL中的文件类型

...但仍然没有工作。是因为MSSQL中的图像数据类型不能被PHP识别吗?

任何人都可以给出提示..提前感谢你。

Hi frenz

Lately I try to use MSSQL and PHP , the problem arise when PHP try to
read MSSQL field with ''image'' data type,

header("Content-type: image/jpeg"); // act as a jpg file to browser

I try to used normal working file that store BLOB as file type in MSSQL
...but still not working. Is it because the image data type in MSSQL can
not be recognise by PHP?
Any one can give the hint.. thanks u in advance.

推荐答案

如果我理解正确,你将图像本身放入数据库?

为什么?

更好的是将链接放在数据库中并将图像本身放在地图中

链接变得更好。


" badz" < BA **** @ gmail.com> schreef in bericht

news:11 ********************* @ z14g2000cwz.googlegro ups.com ...
If I understand you correctly, you put the image itself into the database?
Why ?
better is to put the link in the database and the image itself in the map in
the link is mutch better.

"badz" <ba****@gmail.com> schreef in bericht
news:11*********************@z14g2000cwz.googlegro ups.com...
嗨frenz

最近我尝试使用MSSQL和PHP,当PHP尝试用''image''数据类型读取MSSQL字段时出现问题,

header(" Content-type:image / jpeg"); //充当jpg文件到浏览器

我尝试使用正常工作文件将BLOB存储为MSSQL中的文件类型
..但仍然无法正常工作。是因为PHP中的图像数据类型无法被PHP识别?
任何人都可以给出提示..提前感谢你。
Hi frenz

Lately I try to use MSSQL and PHP , the problem arise when PHP try to
read MSSQL field with ''image'' data type,

header("Content-type: image/jpeg"); // act as a jpg file to browser

I try to used normal working file that store BLOB as file type in MSSQL
..but still not working. Is it because the image data type in MSSQL can
not be recognise by PHP?
Any one can give the hint.. thanks u in advance.


< br>

2004年11月29日星期一00:24:24 +0100,Polaris

< as ********* @ hotmail.com>写道:


停止发布帖子。
On Mon, 29 Nov 2004 00:24:24 +0100, "Polaris"
<as*********@hotmail.com> wrote:

Stop top posting.
如果我理解正确,你将图像本身放入数据库?
为什么?
更好的是将链接放在数据库中并将图像本身放在地图中,链接变得更好。


如果你说把图像放在文件系统而不是

数据库中,那你就错过了使用数据库的方法。


" badz" < BA **** @ gmail.com> schreef in bericht
新闻:11 ********************* @ z14g2000cwz.googlegr oups.com ...
If I understand you correctly, you put the image itself into the database?
Why ?
better is to put the link in the database and the image itself in the map in
the link is mutch better.
If you''re saying put the image on a filesystem instead of in a
database, then you''re missing rhe point of using a database.


"badz" <ba****@gmail.com> schreef in bericht
news:11*********************@z14g2000cwz.googlegr oups.com...
你好frenz

最近我尝试使用MSSQL和PHP,当PHP尝试用''image''数据类型读取MSSQL字段时出现问题,

标题(Content-type:image / jpeg); //充当jpg文件到浏览器

我尝试使用正常工作文件将BLOB存储为MSSQL中的文件类型
..但仍然无法正常工作。是因为PHP中的图像数据类型无法被PHP识别?
任何人都可以给出提示..提前感谢你。
Hi frenz

Lately I try to use MSSQL and PHP , the problem arise when PHP try to
read MSSQL field with ''image'' data type,

header("Content-type: image/jpeg"); // act as a jpg file to browser

I try to used normal working file that store BLOB as file type in MSSQL
..but still not working. Is it because the image data type in MSSQL can
not be recognise by PHP?
Any one can give the hint.. thanks u in advance.


< br $> b $ b -

gburnore @databasix dot com

-------------------- -------------------------------------------------- -----

你看起来如何取决于你去哪里。

-------------------- -------------------------------------------------- -----

Gary L. Burnore | Y?3oY3T3oY33Y?oY3T3oY3Y3T3oY3YY?3
DataBasix | Y?3oY3T3oY33Y?oY3T3oY3Y3T3oY3YY?3

黑色直升机维修Svcs部门|官方购买证明

====================================== ============ =========================

想要一个吗?得到一个! http://signup.databasix.com

=== =============================================== === ======================



--
gburnore@databasix dot com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | Y?3oY3T3oY33Y?oY3T3oY3Y3T3oY3YY?3
| Y?3oY3T3oY33Y?oY3T3oY3Y3T3oY3YY?3
DataBasix | Y?3oY3T3oY33Y?oY3T3oY3Y3T3oY3YY?3
| Y?3 3 4 1 4 2 Y3T3 6 9 0 6 9 Y?3
Black Helicopter Repair Svcs Division | Official Proof of Purchase
================================================== =========================
Want one? GET one! http://signup.databasix.com
================================================== =========================


我的意思是我试图从MSSQL数据库中提取图像其中

使用图片作为他们的数据类型而不是BLOB ..

是我无法拉图像的原因..

顺便说一下我使用的MSSQL表是查看表

what I means is I tried to pull the image from MSSQL database which
used image as their data type not BLOB..
is it the reason I can not pull the image..
by the way the MSSQL table that I used is "view table"


这篇关于PHP + MSSQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆