php如何在mysql中存储图片 一定要存图片入库吗?可不可以试试存图片的名字入库而已呢!或者名字的一些特征,如1,2,3,4,····读数据后形成图片的名字1.gif 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <?php// 作者:phpteam// create table test (// id int(11) not null 自动增加// filename varchar(50) not null,// picture text or blob// )$filename = "test.jpg";$fp = fopen($filename,"rb");$picture = fread($fp,filesize($filename));$picture = base64_encode($picture);fclose($fp);// MYSQL的例子$conn=mysql_connect("localhost","root","");@mysql_select_db("test",$conn);$query="insert into test (filename,picture) values ('$filename','$picture')";$result=mysql_query($query);$id=mysql_insert_id();$query="select * from test where id='$id'";$result=mysql_query($query);$row=mysql_fetch_array($result);// 通过ODBC操作的例子$conn = odbc_connect("test","test","test");$query = "INSERT INTO test (filename,picture) VALUES ('$filename','$picture')";$result = odbc_exec($conn, $query);$query="select @@IDENTITY as id";$result = odbc_exec($conn, $query);$id = @odbc_result($result, "id");// 这段为读取内容$query = "SELECT picture FROM test WHERE id='$id'";$result = odbc_exec($conn, $query);$picture = odbc_result($result, "picture");// 通过MSSQL操作的例子$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]);// 以下为输出到文件//$fp = fopen($newfile,"wb");//fwrite($fp,$data);//fclose($fp);header("Content-type: image/jpeg");echo $data;?> 有从mysql中将图片直接读出来的例子程序吗? 在精华区里有一文。值得一看,不过是英文的。还有一点小错误,下面这句$mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize));中的“r”改成"rb" 救急呀。。。大家有没有用过ZipArchive这个类 网上支付,选择哪家? PHP的得分终于超过了灌水区 panachart如何支持中文啊? 请问这是什么意思? 有关pdf打印的错误,请问如何解决? 对文件进行操作的问题 在做一个网站文件管理器时,对于服务器上的目录或文件的根限怎么设置? 刚刚装了php4.3.3,运行程序老是出现warning 和 notice discuz声明类难道还有另类的方法吗 在线等待快啊! Sql的一次调用多种不同的键值的方法怎么做??帮个忙。
// 作者:phpteam
// create table test (
// id int(11) not null 自动增加
// filename varchar(50) not null,
// picture text or blob
// )$filename = "test.jpg";
$fp = fopen($filename,"rb");
$picture = fread($fp,filesize($filename));
$picture = base64_encode($picture);
fclose($fp);// MYSQL的例子
$conn=mysql_connect("localhost","root","");
@mysql_select_db("test",$conn);
$query="insert into test (filename,picture) values ('$filename','$picture')";
$result=mysql_query($query);
$id=mysql_insert_id();
$query="select * from test where id='$id'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
// 通过ODBC操作的例子
$conn = odbc_connect("test","test","test");
$query = "INSERT INTO test (filename,picture) VALUES ('$filename','$picture')";
$result = odbc_exec($conn, $query);
$query="select @@IDENTITY as id";
$result = odbc_exec($conn, $query);
$id = @odbc_result($result, "id");
// 这段为读取内容
$query = "SELECT picture FROM test WHERE id='$id'";
$result = odbc_exec($conn, $query);
$picture = odbc_result($result, "picture");// 通过MSSQL操作的例子
$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]);// 以下为输出到文件
//$fp = fopen($newfile,"wb");
//fwrite($fp,$data);
//fclose($fp);header("Content-type: image/jpeg");
echo $data;
?>
$mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize));
中的“r”改成"rb"