报错为:
Warning: MS SQL message: 第 1 行: '唷' 附近有语法错误。 (severity 15) in D:\wwwroot\test\sqlserver.inc on line 39Warning: MS SQL: Query failed in D:\wwwroot\test\sqlserver.inc on line 39
Warning: MS SQL message: 第 1 行: '唷' 附近有语法错误。 (severity 15) in D:\wwwroot\test\sqlserver.inc on line 39Warning: MS SQL: Query failed in D:\wwwroot\test\sqlserver.inc on line 39
=>
$fpopen=fopen($myfile,"rb");另外存到数据库的时候最好用base64_encode()处理一下(用addslaches也可以,不过有些会有问题)。如:
$data = base64_encode($data);
$query="update zxx_jzgjbxx set xmpy=$data where zgh='$name'";
Warning: MS SQL message: 第 1 行: '/' 附近有语法错误。 (severity 15) in D:\wwwroot\test\sqlserver.inc on line 39Warning: MS SQL message: 以 'MAAAAAAAkAAAAAAAAAAAEAOEJJTQQKAAAAAAABAAA4QklNJxAAAAAAAAoAAQAAAAAAAAACOEJJTQP1AAAAAABIAC9mZgABAGxmZgAGAAAAAAABAC9mZgABAKGZmgAGAA' 开头的 标识符 太长。最大长度为 128。 (severity 15) in D:\wwwroot\test\sqlserver.inc on line 39
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);