[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