Re: Performance/handling limit on mysqli_real_escape_string() function?

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 Message ----- 
From: "Jacob Kruger" <[email protected]>
To: <[email protected]>
Cc: "Pierre Joye" <[email protected]>
Sent: Tuesday, August 13, 2013 5:45 PM
Subject: Re: [PHP-WIN] Performance/handling limit on 
mysqli_real_escape_string() function?


> 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);
> $stmnt->execute();
> var_dump($stmnt);
> //end code
>
> And, the results of the error it outputs, and the results of the var_dump 
> function are the following:
>
> Warning: Error while sending STMT_EXECUTE packet. PID=3372 in 
> C:\xampp\htdocs\mysqli\bind.php on line 21
> object(mysqli_stmt)#2 (9) { ["affected_rows"]=> int(-1) ["insert_id"]=> 
> int(0) ["num_rows"]=> int(0) ["param_count"]=> int(1) ["field_count"]=> 
> int(0) ["errno"]=> int(2006) ["error"]=> string(26) "MySQL server has gone 
> away" ["sqlstate"]=> string(5) "HY000" ["id"]=> int(1)
>
> Jacob Kruger
> Blind Biker
> Skype: BlindZA
> '...fate had broken his body, but not his spirit...'
>
> ----- Original Message ----- 
> From: "Jacob Kruger" <[email protected]>
> To: <[email protected]>
> Cc: "Pierre Joye" <[email protected]>
> Sent: Tuesday, August 13, 2013 9:28 AM
> Subject: Re: [PHP-WIN] Performance/handling limit on 
> mysqli_real_escape_string() function?
>
>
>> Thanks - looks pretty much exactly what I want to try achieve, so will 
>> try modd'ing my code/script and see if works...<smile>
>>
>> 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 well
>>
>> Jacob Kruger
>> Blind Biker
>> Skype: BlindZA
>> '...fate had broken his body, but not his spirit...'
>>
>> ----- Original Message ----- 
>> From: "Pierre Joye" <[email protected]>
>> To: "Jacob Kruger" <[email protected]>
>> Cc: "php-windows" <[email protected]>
>> Sent: Tuesday, August 13, 2013 9:08 AM
>> Subject: Re: [PHP-WIN] Performance/handling limit on 
>> mysqli_real_escape_string() function?
>>
>>
>> hi!
>>
>> On Mon, Aug 12, 2013 at 11:24 PM, Jacob Kruger <[email protected]> 
>> 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.
>>>
>>> Either way, for example, this specific image file is a 2.1Mb PNG file, 
>>> and mySQL server on my local, windows development machine seems to lock 
>>> up roundabout when I tell it to carry out the 
>>> mysqli_real_escape_string() function on the value of the variable that 
>>> now contains the data read from the physically uploaded file, and just 
>>> wondering if this could be something like a process overload, etc., and 
>>> whether should just try taking out the string real escaping for now, or 
>>> whether that's likely to cause problems, or should I try something like 
>>> splitting the file's data into more manageable size chunks, carry out 
>>> the string escaping on those chunks one at a time, with even a possible 
>>> form of pause inbetween, and then re-append them together before writing 
>>> them to the database, or should I maybe just implement at least a form 
>>> of file size limit, which might be an issue if the user will insist on 
>>> certain image sizes, resolutions, etc. etc.?
>>>
>>> Thoughts/suggestions?
>>
>> Not really windows specific, php-database could fit better for this
>> question but here is what you should do:
>>
>> https://blogs.oracle.com/oswald/entry/php_s_mysqli_extension_storing
>>
>> Cheers,
>> -- 
>> Pierre
>>
>> @pierrejoye | http://www.libgd.org
>>
>>
>> -- 
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> 


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