Re: Next question about data output...<smile>

Production server says following about version:
PHP Version 5.3.3-7+squeeze16

My local machine is running on XAMPP, with PHP 5.3.5.

Let me try out the memory_get_usage() [1] as well to see if can find out how 
much memory is being used up, when, and by what part of process.

FWIW, here are the 3 pieces of exact code:

//requesting page:
if (isset($_GET["id"])) {
require("../imageManipulation.php");
require("../template.php");
$templ = new template  ($_GET["id"]);
$templ->renderTemplate();
}//end of checking for querystring ID
exit;

//renderTemplate function in template class, inside template.php
public function renderTemplate($sDisposition="inline") {
if ($this->iID>0) {
$im = new image_manipulation;
$im->mysqliObj = $this->mysqliObj;
$imgOut = $im->dbGetImage("tbl_budget_templates", "b_image", $this->iID);
if (!(is_null($imgOut))) {
  imagepng($imgOut, $this->sTempPath . "temp.png");
$sSize = strval(filesize($this->sTempPath . "temp.png"));
unlink($this->sTempPath . "temp.png");
header('HTTP/1.1 200 OK', True, 200);
header('Content-Type: image/png');
header('Content-Disposition: ' . $sDisposition . '; 
filename="template.png"');
header('Content-Transfer-Encoding: binary');
header('Content-Length: ' . $sSize);
imagepng($imgOut);
imagedestroy($imgOut);
} else {
echo NULL;
}//end of checking if $imgOut != NULL
}//end of checking if iID>0
}//end of renderTemplate function

//and, dbGetImage function from image_manipulation 
class-imageManipulation.php
function dbGetImage($sTableName, $sField, $iID) {
if (!is_null($this->mysqliObj)) {
$sSQL = sprintf("select %s from %s where id = %s;", $sField, $sTableName, 
$iID);
$stmnt = $this->mysqliObj->prepare($sSQL);
$stmnt->execute(); //think this is command/action triggering issue
$stmnt->bind_result($bOut);
$stmnt->fetch();
$stmnt->close();
$imgOut = imagecreatefromstring($bOut);
unset($bOut);
return $imgOut;
imagedestroy($imgOut);
} else {
return NULL;
}
}//end of dbGetImage function

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message ----- 
From: "Sascha Meyer" <[email protected]>
To: "Jacob Kruger" <[email protected]>
Sent: Friday, August 16, 2013 8:57 AM
Subject: Aw: [PHP-WIN] Next question about data output...<smile>


> Good morning Jacob,
>
> could you check if memory has been eaten up before the mysqli_statement is 
> executed? memory_get_usage() [1] could help in that case. Are you using 
> different PHP versions on your local dev machine and on the production 
> server?
>
> Best regards,
>
> Sascha
>
> [1] http://php.net/manual/en/function.memory-get-usage.php
>
>> Gesendet: Freitag, 16. August 2013 um 08:42 Uhr
>> Von: "Jacob Kruger" <[email protected]>
>> An: [email protected]
>> Betreff: [PHP-WIN] Next question about data output...<smile>
>>
>> On my development, windows machine, the memory_limit iniValue is set to 
>> 128M, and on the production server - think linux box, it's set to 1280M, 
>> but, the bit of script to render an image from database as image resource 
>> to browser, works fine on my machine, but, on server, the following error 
>> occurs:
>> PHP Fatal error: Allowed memory size of 1342177280 bytes exhausted (tried 
>> to allocate 4294967296
>>
>> According to server log, it seems to be happening on the line where the 
>> mysqli_statement tries to execute the query to retrieve a longblob value 
>> of 2.1Mb, but anyway.
>>
>> I am making sure try to destroy any image resources, etc., am closing 
>> statement object after executing it, etc. - and there aren't really any 
>> recursive loops being executed, but, just a page instantiating an 
>> instance of a wrapper class, which then refers to  the imageManipulation 
>> object, to then pull the images data out of the DB - thoughts?
>>
>> TIA
>>
>> Jacob Kruger
>> Blind Biker
>> Skype: BlindZA
>> '...fate had broken his body, but not his spirit...'
>>
> 


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