php将图片存入access数据库的代码
<?php
$Access_Path="db.mdb";
$myDSN="Provider=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=$Access_Path; USER ID=$Access_User; PASSWORD=$Access_Pass;";
$conn=new COM("ADODB.Connection");
$rs=new COM("ADODB.RecordSet");
$conn->Open($myDSN);
$query="SELECT * FROM test WHERE id=1";
$rs->Open("$query",$conn,1,3);$fp=fopen("temp.jpg","r+");
while(!feof($fp)){
$file .= fread($fp, 4096);
}
fclose($fp);
$file=base64_encode($file);
if(@isset($_GET["get"])){
echo base64_decode($rs->fields["memo"]->Value);
}
else{
$rs->AddNew("memo",$file);
$rs->Update();
}
$conn->Close();
die();
?>
<?php
$Access_Path="db.mdb";
$myDSN="Provider=Microsoft.Jet.OLEDB.4.0; DATA SOURCE=$Access_Path; USER ID=$Access_User; PASSWORD=$Access_Pass;";
$conn=new COM("ADODB.Connection");
$rs=new COM("ADODB.RecordSet");
$conn->Open($myDSN);
$query="SELECT * FROM test WHERE id=1";
$rs->Open("$query",$conn,1,3);$fp=fopen("temp.jpg","r+");
while(!feof($fp)){
$file .= fread($fp, 4096);
}
fclose($fp);
$file=base64_encode($file);
if(@isset($_GET["get"])){
echo base64_decode($rs->fields["memo"]->Value);
}
else{
$rs->AddNew("memo",$file);
$rs->Update();
}
$conn->Close();
die();
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货