- 论坛徽章:
- 0
|
上传界面:
<html>;
<head>;
<title>;文件上传表单</title>;
</head>;
<body>;
<table>;
<form enctype='multipart/form-data' name='myform' action='submit.php'
method='post'>;
<INPUT TYPE = "hidden" NAME = "MAX_FILE_SIZE" VALUE ="1000000">;
<tr>;<td>;选择上传文件</td>;<td>;
<input name='myfile' type='file'>;</td>;</tr>;
<tr>;<td colspan='2'>;<input name='submit' value='上传'
type='submit'>;</td>;</tr>;
</table>;
</body>;
库为:user 表为:test 用户名为:test 并开放了所有权限 php.ini中mssql已打开
处理文件submit.php
<?php
$myfile=$_FILES['myfile']['name'];
$file_type=$_FILES['myfile']['type'];
$file_name=$_FILES['myfile']['tmp_name'];
$file_size=$_FILES['myfile']['size'];
//把文件内容读到字符串中
$fp=fopen($file_name, "rb" ;
if(!$fp) die("file open error" ;
$file_data = addslashes(fread($fp, filesize($file_name)));
fclose($fp);
unlink($file_name);
//文件格式,名字,大小
$dbconn=dbx_connect(DBX_MSSQL,'localhost','user','test','771212');
$sql="insert into test (data) values ('$file_data')";
$result=dbx_query($dbconn,$sql);
dbx_close($dbconn);
?>;
当我上传一个文件时,无法将文件数据存入test表中 |
|