Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.


Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

How to show a database table


4 Posts   1800 Views


27 March 2008 at 11:50am Community Member, 10 Posts

Hello to everyone.
I created those class

class ProductorManager extends Page
static $db = array('Percentage'=>'float'
static $has_one = array('id_productor'=>'Member'

public function Productors()
return DataObject::get("ProductorManager ");

class ProductorManager _Controller extends Page_Controller

and i've the table setted up, but i cannot retrieve datas from them. i thinks function Productors() is correct, but something don't work.
I want to show Percentage and the complete productor's name fetched by Member's tables

I dont know if i want clear about the explaination.
Thanks to everyone.



27 March 2008 at 1:26pm Community Member, 25 Posts

you probably want to put that function in the Page_Controller, for starters.

what does your template code look like?


27 March 2008 at 10:45pm Community Member, 10 Posts

Template page look like in this way temporarily

<div class="body">
<% include SideBar %>
<div style="clear:left">

<% if Productor %>
<% control Productor %>
$FirstName .<br />
<% end_control %>
<% else %>
<div class="message">No productors found</div>
<% end_if %>

First I put Productors() inside the Controller Class, but didn't work.
I want to show each productor's name and i don't know where i've made a mistake.

thank you very much


28 March 2008 at 3:24am (Last edited: 28 March 2008 4:07am), Community Member, 10 Posts

I solved that problem using a DataObject-derivated class.

class Produttori extends DataObject
static $db = array('Percentuale'=>'float');
static $has_one = array('Produttore'=>'Member');

Thanks you