+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: oci8_result.php error (/showthread.php?tid=28711)
oci8_result.php error - El Forum - 03-19-2010
[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 155This 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;
}
?>sorry for my bad english
oci8_result.php error - El Forum - 03-19-2010
[eluser]phenom[/eluser]
when i restart my computer
then i run it again
this error message appear with different line
Code:
Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 42 bytes) in C:\xampp\htdocs\pmk120\system\database\drivers\oci8\oci8_result.php on line 220oci8_result.php error - El Forum - 03-21-2010
[eluser]phenom[/eluser]
help me please
oci8_result.php error - El Forum - 03-22-2010
[eluser]kgill[/eluser]
http://lmgtfy.com/?q=php+Fatal+error:+Allowed+memory+size+of
The bigger question here is how much data are you pulling down in the result-set that you're eating through 32MB...
oci8_result.php error - El Forum - 03-22-2010
[eluser]phenom[/eluser]
so, the problem is the size of data that bigger than 32MB, isn't it?
sorry for my bad english