紧急求救mSSQL+PHP的问题 关注此贴:http://www.csdn.net/Expert/TopicView1.asp?id=1086705那个代码本来就是为你写的,想不到我先碰到问题了,呵呵。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 //$contents就是从数据库读出的字符串//-----------读取$filename = "F:/mm/M23406.jpg";$fd = fopen ($filename, "r");$contents = fread ($fd, filesize ($filename));fclose ($fd);//将$contents存入数据库中即可//----------输出//从数据库读出数据赋给$contents$filename = "aaa1.jpg";$fd = fopen ($filename, "w");fwrite($fd,$contents);fclose ($fd) 如果对处理时间要求不是很高,插入数据前可以进行base64编码,出来后再解码可以防止很多字符变换得错误发生。 可以把文件另外copy到硬盘上,数据库里只放文件名和路径名 1、结构:CREATE TABLE [dbo].[test] ( [id] [int] IDENTITY (1, 1) NOT NULL , [filename] [varchar] (50) NULL , [picture] [text] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO2、代码:<?php$filename = "test.jpg";$fp = fopen($filename,"rb");//$picture = fread($fp,filesize($filename));while(!feof($fp)){ $picture.=fread($fp,1024);}$picture = base64_encode($picture);fclose($fp);$conn = mssql_connect("localhost","sa","");@mssql_select_db("test",$conn);// 这段为插入到MSSQL数据库$query = "INSERT INTO test (filename,picture) VALUES ('$filename','$picture')";$result = mssql_query($query);$query="select @@IDENTITY as id";$result = mssql_query($query);$id = @mssql_result($result,0,"id");// 以下为读取内容$query = "SELECT * FROM test WHERE id='$id'";$result = mssql_query($query);$row = mssql_fetch_array($result);$data = base64_decode($row[picture]);header("Content-type: image/jpeg");echo $data; VPN访问异地服务器的速度是否比直接外网访问要快些? 还是乱码问题 php 文件下载 跳转 ! (这里能发帖吗?)想找一个类似天猫的php开源系统,界面和用户体验都做得比较好的有那些?谢谢! PHP+MYSQL的疑难问题请教高手,谢谢 菜鸟问题:显示问题 如何去读一个动态网页? 帮我看看这句我哪写错了?我看符号都晕乐 有没有WEB邮件系统的PHP源代码 php网页可以直接向一个端口发送json数据吗 高手请进!100分在线等! php在函数递归中出现的问题(是php本身的问题还是...)
$filename = "F:/mm/M23406.jpg";
$fd = fopen ($filename, "r");
$contents = fread ($fd, filesize ($filename));
fclose ($fd);
//将$contents存入数据库中即可
//----------输出
//从数据库读出数据赋给$contents
$filename = "aaa1.jpg";
$fd = fopen ($filename, "w");
fwrite($fd,$contents);
fclose ($fd)
可以防止很多字符变换得错误发生。
CREATE TABLE [dbo].[test] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[filename] [varchar] (50) NULL ,
[picture] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
2、代码:
<?php
$filename = "test.jpg";
$fp = fopen($filename,"rb");
//$picture = fread($fp,filesize($filename));
while(!feof($fp))
{
$picture.=fread($fp,1024);
}
$picture = base64_encode($picture);
fclose($fp);
$conn = mssql_connect("localhost","sa","");
@mssql_select_db("test",$conn);
// 这段为插入到MSSQL数据库
$query = "INSERT INTO test (filename,picture) VALUES ('$filename','$picture')";
$result = mssql_query($query);
$query="select @@IDENTITY as id";
$result = mssql_query($query);
$id = @mssql_result($result,0,"id");
// 以下为读取内容
$query = "SELECT * FROM test WHERE id='$id'";
$result = mssql_query($query);
$row = mssql_fetch_array($result);
$data = base64_decode($row[picture]);
header("Content-type: image/jpeg");
echo $data;