Welcome Guest, Not a member yet? Register   Sign In
oci8_result.php error
#1

[eluser]phenom[/eluser]
I've got this problem when i run the controller
Code:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 48 bytes) in C:\xampp\htdocs\pmk120\system\database\drivers\oci8\oci8_result.php on line 155

This is my model
Code:
<?php
class tmasteru extends Model
{
    function __construct()
    {
        parent::Model();
    }
    
    function idle()
    {
        $sql = 'SELECT  b.urkpknl urkpknl,
                          a.kd_brg kdbrg,
                        b.urkpknl nmkpknl,
                        d.no_kib nokib,
                        d.surat1 jnspemilikan,
                        d.unit_pmk unitpemakai,
                        d.kd_kec kec,
                        d.kd_kab kdkab,
                        a.kuantitas luas,
                        a.tgl_perlh tglperl,
                        a.rph_aset biaya,
                        d.rphnjop njop,
                        d.status status
                FROM    t_masteru a,
                        t_kpknl   b,
                        t_sskel   c,
                        t_ktnh    d
                WHERE   a.kdkantor = b.kdkpknl    AND
                        a.kd_brg   = c.kd_brg   AND
                        a.kd_brg   = d.kd_brg   AND
                        a.no_aset  = d.no_aset  AND
                        d.status = \'HAK MILIK\'  OR
                        d.status = \'Hak Milik\'  OR
                        d.status = \'hak milik\'      
                        ';        
        $query = $this->db->query($sql);
        return $query->result;
    
    }
}

This is my controller
Code:
<?php
class Upk3101 extends Controller
{
    function __construct()
    {
        parent::Controller();    
    }
    
    function index()
    {
        $this->load->model('tmasteru');
        $query = $this->tmasteru->idle();
        $this->load->view('upk3101');
    }
}

and This is my view
Code:
<?php
    foreach ($query as $row)
    {
        print $row->urkpknl;
        print $row->kdbrg;
    }
?>
help me please...
sorry for my bad english


Messages In This Thread
oci8_result.php error - by El Forum - 03-19-2010, 01:05 AM
oci8_result.php error - by El Forum - 03-19-2010, 01:15 AM
oci8_result.php error - by El Forum - 03-21-2010, 06:37 PM
oci8_result.php error - by El Forum - 03-22-2010, 07:12 AM
oci8_result.php error - by El Forum - 03-22-2010, 05:56 PM



Theme © iAndrew 2016 - Forum software by © MyBB