请问各位,打开修改页面,图片浏览框是空的,但数据库中已经有图片文件名了,如果看了修改按钮,在数据库中的图片文件名则会为空,如何能够做到,浏览框为空时,点击修改按钮,数据库中的图片文件名,不会被更新为空,请指点,谢谢。
$uploaddir='****/****';
if (!empty($_FILES['BARGAIN_PIC']['tmp_name']) && $_FILES['BARGAIN_PIC']['error'] == 0) {
$uploadname = basename($_FILES['BARGAIN_PIC']['name']);
copy($_FILES['BARGAIN_PIC']['tmp_name'],$uploaddir.trim($uploadname));
$BARGAIN_PIC = trim($uploadname);
}
$sql = "update BARGAIN ";
$sql.= " set BARGAIN_USER_COUNT='".str_replace($old_value,$new_value,trim($update_array["BARGAIN_USER_COUNT"]))."',";//更新用户名
$sql.= " BARGAIN_PIC='".addslashes($BARGAIN_PIC)."'";//更新图片文件名
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($update_array["bargain_id"]))."'";
$uploaddir='****/****';
if (!empty($_FILES['BARGAIN_PIC']['tmp_name']) && $_FILES['BARGAIN_PIC']['error'] == 0) {
$uploadname = basename($_FILES['BARGAIN_PIC']['name']);
copy($_FILES['BARGAIN_PIC']['tmp_name'],$uploaddir.trim($uploadname));
$BARGAIN_PIC = trim($uploadname);
}
$sql = "update BARGAIN ";
$sql.= " set BARGAIN_USER_COUNT='".str_replace($old_value,$new_value,trim($update_array["BARGAIN_USER_COUNT"]))."',";//更新用户名
$sql.= " BARGAIN_PIC='".addslashes($BARGAIN_PIC)."'";//更新图片文件名
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($update_array["bargain_id"]))."'";
目的就是:如果没有上传图片的话,把BARGAIN_PIC=''从sql里面去掉
$sql.= " set BARGAIN_USER_COUNT='".str_replace($old_value,$new_value,trim($update_array["BARGAIN_USER_COUNT"]))."',";//更新用户名
if(empty($BARGAIN_PIC)){
//不修改图片字段
}endif
$sql.= " BARGAIN_PIC='".addslashes($BARGAIN_PIC)."'";
$sql.= " where BARGAIN_ID='".str_replace($old_value,$new_value,trim($update_array["bargain_id"]))."'";中间您所说的不修改图片字段,是则么样的?
是的话sql语句里图片字段去掉,
否的话再写一个正常的sql语句
if 有图片
$sql .= 设置图片
endif
$sql .= ............;
请指点一下