[RESOLVED] update not working

shadiadi

Hi some help here would be appreciated my update isn't working everything in this statement updates except $file1 $file2 which are blob fields. After the update they just stay as [BLOB 0]??

$file1 = (fread(fopen($data2,0,"data2")));
$file2 = (fread(fopen($thumbnail2,0,"thumbnail2")));
$sql02 = "update zloads set description1 = '$description2', data1 = '$file1', filename1 = '$filename2', filesize1 = '$filesize2', filetype1 = '$filetype2', thumbnail1 = '$file2', thumbnailtype1= '$thumbnailtype2' where intProductID='$id'";

walterquez

Make sure you have the right parameters for fopen and fread.
http://us.php.net/fopen
http://us.php.net/fread

$handle = fopen($filename1, 'r');
$file1 = fread($handle, filesize($filename1));

$handle = fopen($filename2, 'r');
$file2 = fread($handle, filesize($filename2));

You can also have MySQL load the files for you.

UPDATE zloads SET
	description1 = '$description2',
	data1 = '$file1',
	filename1 = LOAD_FILE($filename1),
	filesize1 = '$filesize2',
	filetype1 = '$filetype2',
	thumbnail1 = LOAD_FILE($thumbnail1),
	thumbnailtype1= '$thumbnailtype2'
WHERE intProductID='$id'

shadiadi

mmm tried that just keep getting the following errors from the fopen fread lines also the Load_file gives out a wierd error it can see the data but isnt writing it?

the fread fopen errors

Warning: fopen(‰PNG  ) [function.fopen]: failed to open stream: No such file or directory in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 60

Warning: filesize() [function.filesize]: stat failed for ‰PNG  in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 61

Warning: fread(): supplied argument is not a valid stream resource in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 61

Warning: fopen(ÿØÿà) [function.fopen]: failed to open stream: No such file or directory in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 63

Warning: filesize() [function.filesize]: stat failed for ÿØÿà in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 64

Warning: fread(): supplied argument is not a valid stream resource in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 64

Warning: Cannot modify header information - headers already sent by (output started at /home/hmtcompa/public_html/user/myaccount/updatepics.php:60) in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 74

walterquez

Read the first error message, it says, No such file or directory in ...
According to the error message, it is looking in /home/hmtcompa/public_html/user/myaccount/. Is this where the files are located?

Make sure $data2 and $thumbnail2, including the directories, are pointing to the "exact" location of the files, otherwise it will not work.

Something like
$file1 = '/home/hmtcompa/public_html/user/images/image.png';

shadiadi

mmm jus to let you know $data2 and $thumbnail2 are already stored as blobs in the database and not files from $_post

walterquez

After fread, use base64_encode() before passing it to MySQL.

$handle = fopen($filename1, 'r');
$file1 = fread($handle, filesize($filename1));
$file1 = base64_encode($file1);

$handle = fopen($filename2, 'r');
$file2 = fread($handle, filesize($filename2));
$file2 = base64_encode($file2);

Either way, and I don't know if this was ever discussed in this forum, but why are you saving files in the database? I guess it depends what school of thought you come from, but I think files should stay where they are, and in the database you would only insert a pointer to the location of the files, not save the files in the database. I guess you could say I come from the school of separation of concern.

bradgrafelman

@: There's no need to use base64 encoding when storing files in the database.

@: So $data2 and $thumbnail2 are variables that contain data you've retrieved from the database already? If so, then what are you trying to do with them?

If you're trying to UPDATE a row in MySQL with file data, then you'd want something like:

$file1 = file_get_contents('path/to/file');
$file1 = mysql_real_escape_string($file1);

// etc. for other files

shadiadi

mm looks like its almost working but i can't seem to get the file path right $data2 is stored in the data base i have called it in the header $data2 = $row["data2"];

I am currently using what you gave me

$file1 = file_get_contents($data2); 
$file1 = mysql_real_escape_string($file1); 
$sql02 = "update zloads set description1 = '$description2', data1 = '$file1', filename1 = '$filename2', filesize1 = '$filesize2', filetype1 = '$filetype2', thumbnailtype1= '$thumbnailtype2' where intProductID='$id'";

keeps giving me the following error?
I have tried numerous ways of ('$data2') ($data2) ('.$data2.') ($row["data2") I even tried "SELRCT data2 FROM zloads where intProductID='$id'" get the same error message every time????

Warning: file_get_contents(‰PNG  ) [function.file-get-contents]: failed to open stream: No such file or directory in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 59

Warning: Cannot modify header information - headers already sent by (output started at /home/hmtcompa/public_html/user/myaccount/updatepics.php:59) in /home/hmtcompa/public_html/user/myaccount/updatepics.php on line 69

line 69 being // $file1 = file_get_contents($data2);

happy new year by the way

shadiadi

mm just to let you know $data2 is saved as a longblob binary already

bradgrafelman

Show us where $data2 is defined, and explain what you're trying to do.

shadiadi

$data2 is defined here in the head

 $sql = "SELECT * FROM zloads WHERE intProductID='$id'";
	$temps  = $DB_site->query($sql);
	if($row=$DB_site->fetch_array($temps))
	{
$description1         = $row["description1"];
$data1                = $row["data1"];
$filename1            = $row["filename1"];
$filesize1            = $row["filesize1"];
$filetype1            = $row["filetype1"];
$thumbnail1           = $row["thumbnail1"];
$thumbnailtype1       = $row["thumbnailtype1"];
$description2         = $row["description2"];
$data2                = $row["data2"];
$filename2            = $row["filename2"];
$filesize2            = $row["filesize2"];
$filetype2            = $row["filetype2"];
$thumbnail2           = $row["thumbnail2"];
$thumbnailtype2       = $row["thumbnailtype2"];
$description3         = $row["description3"];
$data3                = $row["data3"];
$filename3            = $row["filename3"];
$filesize3            = $row["filesize3"];
$filetype3            = $row["filetype3"];
$thumbnail3           = $row["thumbnail3"];
$thumbnailtype3       = $row["thumbnailtype3"];
$description4         = $row["description4"];
$data4                = $row["data4"];
$filename4            = $row["filename4"];
$filesize4            = $row["filesize4"];
$filetype4            = $row["filetype4"];
$thumbnail4           = $row["thumbnail4"];
$thumbnailtype4       = $row["thumbnailtype4"];

}

$data2 is already stored in $row["data2"] as a longblob but I am trying to call it and update $row["data1"] with the value of $row["data2"] bearing in mind that $row["data1"] is a longblob field and is already empty all the other values in the statement update fine it is just the blobs that will not update?

shadiadi

wow i feel stupid just solved it with this

$file1 = $row["data2"]; 
$file1 = mysql_real_escape_string($file1); 
$file2 = $row["thumbnail2"]; 
$file2 = mysql_real_escape_string($file2); 
$sql02 = "update zloads set description1 = '$description2', data1 = '$file1', filename1 = '$filename2', filesize1 = '$filesize2', filetype1 = '$filetype2', thumbnail1 = '$file2', thumbnailtype1 = '$thumbnailtype2' where intProductID='$id'";

thanks for all your help much appreciate and have a happy new year 🙂

Weedpacket

Just as a note:

file_get_contents(&#8240;PNG  )

You already have the content (that thing there is the start of a PNG file, as I've mentioned before). You don't need to get it again.