[eluser]cesarius[/eluser]
Hello!
Im a newbie in ci and trying to do my first app...
Im looking for a way to show some records from database in a table, ut i can not get how to do this... verithing that ive tryed shows me only the last ecord and thats all/// here is my code - maybe somebody could help me?
Controller
Code:
<?PHP
class Base extends Controller {
function base(){
parent::Controller();
$this->load->library('session');
$this->load->library('basecl');
$this->load->helper('form');
$this->load->helper('url');
$this->load->database();
}
function index()
{
return $this->mainpage();
}
function mainpage(){
$sql = 'SELECT zid, zname,zdate, zstatus,zchangedate FROM z_mainbase where zauthor="www" order by zid';
$query = $this->db->query($sql);
foreach ($query->result_array() as $row)
{
$row['zid'];
$row['zname'];
$row['zdate'];
$row['zstatus'] = $this->basecl->statustype($row['zstatus']);
$row['zchangedate'];
}
$this->load->view('baseview', $row);
}
}
?>
ibrary
Code:
<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Basecl {
var $object;
function Basecl(){
$this->object =& get_instance();
$this->object->load->database();
}
function statustype($statusidname){
$sql = 'Select zstname from z_status where zstatusid= '.$statusidname.'';
$query = $this->object->db->query($sql);
if ($query->num_rows() == 1){
$row = $query->row();
return $row->zstname;
} else {
return 'error';
}
}
}
?>
and view
Code:
<html>
<table width = 100% celpadding = 0 cellspasing = 0>
<tr>
<td align = center text-align = center><h1>Система подачи заявок в отдел ИТ.</h1><td>
</tr>
<tr>
<td><h2>Поданные заявки:</h2></td>
</tr>
</tr>
<tr>
<td>
<table width = 100% cellpadding = 0 cellspacing = 0 style="border:2px solid #c0c0c0;background:#F5F4EA">
<tr>
<td width = 70px border = 0 style="border-right:1px solid #c0c0c0;border-bottom:2px solid grey;background:blue"><b>ID</b></td>
<td border = 0 style="border-right:1px solid #c0c0c0;border-bottom:2px solid grey;background:blue"><b>Краткое описание</b></td>
<td width = 100px border = 0 style="border-right:1px solid #c0c0c0;border-bottom:2px solid grey;background:blue"><b>Добавлено</b></td>
<td width = 80px border = 0 style="border-right:1px solid #c0c0c0;border-bottom:2px solid grey;background:blue"><b>Статус</b></td>
<td width = 100px border = 0 style="border-right:1px solid #c0c0c0;border-bottom:2px solid grey;background:blue"><b>Изменено</b></td>
<td width = 60px style="border-bottom:2px solid grey;background:blue"> </td>
</tr>
<tr>
<td width = 70px border = 0 style="border-bottom:1px solid grey;border-right:1px solid #c0c0c0"><?= $zid ?></td>
<td border = 0 style="border-bottom:1px solid grey;border-right:1px solid #c0c0c0"><?= $zname ?></td>
<td width = 100px border = 0 style="border-bottom:1px solid grey;border-right:1px solid #c0c0c0"><font size=1><?= $zdate ?></font></td>
<td width = 80px border = 0 style="border-bottom:1px solid grey;border-right:1px solid #c0c0c0"><?= $zstatus?></td>
<td width = 100px border = 0 style="border-bottom:1px solid grey;border-right:1px solid #c0c0c0"><font size=1><?= $zchangedate ?></font></td>
<td width = 60px style="border-bottom:1px solid grey;"> </td>
</tr>
</table>
</td>
</tr>
</table>
</html>
Thanks for you help.
P.s: Sorry for my bad english - im russian...