And, again, however, for whatever reason, although it's reading full length
of image file into variable, for whatever reason, it's only saving like 64Kb
of data to server - no errors being generated, etc., so assume there's some
or other automatic limit can't find cause/mention of/for, etc.
St
Ok, and think now figured out cause of issue with binding etc. - local mySQL
server was set to max_packet_length = 1M
And, that's 1Mb, so set it to match production server value of 999M, and
then, the following code works - seems like you should assign value to
parameter variable after binding
hi oli,
i can confirm this if i use following command.
one download one 500
[download.cmd]
"C:\Program Files (x86)\GnuWin32\bin\wget.exe" --limit-rate=4
http://127.0.0.1/index.php
did you find any solution?
regards
Hi List,
i installed a blank Windows Server 2012 Standard, added Role IIS &
Also, BTW, if I leave out the blob/binary data field, and use all of that
test code, apart from the send_long_data() call, it works fine with integer
and varchar fields.
Stay well
Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'
- Original Messa
And, here's the current test code:
//start code
$f = fopen("./candles.png", "rb");
$fB = fread($f, filesize("./candles.png"));
fclose($f);
$b = NULL;
$stmnt = $mysqliObj->prepare("update tbl_mysqli_test set b_test = ? where id
= 1;");
$stmnt->bind_param("b", $b);
$stmnt->send_long_data(0, $fB);
Ok, even when trying to use the mysqli_statement->bind_params() and
mysqli_statement->send_long_data() to pass larger blob data chunks through,
I am still hitting a form of timeout - from the mysqli_statement->errorno,
and error string:
["errno"]=> int(2006)
["error"]=> "MySQL server has gone a
Thanks - looks pretty much exactly what I want to try achieve, so will try
modd'ing my code/script and see if works...
Also nice to maybe use the actual parameter binding for a change instead of
just building up sql statement strings using sprintf() etc. - know better
practice anyway.
Stay w
hi!
On Mon, Aug 12, 2013 at 11:24 PM, Jacob Kruger wrote:
> What with trying to store image data in mySQL database, I am saving the
> results of fread() function carried out using the file handle returned from
> fopen(), with the "rb" argument to tell it the file is for binary reading.
>
> Eith
