///预览图片///
if(isset($_POST["view"])){
$path = $_FILES["file"]["tmp_name"];
?>
height=200/>
}
上传图片
if(isset($_POST["sub"])){
$picName = $_FILES["file"]["name"];
$id=time();//定义变量,保存图片名,以防图片的名字相同
setcookie("cookie", $id, time()+3600);
$type=substr(strrchr($picName, '.'), 1);
$path="C:/xampp/htdocs/pix/".$picName;
$tmp_name=$_FILES["file"]["tmp_name"];
if($_FILES["file"]["error"]>0){
echo
"上传文件有误:".$_FILES["file"]["error"]."
";
}else{
if(file_exists($path)){
echo "已经存在";
}else{
include_once 'connect.php';
$conn = GetConnection();
$sql = "INSERT INTO `mdl_add_picture` (
`id`, `path`, `del_flg`, `update_time`, `suffix`) ".
"VALUES ('".$id."', '".$path."', '0',
'".date("Y-m-d H:M:s")."', '.".$type."')";
$root = mysql_query($sql,$conn);
if($root>0){
if(move_uploaded_file($tmp_name,$path)){
echo $picName."上传成功";
?>
src="<?php echo $path;?>" width=200
height=200/>
}else{
echo $picName."上传失败1";
}
}else{
echo $picName."上传失败2";
}
}
}
}
if(isset($_POST["upd"])){
$picName = $_FILES["file"]["name"];
$id=time();//定义变量,保存图片名,以防图片的名字相同
$type=substr(strrchr($picName, '.'), 1);
$path="C:/xampp/htdocs/pix/".$picName;
$tmp_name=$_FILES["file"]["tmp_name"];
if($_FILES["file"]["error"]>0){
echo
"上传文件有误:".$_FILES["file"]["error"]."
";
}else{
if(file_exists($path)){
echo "已经存在";
}else{
include_once 'connect.php';
$conn = GetConnection();
$sql1 ="SELECT path FROM mdl_add_picture WHERE
id='".$_COOKIE['cookie']."'";
$result=mysql_query($sql1,$conn);
while($line =mysql_fetch_array($result,MYSQL_ASSOC)){
foreach ($line as $col_value) {
$sql = "UPDATE mdl_add_picture SET
path='".$col_value."',update_time='".date("Y-m-d
H:M:s")."',suffix='".$type."' WHERE
id='".$_COOKIE['cookie']."'";
$root = mysql_query($sql,$conn);
if($root>0){
echo $picName."修改成功";
if(move_uploaded_file($tmp_name,$path)){
unlink($col_value);
?>
src="<?php echo $path;?>" width=200
height=200/>
}else{
echo $picName."修改失败1";
}
}else{
echo $picName."修改失败2";
}
}
}
}
}
}
///删除图片///
if(isset($_POST["del"])){
$picName=$_FILES["file"]["name"];
if($picName != null){
$path="C:/xampp/htdocs/pix/".$picName;
echo "图片路径:".$path;
include_once 'connect.php';
$conn = GetConnection();
$sql = "SELECT id FROM mdl_add_picture WHERE
path='".$path."'";
$root = mysql_query($sql,$conn);
if($root>0){
$sql = "UPDATE mdl_add_picture SET
del_flg='1',update_time='".date("Y-m-d H:M:s")."' WHERE
path='".$path."'";
$root = mysql_query($sql,$conn);
if($root>0){
echo $picName."删除成功";
}else{
echo $picName."删除失败";
}
}else{
echo $picName."不存在";
}
}else{
echo $picName."不存在";
}
}
?>
enctype="multipart/form-data">
图片路径:
name="file">
value="上传">
value="预览">
value="修改">
value="删除">
value="清空"/>