Part of the EllisLab Network
x
 
Create New Page
 View Previous Changes    ( Last updated by CI TaMeR )

db to table

Category:Help -> TipsAndTricks
Category:Table

Updating my contributions on the wiki has become a nightmare.
Please check my svn at google for the latest revisions:
http://code.google.com/p/tamer/
CI_TaMeR SVN

I feel we don’t have enough sample code so here is one from me on how to get stuff from the database and feed it in to a table:

function index()
    
{
        $query
= $this->db->getwhere('Ticket', array('uid' => $this->uid));
        if (
$query->num_rows() > 0)
        
{
            
foreach($query->result_array() as $k => $s):
                
$tbresult[$k] = $s;
            endforeach;
            
// Remove id fields
            
$tbresult = $this->fun->unsetids($tbresult);
            
$this->load->library('table');
            foreach(
$tbresult as $row):
            
$v = $row['Ticket No'];
            
$row['Ticket No'] = anchor('ticket/view/'.$v,$v);
                
$this->table->add_row($row);
            endforeach;            
            
$this->table->set_heading(array_keys($row));
            
$this->tpl['body'] = $this->table->generate();
            
$this->table->clear();

        
}

        $this
->load->view('layout/blank', $this->tpl);
    
}

And this is what it looks like unformatted. You can use css to change the look
9c95cea1f4aff0fab8c8b5a2454d4ee3

Categories: