file to database conversion

israel_sioson

Can somebody help me out, it's been bothering me for 2 days now and still can't find the solution.
My problem is this, I need to convert the code below so that it stores $data[] as a blob to a MySQL database instead of writing to a file.

$fp = fopen( $fileName, "wb" );
for ( $i = 0; $i < $dataLen; $i++ )
fwrite( $fp, chr( $data[$i] ), 1 );
fclose( $fp );

I changed the above code to the code below but it returned a different result than from the code above.

$dataString = "";
for ( $i = 0; $i < $dataLen; $i++ )
$dataString .= chr($data[$i]);

I don't know why, but I think it has something to do with the length argument of fwrite().

Thanks in advance.

bad76

Hi,
because your data is binary you have to encode it:

try with

$dataString = ""; 
for ( $i = 0; $i < $dataLen; $i++ ) 
           $dataString .= chr($data[$i]); 
$datastring=urlencode($datastring);

And if there is magic_quotes active you can have other problem with addslashes() - stripslashes()...

israel_sioson

I don't see why I should urlencode() $dataString, isn't it used for encoding a string to be used in a query part of an URL?

$data[] contains decimal data but I've already converted it to ASCII with chr(), although it doesn't return values I'm expecting to get.

Anyway, I've tried bad76's recommendation and it still doesn't return the correct string (even after I turned-off magic_quotes).

More help please.

Thanks.

israel_sioson

Guys, I found the answer.

set_magic_quotes_runtime(0);
$dataString = "";
for ( $i = 0; $i < $dataLen; $i++ ) {
$dataString .= addslashes(chr($data[$i]));
}

All it needs is the addslashes. I previously placed addslashes in there before and turned-off magic quotes in the calling function (the code above is from a class) but it returns incorrect values.

The problem, it seems, is that even when magic_quotes are off, the class where the code above is contained has magic_quotes enabled. Therefore, set_magic_quotes_runtime(0) must be performed before the conversion.