Storing files in database using ODBC

[Markus Müller <mueller.m@xxxxxxxxxxxxxxxxxxxx>]

Hi,

I'm trying to store an image - getting by HTTP-Post - in a Sybase
iAnywhere-Database.

I'm using the Unified ODBC functions to connect to the database.

The following function should store the image-file:

function ab_insert_file ( $connection_id, $document_id)
{
	if ($_FILES['FILE']['size'] > 0 )
	{
	//move_uploaded_file($_FILES['FILE']['tmp_name'],'c:\tmp\file1.gif'); //
just tried, if the upload works
	$mime_type = 'IMAGE/GIF';
	$fhandle = fopen($_FILES['FILE']['tmp_name'],'r');
	$blob_data = fread($fhandle, filesize($_FILES['FILE']['tmp_name']));
	$data = bin2hex( $blob_data );
	$insert = "insert into document_file
	 			(document_id, filename, data, file_date, mime_type) values
	 			($document_id, '".$_FILES['FILE']['name']."', 0x".$data.", NULL,
'$mime_type')";
	ab_insert_db($connection_id, $insert); // function for inserting the
statement
	}
}

The fileupload works fine. But if i try to face the image, I only get some
fragments of it (the first part, only).

The output-function reads as follows:

<?php
$select = "select data, mime_type from document_file where document_file_id
= $document_file_id";
$Query_ID = odbc_exec($connection_id, $select);
// change to ODBC_BINMODE_CONVERT for comparison
odbc_binmode($Query_ID, ODBC_BINMODE_RETURN);
$Images = odbc_result($Query_ID, 1);
echo $Images;
?>

Any Idea?

Thanks :-))

Markus

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php