RTFM:

http://www.php.net/manual/en/function.mysqli-stmt-send-long-data.php

it seems to work with mysqli_stmt_send_long_data(), but it has to work without, as the doc says, you only have to use it, if you send data larger than max_allowed_packet. This value is set to 16M, that data is only 2mb.

Kind regards

Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip

it doesn?t work, but the behavior changed a little:
Every insert without mysqli_stmt_send_long_data()
inserts 0 Bytes into the blob field, with this function
it works as in the other version (5.0.5)

Assigned to the maintainer.

This Problem is very annoying, becouse i am using innodb tables with foreign key constraints, and if i use mysqli_stmt_send_long_data() for any of the fields, all the other arent NULL anymore. So my constraint fails!

Example:
<?php

$GLOBALS['CONN'] = mysqli_connect(...);

mysqli_select_db(..);

$s =
file_get_contents('/usr/portage/distfiles/vim-runtime-20050601.tar.bz2')
;

$one = NULL;
$two = NULL;

$q = 'INSERT INTO dbfs_data_chunk VALUES (?,?,?)';
$stmt = mysqli_stmt_init($GLOBALS['CONN']);
mysqli_stmt_prepare($stmt,$q);
mysqli_stmt_bind_param($stmt,'iib',$one,$two,$s);
//mysqli_stmt_send_long_data($stmt,2,$s);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);

exit;

?>

without mysqli_stmt_send_long_data() i have the problem as described, and with mysqli_stmt_send_long_data() on the blob field, mysql tells me, that the constraint gets violated!
This can only happen, if the variables $one and $two are not  NULL.

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.php.net/manual/ and the instructions on how to report
a bug at http://bugs.php.net/how-to-report.php

from http://www.php.net/mysql_stmt_bind_param

Character Description
b         corresponding variable is a blob and will be send in packages

For sending a blob in packages, you have to use mysql_stmt_send_long_data. If you don't want to do this (e.g. your data doesn't need escaping and is < max_allowed_package) use type "s" (=string).

Well, i allready tried this:

<?php

mysqli_connect(..);
mysqli_select_db(..);

$s = file_get_contents('/usr/portage/distfiles/vim-runtime-20050601.tar.bz2');

$one = 1;
$two = 2;

$q = 'INSERT INTO dbfs_data_chunk VALUES (?,?,?)';
$stmt = mysqli_stmt_init($GLOBALS['CONN']);
mysqli_stmt_prepare($stmt,$q);
mysqli_stmt_bind_param($stmt,'iis',$one,$two,$s);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);

exit;

?>

Exaclty the same problem.

Fix it.

Kind Regards

Florian Engelhardt

Hello,

i have a hint for you: The size inserted into the database is exactly the size, that strlen() returns, BUT: strlen stops on  the first \0 and in a real binary file, this sign can be everywhere, not just at the end. In your case, i 
found this:

php-5.0.5/ext/mysqli/mysqli_api.c:161

case 's': /* string */
bind[ofs].buffer_type = MYSQL_TYPE_VAR_STRING;
bind[ofs].buffer = NULL;
bind[ofs].buffer_length = 0;
bind[ofs].is_null = &stmt->param.is_null[ofs];

I tried this, and i found out, that it works with MYSQL_TYPE_VAR_STRING, but you have to specify the length. If i insert the right lengt, everything works as expected.

So you just have to define the length for the data that is in the bound variable.

Kind regards

Florian Engelhardt

case MYSQL_TYPE_VAR_STRING:
convert_to_string_ex(&stmt->param.vars[i]);
stmt->stmt->params[i].buffer = Z_STRVAL_PP(&stmt->param.vars[i]);
stmt->stmt->params[i].buffer_length = strlen(Z_STRVAL_PP(&stmt->param.vars[i]));
break;

php-5.0.5/ext/mysqli/mysqli_api.c:574

This line is the problem, you can not use strlen to read the length of binary data, or this convert_to_string_ex() function destroys the data.

Kind regards

Florian Engelhardt

Georg, see the feedback.

Note: with the PDO it is working as expectet, but we can not use software that is still in a beta stadium.

Is there someone working on the bug, i havent heard anything for a couple of days now.

Z_STRLEN_PP() macro does not use the strlen() function. It's a macro to access the real length from the zval** (PP). So, from what I see it should work correctly. PHP reads the file and is \0 aware so the length in the zval that represents the string should be ok.
I have done a test and for me it seems to work ok. See the md5() hash of what's in the column. Just mysql cmdline client does not show the whole string but stops at the \0. Try with the function LENGTH() and it will work (shows 8 for me).

mysql> create table blob_test (a mediumblob);
Query OK, 0 rows affected (0.19 sec)
-----------------------------------------------------
php -r '
$c=new mysqli("127.0.0.1", "root","");
var_dump($c);
$s=$c->prepare("INSERT INTO test.blob_test VALUES(?)");
$v="aaaa\0bbb";
$s->bind_param("s",$v);
var_dump($s->execute(), $s->execute());'

-------------------------------------------------------

mysql> select md5("aaaa"), md5("aaaa\0bbb"), md5(a), a from blob_test\G
*************************** 1. row ***************************
     md5("aaaa"): 74b87337454200d4d33f80c4663dc5e5
md5("aaaa\0bbb"): f04bbe8400c631e6bab90d30900ccc69
          md5(a): f04bbe8400c631e6bab90d30900ccc69
               a: aaaa
*************************** 2. row ***************************
     md5("aaaa"): 74b87337454200d4d33f80c4663dc5e5
md5("aaaa\0bbb"): f04bbe8400c631e6bab90d30900ccc69
          md5(a): f04bbe8400c631e6bab90d30900ccc69
               a: aaaa
2 rows in set (0.00 sec)

Well not bogus. This is fixed in the upcoming 5.1.0 . AFAIK there will be no release in the 5.0 branch after 5.0.5 where the problem exists.

Thanks a lot, i tried it now again with the latest cvs and it is working. I hope 5.1 will be stable soon.
Kind Regards

Florian Engelhardt