Menu on Interior Pages

barcellos

So I created a block called menu.php and I have this code in there calling my database:

<? $this->load->library->database; $sql = "select * from fuel_page_variables, fuel_pages where fuel_pages.location like ('work%') and fuel_pages.published = 'yes' and fuel_page_variables.page_id = fuel_pages.id and fuel_page_variables.name = 'page_title' order by fuel_page_variables.value;"; $result = $this->db->query($sql); foreach($result->result() as $row){ ?> <li><a href="/<? print $row->location; ?>"> <? print $row->value; ?></a></li> <? } ?>

When I publish my file, the links from the database show, but I get two error messages...

---
Severity: Notice

Message: Undefined property: MY_Loader::$library

Filename: _blocks/menu.php

Line Number: 3

---
A PHP Error was encountered
Severity: Notice

Message: Trying to get property of non-object

Filename: _blocks/menu.php

Line Number: 3

---

I'm using Fuel version 0.9.3

admin

Use $CI instead of $this. Also, shouldn't it be $CI->load->database();

barcellos

Awsm! Changing $this to $CI worked. I also used $CI->load->database();

Here's my updated mark-up for reference:

<? $CI->load->database(); $sql = "select * from fuel_page_variables, fuel_pages where fuel_pages.location like ('work%') and fuel_pages.published = 'yes' and fuel_page_variables.page_id = fuel_pages.id and fuel_page_variables.name = 'page_title' order by fuel_page_variables.value;"; $result = $CI->db->query($sql); foreach($result->result() as $row){ ?> <li><a href="/<? print $row->location; ?>"> <? print $row->value; ?></a></li> <? } ?>

THANK YOU.

barcellos

Hello... I have another _block question. Still using 0.9.3.

When I update _blocks from the admin the changes aren't reflected on the front-end. However, when I update them in my WYSWIG, upload and update within the CMS the blocks work, but they really need to be manageable via admin.

Do I need to add a helper somewhere?

admin

Have you tried clearing the Page Cache in FUEL under the Manage area after making the change? Uploading and saving under the Blocks module in the CMS should be the same as just editing the view field contents. It will first look for a block in the CMS, and then look for a static view file.