Geek asks and answers

The allowed memory size is 67108864 bytes.

I must have read all the related posts here, but still can't figure out why this is happening.

My code is:

$stmt = $this->db->stmt_init();
        $stmt->prepare("SELECT Table1.id,Name,type,text,fname,lname FROM Table1, Table2 WHERE Table1.email = Table2.email AND type='text' AND Table1.Id=?");
        $stmt->bind_param("i", $id);
        $stmt->bind_result($legTxtId,$legTxtName, $legTxtType, $legTxtText, $legTxtFname, $legTxtLname);
        $stmt->execute();
        $results = array();
        while($stmt->fetch())
        {
            $results[] = array(
                    'legTxtId' => $legTxtId , 'legTxtName' => $legTxtName , 'legTxtType' => $legTxtType , 
                    'legTxtText' => $legTxtText , 'legTxtFname' => $legTxtFname ,
                    'legTxtLname' => $legTxtLname );
        }
        $stmt->close();
        return $results;

Now I use the same code in another function that is called before, and it works fine even if it returns another field.

This one, in particular, returns only 1 line with simple short text (without photos or anything else), so it should not cause an error, which is definitely less than 64 MB.

Can anyone understand what the problem is?

+2
source share
3 answers

As discussed in another question, there seem to be two solutions:

1) Switch to mysqlnd as it does not show the same error.

Yum PHP (, Amazon ec2), , LAMP :

sudo yum install php-mysql php php-xml php-mcrypt php-mbstring php-cli mysql httpd 


sudo yum install php-mysqlnd php php-xml php-mcrypt php-mbstring php-cli mysql httpd

2) store_result, use_result, .

mysqlnd, , , , php-mysql (, MySQL PHP) PHP 5.4.0 .

+1

while ?

0

:

// ...
$stmt->prepare(...);
$stmt->bind_param(...);

$stmt->execute();
$stmt->store_result();

$stmt->bind_result(...);
// ...
0

More articles:


All Articles