Updating blob data help needed

mattyd

Hello all.

Just been adding a few modifications to the script found @: http://www.phpbuilder.com/columns/florian19991014.php3.

I am trying to add an update script so that entries can be altered / ammended. I've discovered that updating blob data isn't as easy as I thought!

Here's my script so far:

<HTML>
<HEAD><TITLE>Store binary data into SQL Database</TITLE></HEAD>
<BODY>

<?php
if ($submit) {
MYSQL_CONNECT("localhost","matt","r1ffraff");
mysql_select_db("test_matt");

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

$result=MYSQL_QUERY("UPDATE binary_data SET(description,bin_data,filename,filesize,filetype) ".
    "VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type') WHERE id='$id'");


print "<p>This file has the following Database ID: <b>$id</b>";

MYSQL_CLOSE();

} else {

// else show the form to submit new data:

?>
<?php

$Hostname = "localhost";
$User = "matt";
$Password = "r1ffraff";
$DBName = "test_matt";
$TableName = "binary_data";

$Link = mysql_connect($Hostname, $User, $Password);
$Query = "Select * from $TableName WHERE id = '$id'";
$Result = mysql_db_query ($DBName, $Query, $Link);

<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
File Description:<br>
<input type="text" name="form_description"  size="40" value="<?php echo ($description); ?>">
<INPUT TYPE="hidden" name="MAX_FILE_SIZE" value="1000000">
<br>File to upload/store in database:<br>
<input type="file" name="form_data"  size="40">
<p><input type="submit" name="submit" value="submit">
</form>

<?php
}
?>
</BODY>

</HTML>

I know the code is a bit messy at the moment (and obviously broken somewhere), but can anyone point out where I'm going wrong?

Any help would be greatly appreciated.

Thanks
Matt

bad76

but what is
exactly the problem? I think you don't have any message error but blob field is not saved corret, right? I experienced that guilt is magic quotes. Try to remove one of addslashes / stripslashes.

Else if you have some error please post it.

See you.

mattyd

The problem is that none of the information is being updated (not even the text fields)

I am not receiving any errors,... it just takes me back to the display page.

Are you suggesting that I remove the addslashes part?

bad76

No,
try else this other sintax
"UPDATE tavola SET fieldname1='fieldvalue1', fieldname1='fieldvalue1', ... WHERE id='idvalue'"

mattyd

Tried altering the SQL syntax, but still no luck.

Any other ideas?

bad76

With a tank? bazooka?😃

Some debug hint:
1) Try the same code without the blob.
2) Try if the code is executed. Just behind of the update insert a big echo.
3) Copy the query on a variable and echo this:

$myquery="UPDATE binary_data SET(description,bin_data,filename,filesize,filetyp
e) ". 
"VALUES ('$form_description','$data','$form_data_name','$f
orm_data_size','$form_data_type') WHERE id='$id'";
echo "<i>".$myquery."</I><br>";
$result=MYSQL_QUERY($myquery);

4) Look at the name of table, db and host.
5) menace it and say "DOH!":mad:

see you