[RESOLVED] Can't seem to save the name of an uploaded pic to the database. Wierd.

Phrank

I enter data and a choose a file name to upload. Go to an Add routine. All the data gets added except the filename I want to save in a field to be able to display the pic later.

I save the name of the file with $uploadedfilename = $_FILES['userfile']['name']. I echo it out just before inserting the data into the database and it looks good on the screen but the filename is not saved. The field is type text.

I use the same code on an update routine and it works.

I have even tried doing a update right after inserting the data and it still does not work.

Insert code followed by this code.
$result = mysql_query("SELECT * from principals where principalscode = '".$principalscode."'")
or die (mysql_error());
$Row=mysql_fetch_assoc($result);
$id = $Row['id'];
$Mode = "Update";
$SubmitMode = "";
$result = mysql_query("update principals
set principalslogofilename = '$saveuploadedfilename'
where id ='".$id."'");

Any help would be greatly apprecaited.

Ashley_Sheridan

You've not shown how you're "saving" the name in the database, but the excerpt shows you're using variables called $saveuploadedfilename and $uploadedfilename. Was this intentional?

Phrank

Just debugging using those variables.

Here is where I add the initial data.

		echo "<br>" . "The uploaded file name 2 is= " . $saveuploadedfilename;

// echo "<br> at add";
$principalscode = strtoupper($principalscode);
$principalsdescription = addslashes($principalsdescription);
$principalswwwaddress = addslashes($principalswwwaddress);
$today = getdate();
$day = $today['year']."-".$today['mon']."-".$today['mday'];
$sql = mysql_query("INSERT INTO principals (principalscode,principalscompanyname,principalsdescription,principalswwwaddress,principalslogofilename,code1,code2,active,datecreated)
VALUES ('$principalscode','$principalscompanyname','$principalsdescription','$uploadedfilename','$principalslogofilename','$code1','$code2','$active','$day')")
or die (mysql_error());
$result = mysql_query("SELECT * from principals where principalscode = '".$principalscode."'")
or die (mysql_error());
$Row=mysql_fetch_assoc($result);
$id = $Row['id'];
$Mode = "Update";
$SubmitMode = "";
$result = mysql_query("update principals
set principalslogofilename = '$saveuploadedfilename'
where id ='".$id."'");

bradgrafelman

Few things:

When posting PHP code please use the board's [noparse]
```
..
```
[/noparse] bbcode tags as they make your code much easier to read and analyze.
Stop Using the MySQL Extension!
[man]addslashes/man should not be used to prepare user-supplied data for use in a SQL query; for MySQL, there are more appropriate functions such as [man]mysqli_real_escape_string/man.
You're still exhibiting the same issue Ashley pointed out above; you echo out $saveuploadedfilename and yet you try to use $uploadedfilename. It would appear that only one of those variable names is correct.
Note that you could remove a couple of PHP statements if you simply use MySQL's CURDATE() function to insert the current date in YYYY-MM-DD format.

Phrank

Found the pblm. The data was going into the table OK. It was on retreiving it that the problem came up.

Thanks for all your help.