我为在mysql中编辑数据做了一个简单的编辑,一切都很好,除了当我想编辑输入文件类型的图像时,它不起作用,它不会给出错误消息,它只是不编辑任何内容,当我删除输入文件类型图像时它起作用。我所说的编辑图像是指输入一个新的图像,它将取代旧的图像。
这是我的代码:
<?php
require("db.php");
$id = $_REQUEST['theId'];
$result = mysql_query("SELECT * FROM table WHERE id = '$id'");
$test = mysql_fetch_array($result);
$name = $test['Name'] ;
$email = $test['Email'] ;
$image = $test['Image'] ;
if (isset($_POST['submit']))
{
$name_save = $_POST['name'];
$email_save = $_POST['email'];
if (isset($_FILES['image']['tmp_name']))
{
$file = $_FILES['image']['tmp_name'];
$image = addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name = addslashes($_FILES['image']['name']);
move_uploaded_file($_FILES["image"]["tmp_name"],"photos/" . $_FILES["image"]["name"]);
$image_save ="photos/" . $_FILES["image"]["name"];
mysql_query("UPDATE table SET Name ='$name_save', Email ='$email_save',Image ='$image_save' WHERE id = '$id'") or die(mysql_error());
header("Location: index.php");
}
}
?>
<form method="post">
<table>
<tr>
<td>name:</td>
<td>
<input type="text" name="name" value="<?php echo $name ?>"/>
</td>
</tr>
<tr>
<td>email</td>
<td>
<input type="text" name="email" value="<?php echo $email ?>"/>
</td>
</tr>
<tr>
<td>image</td>
<td>
<input type="file" name="image" value="<?php echo $image ?>"/>
</td>
</tr>
<tr>
<td> </td>
<td>
<input type="submit" name="submit" value="submit" />
</td>
</tr>
</table>
表单中缺少enctype="multipart/form data",而表单中没有type="file"。
给出以下代码并尝试。
<?php
require("db.php");
$id =$_REQUEST['theId'];
$result = mysql_query("SELECT * FROM table WHERE id = '$id'");
$test = mysql_fetch_array($result);
$name=$test['Name'] ;
$email= $test['Email'] ;
$image=$test['Image'] ;
if(isset($_POST['submit'])){
$name_save = $_POST['name'];
$email_save = $_POST['email'];
$image_save=$image //Added if image is not chose from the form post
if (isset($_FILES['image']['tmp_name'])) {
$file=$_FILES['image']['tmp_name'];
$image= addslashes(file_get_contents($_FILES['image']['tmp_name']));
$image_name= addslashes($_FILES['image']['name']);
move_uploaded_file($_FILES["image"]["tmp_name"],"photos/" . $_FILES["image"]["name"]);
$image_save ="photos/" . $_FILES["image"]["name"];
}
mysql_query("UPDATE table SET Name ='$name_save', Email ='$email_save',Image ='$image_save' WHERE id = '$id'")
or die(mysql_error());
header("Location: index.php"); }
?>
<form method="post" enctype="multipart/form-data">
<table>
<tr>
<td>name:</td>
<td><input type="text" name="name" value="<?php echo $name ?>"/></td>
</tr>
<tr>
<td>email</td>
<td><input type="text" name="email" value="<?php echo $email ?>"/></td>
</tr>
<tr>
<td>image</td>
<td><input type="file" name="image" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="submit" /></td>
</tr>
</table>
此外,如果在更新时没有选择image,则应通过sql获取先前的image值并进行更新。
<tr>
<td>image</td>
<td><input type="file" name="image" ></td>
</tr>
为了使用$_FILES
处理图像文件,必须使用input:type=file
元素而不是input:type=text
。或者您无法获取图像文件。所以你的if语句返回false,什么也没发生。
<form method="post" enctype="multipart/form-data">
<table>
<tr>
<td>name:</td>
<td><input type="text" name="name" value="<?php echo $name ?>"/></td>
</tr>
<tr>
<td>email</td>
<td><input type="text" name="email" value="<?php echo $email ?>"/></td>
</tr>
<tr>
<td>image</td>
<td><input type="file" name="image" /></td>
</tr>
<tr>
<td>image preview</td>
<td><img src="photos/<?php echo $image ?>" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="submit" value="submit" /></td>
</tr>
</table>
</form>