前台代码<form action="indexluoji.php" method="post" enctype="multipart/form-data"><div>输入图片(大小333px*156px)</div><input type="file" id="file" name="file"><div>输入小分类</div>
<textarea class="duohang" rows="3" cols="20" name="tupianwenzi2">
222</textarea>
<div>输入描述</div>
<textarea class="duohang" rows="3" cols="20" name="tupianwenzi3">222</textarea>
<input type="hidden" name="hidid" value="1" />
<div><button type="submit" >保存</button></div>
</form>后台
$iii= 'images/'.$_FILES["file"]["name"];$sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]',tupiandetail = '$iii',miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";我现在想 不浏览图片 update不会覆盖原来tupiandetail的内容
<textarea class="duohang" rows="3" cols="20" name="tupianwenzi2">
222</textarea>
<div>输入描述</div>
<textarea class="duohang" rows="3" cols="20" name="tupianwenzi3">222</textarea>
<input type="hidden" name="hidid" value="1" />
<div><button type="submit" >保存</button></div>
</form>后台
$iii= 'images/'.$_FILES["file"]["name"];$sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]',tupiandetail = '$iii',miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";我现在想 不浏览图片 update不会覆盖原来tupiandetail的内容
有下标的数据数据引用,最好用.来连接。
//只对成功桑穿的图片进行处理
$iii= 'images/'.$_FILES["file"]["name"]; $sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]',tupiandetail = '$iii',miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";
....
}
if($_FILES["file"]['error'] == 0)
{
//文件保存文件等操作
$iii= 'images/'.$_FILES["file"]["name"];
$str = ",tupiandetail = '$iii'";
}$sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]'".$str.",miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";
如果不明白我的逻辑,就听我的打印出SQL语句看看结果,然后在想想哪里搞错了。
$str = "";
$sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]'".$str.",miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";
我运行了啊 就是把原来的字段内容覆盖了啊
$sql="UPDATE detail SET dafenleidetail = '$_POST[detail1]',xiaofenleidetail = '$_POST[detail2]',btdetail = '$_POST[detail3]'".$str.",miaoshudetail = '$_POST[detail5]' WHERE id='$_POST[hidid]'";
我运行了啊 就是把原来的字段内容覆盖了啊
有啊 我不用这个方法了
--------------------
你不是说你运行了吗,上面的SQL语句里哪里有tupiandetail字段?你还能说有?