Присоединяйтесь к 03 Таблице в базе данных CodeIgniter ⇐ Php

[Anonymous]

с моей таблицей. < /p>

person_id serial NOT NULL,
firstname character varying(30) NOT NULL,
lastname character varying(30),
email character varying(50),
username character varying(20) NOT NULL,
"password" character varying(100) NOT NULL,
gender character varying(10),
dob date,
accesslevel smallint NOT NULL,
company_id integer NOT NULL,//Reference to table company
position_id integer NOT NULL,//Reference to table position
company_id serial NOT NULL,
company_name character varying(80) NOT NULL,
description character varying(255),
address character varying(100) NOT NULL,
< /code>

В моем контроллере < /p>

........................
// load data
$persons = $this->person_model->get_paged_list(10,0);
// generate table data
$this->load->library('table');
$this->table->set_empty(" ");
$this->table->set_heading('No', 'FirstName', 'LastName','E-mail','Company''Gender', 'Date of Birth', 'Actions');
foreach ($persons as $person){
$this->table->add_row(++$i, $person->firstname,
$person->lastname,
$person->email,
$person->company_name,
//HOW CAN I GOT THE POSITION TITLE ?,
strtoupper($person->gender)=='M'? 'Male':'Female',
date('d-m-Y',strtotime($person->dob)),
}
< /code>

Моя модель < /p>




Подробнее здесь: https://stackoverflow.com/questions/272 ... odeigniter