<?php/**
*********************************************
参数设定
*********************************************
**/
//最大上传文件大小
$MAX_SIZE = 20000000;
//设置Mine类型
$FILE_MIMES = array('image/jpeg','image/jpg','image/gif','image/png','application/msword');
//设置允许上传的文件类型,按照格式添加
$FILE_POSTFIX = array('.zip','.jpg','.png','.gif','.wma','.rm','.wmv','.doc','.mpeg','.mp3','.avi');
//是否允许删除以上传的文件,允许:yes; 不允许:no;
$DELETE_ENABLE = 'yes';/**
*********************************************
变量设定
*********************************************
**/
$site_name = $_SERVER['HTTP_HOST'];
$site_url = " http://".$site_name.dirname($_SERVER['PHP_SELF']);
$site_this = " http://".$site_name.$_SERVER['PHP_SELF'];
//可见性,为0时只有会员可见,为1时所有人员都可见
$visibility = true;
if($visibility)
{
$upload_dir = "upload/public/";
}else
{
$upload_dir = "upload/private/";
}
$upload_url = $site_url."/".$upload_dir;/**
*********************************************
创建上传目录
*********************************************
**/
if(!is_dir($upload_dir))
{
if(!mkdir($upload_dir))
die('文件没有创建成功!!');
if (!chmod($upload_dir,0777))
die ("改变权限失败.");
上传文件处理
*********************************************
**/
if($_FILES['userfile'])
{
$resourse = fopen('log.txt','a');
fwrite($resourse,date('Y-m-d H:i:s')."上传 - 上传操作的ip地址为: $_SERVER[REMOTE_ADDR]" .$_FILES['userfile']['name']." ".$_FILES['userfile']['type']."\n");
fclose($resourse);
$file_name = $_FILES['userfile']['name'];//上传文件的名称
$file_type = $_FILES['userfile']['type'];//上传文件的类型
$file_postfix = substr($file_name,strrpos($file_name,"."));//上传文件的后缀
//文件大小检查
if($_FIFES['userfile']['size'] > $MAX_SIZE)
{
echo '文件太大不能上传';
}elseif(!in_array($file_type,$FILE_MIMES) && !in_array($file_postfix,$FILE_POSTFIX))
{
echo "对不起你所上传的文件类型不符合规定,不允许上传!!";
}else
{
do_upload($upload_dir,$upload_url);
}
}?>
<form name="upload" id="upload" ENCTYPE="multipart/form-data" method="post" action ="./upload.php">
选择图片类型:
<select name="select" size="1" id="select">
<option value="英语">英语</option>
<option value="计算机">计算机</option>
<option value="职业资格考试">职业资格考试</option>
<option value="考研">考研</option>
<option value="公务员">公务员</option>
< lect>
<br>
上传者:
<input name="upauthor" type="author">
<br>
<span class="样式2">上传文件</span>
<input type="file" id="userfile" name="userfile">
<input type="submit" name="upload" value="上传">
</form>
<?
/**
*********************************************
创建上传目录
*********************************************
**/
$handle = opendir($upload_dir);
while($file = readdir($handle))
{
if(!is_dir($file) && !is_link($file))
{
?>
<?php
function do_upload($upload_dir,$upload_url)
{
$temp_name = $_FILES['userfile']['tmp_name'];
$file_name = $_FILES['userfile']['name'];
$file_name = str_replace("\\","",$file_name);
$file_name = str_replace("'","",$file_name);
$file_path = $upload_dir.$file_name;
$sql="insert into tb_zl (id,name,time,author,type)values('','$upload_dir',now(),{$_POST[upauthor]}''{$_POST[select]}')";
mysql_query($sql);//导入数据库
echo " <font color=red>已经成功上传</font><br>文件名: <font color=blue>".$destination_folder.$fname."</font><br>";
echo "上传者:".$_POST[upauthor];
echo "<br/>";
echo "<br> 大小:".$file["size"]." bytes";
$author=trim($_POST[upauthor]);
$time=date("Y-m-d h:i:s");
$type=$_POST[select];$query=mysql_query("insert into tb_zl(author,time,type) values('$author','$time','$type')",$conn);
//文件名检查
if($file_name = '')
{
echo "文件名无效!!!";
exit;
}
$result = move_uploaded_file($temp_name,$file_path);
if($result)
{
echo "上传成功!!";
echo "<meta http-equiv=\"refresh\" content=\"1;url=upload.php\">";
exit; }
else
{
echo "上传失败!!";
echo "<meta http-equiv=\"refresh\" content=\"1;url=upload.php\">";
exit;
}
echo "end";
}?>如何把tb_zl表里的字段写到数据库中
*********************************************
参数设定
*********************************************
**/
//最大上传文件大小
$MAX_SIZE = 20000000;
//设置Mine类型
$FILE_MIMES = array('image/jpeg','image/jpg','image/gif','image/png','application/msword');
//设置允许上传的文件类型,按照格式添加
$FILE_POSTFIX = array('.zip','.jpg','.png','.gif','.wma','.rm','.wmv','.doc','.mpeg','.mp3','.avi');
//是否允许删除以上传的文件,允许:yes; 不允许:no;
$DELETE_ENABLE = 'yes';/**
*********************************************
变量设定
*********************************************
**/
$site_name = $_SERVER['HTTP_HOST'];
$site_url = " http://".$site_name.dirname($_SERVER['PHP_SELF']);
$site_this = " http://".$site_name.$_SERVER['PHP_SELF'];
//可见性,为0时只有会员可见,为1时所有人员都可见
$visibility = true;
if($visibility)
{
$upload_dir = "upload/public/";
}else
{
$upload_dir = "upload/private/";
}
$upload_url = $site_url."/".$upload_dir;/**
*********************************************
创建上传目录
*********************************************
**/
if(!is_dir($upload_dir))
{
if(!mkdir($upload_dir))
die('文件没有创建成功!!');
if (!chmod($upload_dir,0777))
die ("改变权限失败.");
上传文件处理
*********************************************
**/
if($_FILES['userfile'])
{
$resourse = fopen('log.txt','a');
fwrite($resourse,date('Y-m-d H:i:s')."上传 - 上传操作的ip地址为: $_SERVER[REMOTE_ADDR]" .$_FILES['userfile']['name']." ".$_FILES['userfile']['type']."\n");
fclose($resourse);
$file_name = $_FILES['userfile']['name'];//上传文件的名称
$file_type = $_FILES['userfile']['type'];//上传文件的类型
$file_postfix = substr($file_name,strrpos($file_name,"."));//上传文件的后缀
//文件大小检查
if($_FIFES['userfile']['size'] > $MAX_SIZE)
{
echo '文件太大不能上传';
}elseif(!in_array($file_type,$FILE_MIMES) && !in_array($file_postfix,$FILE_POSTFIX))
{
echo "对不起你所上传的文件类型不符合规定,不允许上传!!";
}else
{
do_upload($upload_dir,$upload_url);
}
}?>
<form name="upload" id="upload" ENCTYPE="multipart/form-data" method="post" action ="./upload.php">
选择图片类型:
<select name="select" size="1" id="select">
<option value="英语">英语</option>
<option value="计算机">计算机</option>
<option value="职业资格考试">职业资格考试</option>
<option value="考研">考研</option>
<option value="公务员">公务员</option>
< lect>
<br>
上传者:
<input name="upauthor" type="author">
<br>
<span class="样式2">上传文件</span>
<input type="file" id="userfile" name="userfile">
<input type="submit" name="upload" value="上传">
</form>
<?
/**
*********************************************
创建上传目录
*********************************************
**/
$handle = opendir($upload_dir);
while($file = readdir($handle))
{
if(!is_dir($file) && !is_link($file))
{
?>
<?php
function do_upload($upload_dir,$upload_url)
{
$temp_name = $_FILES['userfile']['tmp_name'];
$file_name = $_FILES['userfile']['name'];
$file_name = str_replace("\\","",$file_name);
$file_name = str_replace("'","",$file_name);
$file_path = $upload_dir.$file_name;
$sql="insert into tb_zl (id,name,time,author,type)values('','$upload_dir',now(),{$_POST[upauthor]}''{$_POST[select]}')";
mysql_query($sql);//导入数据库
echo " <font color=red>已经成功上传</font><br>文件名: <font color=blue>".$destination_folder.$fname."</font><br>";
echo "上传者:".$_POST[upauthor];
echo "<br/>";
echo "<br> 大小:".$file["size"]." bytes";
$author=trim($_POST[upauthor]);
$time=date("Y-m-d h:i:s");
$type=$_POST[select];$query=mysql_query("insert into tb_zl(author,time,type) values('$author','$time','$type')",$conn);
//文件名检查
if($file_name = '')
{
echo "文件名无效!!!";
exit;
}
$result = move_uploaded_file($temp_name,$file_path);
if($result)
{
echo "上传成功!!";
echo "<meta http-equiv=\"refresh\" content=\"1;url=upload.php\">";
exit; }
else
{
echo "上传失败!!";
echo "<meta http-equiv=\"refresh\" content=\"1;url=upload.php\">";
exit;
}
echo "end";
}?>如何把tb_zl表里的字段写到数据库中
$sql="insert into tb_zl (id,name,time,author,type)values('','$upload_dir',now(),'{$_GET[upauthor]}',{$_GET[select]}')";数据不能正常插入,先输出SQL语句查看下。
$sql="insert into tb_zl (id,name,time,author,type)values('','$upload_dir',now(),'{$_POST[upauthor]}',{$_POST[select]}')";