如何在代码点火器的关联数组中访问单个值

Question

这是我的控制器和模型。

请帮助我查看页面abc以在表字段中显示特定列。

public function abc()
{
$n=$this->uri->segment(3);
$svc['id'] =$this->Admin_model->getallserv($n);
$this->load->view('abc',$svc);
}
public function getallserv($n)
{
$sql = "select * from services where id=$n";     
$query = $this->db->query($sql);   
return $query->result();
}

Answer 1

• 将$query->result()更新为$query->row_array()
• 那么结果会像array('column_name' => 'value','column_name' => 'value'.........)
• 分配给$svc，在视图中可以访问$svc->column_name

法典：

public function abc()
{
$n=$this->uri->segment(3);
$svc =$this->Admin_model->getallserv($n);
$this->load->view('abc',$svc);
}

public function getallserv($n)
{
$sql = "select * from services where id=$n";     
$query = $this->db->query($sql); 
return  $query->row_array();
}