How to extend php memory limit?

Question

I want to have a button that on click it generates a pages similiar to the previous one (where the button is) and automatically sends the user to the print option page. This page has data from a sybase database which i am getting it via odbc.

The problem is, when trying to generate the print page, i can't get the page because of an "out of memory problem".

ERROR:

Fatal error: Out of memory (allocated 392167424) (tried to allocate 387973888 bytes) in C:\xampp\htdocs\CodeIgniter\Samsic\application\models\Pagamentos_model.php on line 83

Yes, i saw most of the similar questions on StackOverflow about "out of memory(..)trying to allocate (..)".

This one is different because none of the answers given on similiar questions worked here!

I have tried:

ini_set('memory_limit', '-1');

ini_set('memory_limit', '128M');

None of this worked.

I'm using MVC and this is the code im using:

Model:

  <?php
    ini_set('memory_limit', '-1');



        class Pagamentos_model extends CI_Model {
        public function imprimir($ano,$codigo){
                require(APPPATH.'libraries/odbc_conn.php');
                $query = odbc_exec($db, 'Select * from GP_Vw_Valores_Pagos where Ano='.$ano.' and Codigo='.$codigo.' order by CD');
                $row=odbc_fetch_array($query);
                $output= '<h1 style="text-align: center;"> Pagamentos'.$ano.' </h1>  <table class="table" style="width: 100%; margin-bottom:40px; margin-top: 15px; ">
              <thead>
                <tr style="font-size: 1em;margin-bottom: 15px;text-align: center;">
                  <th scope="col">CD</th>
                  <th scope="col">Descrição</th>
                  <th scope="col">Tipo</th>
                  <th scope="col">Janeiro</th>
                  <th scope="col">Fevereiro</th>
                  <th scope="col">Março</th>
                  <th scope="col">Abril</th>
                  <th scope="col">Maio</th>
                  <th scope="col">Junho</th>
                  <th scope="col">Julho</th>
                  <th scope="col">Agosto</th>
                  <th scope="col">Setembro</th>
                  <th scope="col">Outubro</th>
                  <th scope="col">Novembro</th>
                  <th scope="col">Dezembro</th>

                </tr> 
                </thead>';

                while($row){
                    $output .= '<tr style="text-align: center;">
                <td>' .$row["CD"].'</td>
                  <td>'.iconv("CP850", "UTF-8", $row['Descricao']).'</td>
                  <td>VI</td>
                  <td>' .number_format($row['Vl01'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl02'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl03'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl04'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl05'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl06'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl07'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl08'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl09'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl10'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl11'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Vl12'] , 2, '.', '').'</td>
                       </tr>
                       <tr style="text-align: center;">
                <td></td>
                  <td></td>
                  <td>QT</td>
                  <td>' .number_format($row['Qt01'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt02'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt03'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt04'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt05'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt06'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt07'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt08'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt09'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt10'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt11'] , 2, '.', '').'</td>
                  <td>' .number_format($row['Qt12'] , 2, '.', '').'</td>
                       </tr>  ';
                }

                return $output;


            }
        }
?>

Controller :

<?php

defined('BASEPATH') OR exit('No direct script access allowed');

class Pagamentos extends CI_Controller {

    function __construct(){
        parent::__construct();
        $this->load->model('Pagamentos_model', '', TRUE);
        $this->load->library('session');
    }


    public function imprimir(){
        $ano =  addslashes($this->session->anop);
        $codigo = addslashes($this->session->codigo);
        $resultado = $this->Pagamentos_model->imprimir($ano,$codigo);
        $data['resultado'] = $resultado;
        $this->load->view('imprimirTemplate',$data);


    }



}

View (template) :

<!DOCTYPE html>
<html>
<head>
    <title></title>

    <style>
    body{
        font-size: 0.9em;
    }
    .container{
        width: 100%;
        height: 100%;
    }

    @media print {
        @page { margin: 20px; }
        body { margin: 1.6cm; }
    }
    table, th, td {
        border: 1px solid black;
    </style>
</head>
<body onload="window.print()">
    <?php $this->load->view('header'); ?>
    <?= $resultado; ?>

</body>
</html>

At this point, i don't know what to try next, if anyone could help i would appreciate a lot!

Answer 1

If the query and fetch are successful then $row will not be false and while($row) will loop infinitely. You want to remove this:

$row=odbc_fetch_array($query); 

And then add it to your loop:

while($row=odbc_fetch_array($query)) {