你可以把所有的WORD、EXCEL等格式的文件放到数据库表的一个字段中,这样也可以做到你想要的,而且这样更安全。读取的程序:
保存程序:
if($upfile!=''){
$PSize = filesize($upfile);
$fp=fopen($upfile, "rb");
$mssqldoc = base64_encode(fread($fp, $PSize));
$upfiletype = strtolower(substr( strrchr( $upfile_name, "." ), 1 ) );
fclose($fp);
mssql_connect("localhost", "sa", "mypassword") or
die("Unable to connect to SQL server");
@mssql_select_db("oa") or die("Unable to select database");
$sql1="select * from document where do_code=$ar_slavecode";
$result=mssql_query($sql1);
if ($row=mssql_fetch_array($result))
{
$sql="update document set do_file= ('$mssqldoc'),do_timeadded=getdate(),do_type='$upfiletype' ";
$sql.=" where do_code=$ar_slavecode ";
}
else
{
$sql="insert into document (do_code,do_file,do_timeadded,do_type) values (";
$sql.="$ar_slavecode,('$mssqldoc'),getdate(),'$upfiletype')";
}
mssql_query($sql);
显示程序:
$sql="select do_file,do_type from document where do_code='$id'"; $result = mssql_query($sql);
$row = mssql_fetch_array($result);
$data=base64_decode($row[do_file]);
$type=strtoupper($row[do_type]);
if ($type=="DOC")
header("Content-type:application/msword");
else if($type=="XLS")
header("Content-type:application/x-msexcel");
else if($type=="PDF")
header("Content-type:application/pdf");
else
header("Content-Disposition:attachment");
echo $data;
保存程序:
if($upfile!=''){
$PSize = filesize($upfile);
$fp=fopen($upfile, "rb");
$mssqldoc = base64_encode(fread($fp, $PSize));
$upfiletype = strtolower(substr( strrchr( $upfile_name, "." ), 1 ) );
fclose($fp);
mssql_connect("localhost", "sa", "mypassword") or
die("Unable to connect to SQL server");
@mssql_select_db("oa") or die("Unable to select database");
$sql1="select * from document where do_code=$ar_slavecode";
$result=mssql_query($sql1);
if ($row=mssql_fetch_array($result))
{
$sql="update document set do_file= ('$mssqldoc'),do_timeadded=getdate(),do_type='$upfiletype' ";
$sql.=" where do_code=$ar_slavecode ";
}
else
{
$sql="insert into document (do_code,do_file,do_timeadded,do_type) values (";
$sql.="$ar_slavecode,('$mssqldoc'),getdate(),'$upfiletype')";
}
mssql_query($sql);
显示程序:
$sql="select do_file,do_type from document where do_code='$id'"; $result = mssql_query($sql);
$row = mssql_fetch_array($result);
$data=base64_decode($row[do_file]);
$type=strtoupper($row[do_type]);
if ($type=="DOC")
header("Content-type:application/msword");
else if($type=="XLS")
header("Content-type:application/x-msexcel");
else if($type=="PDF")
header("Content-type:application/pdf");
else
header("Content-Disposition:attachment");
echo $data;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货