[RESOLVED] a blank input?

rbblue8

hey everyone.

So my end goal here is that when the user does not put data into a field of a forum, that when it's submited, what ever it's current value from the mysql databse pull, remains unchanged.

Basically if the user does not change the value it should stay the same. But i have no idea how to do this.... Since i do not know when the end user is going to update there picture or not... I need it to be pulled and updated every time they hit the submit buttion.

Here is what I have so far (part of the code that retains to the update)

$picture=$_FILES['file'];
	$new_des='/web/knightsofrage.net/pic/'.$file_name.'';
	if($picture !="none")$mysql_des=$data[1];
	else $mysql_des='http://knightsofrage.net/pic/'.$file_name.'';
	$move=move_uploaded_file($file_tmp,$new_des);
	$update_string=("UPDATE website SET picture_file='$mysql_des', about_me='$text' where username='$user'");
	$update=mysql_query($update_string, $db);

now.. the field name is picture_link and $_FILES['file'] is the field name that was submitted.

if($picture !="none")$mysql_des=$data[1];

does not work.

the $data[1] is the key that is currently stored in the mysql database. Which if the user does not enter any value in $_FILES['file'] i wish the $data[1] to stay the same.

can ya help??

Weedpacket

If the file field is empty, don't change the file data stored in the database. If the question is whether to delete the entry in the database, make that a separate form field.

rbblue8

Weedpacket wrote:
If the file field is empty, don't change the file data stored in the database. If the question is whether to delete the entry in the database, make that a separate form field.

wow.....

Ok... If the file field is empty, don't change the file data stored in the database. That's what i want to do. BUt I'm asking how for my code does not seam to be working. When i tried to put that in my php file it just spit out a lot of errors 😕

rbblue8

Solved it.

I ended up using the wrong field. I guess that;s what you get for working on it late @ night :-/

here is what i changed the code to

$picture1=$data[1];
	$file_name=$picture['name'];
	$file_tmp=$picture['tmp_name'];
	$new_des='/web/knightsofrage.net/pic/'.$file_name.'';
	$mysql_des='http://knightsofrage.net/pic/'.$file_name.'';
    if($file_tmp == "")$mysql_des=$picture1;
	$move=move_uploaded_file($file_tmp,$new_des);
	$update_string=("UPDATE website SET picture_file='$mysql_des', about_me='$text' where username='$user'");
	$update=mysql_query($update_string, $db);
	if(!$update)die('unable to update your profile, please let the site administration know about this' .mysql_error());
	echo '<center><span style="color:FFFFFF">Sucess!, You have updated your profile';