如何使用codeigniter和mysql获取单个值 - How to get a single value using codeigniter and mysql

How to get a single value using codeigniter and mysql

我需要使用此代码从数据库中获取service_price字段。

public function get_service_price($id) { 
 $this->db->select('*');
  $this->db->from('service');
    $this->db->where('id', $id);
    $query = $this->db->get('service');
    return $query->row('service_price');  
}

这里我把这个函数叫做函数。

 public function vat($vat=14.5)
 {
  $id = $this->uri->segment(4);
  $data['service_price'] = $this->service_model->get_service_price($id);
  $price_with_vat=0;
  $price_with_vat = $data + ($vat*($data/100));
  //$price_with_vat=78.005;
  $price_with_vat = round($price_with_vat, 2);
  $this->load->view('admin/service/vat', $price_with_vat);
  }

有一些错误。请帮助我

要获得第一行，请使用以下

$query = $this->db
->where('id', $id);
->get('service');
$firstRow = $query->first_row();
return $firstRow->service_price;

将此代码用于您的模型：

  public function get_service_price($id) { 
    $this->db->select('service_price');
    $this->db->from('service');
    $this->db->where('id', $id);
    $query = $this->db->get();
    return $query->row();  
 }

在模型中

public function get_service_price($id) {
    $query = $this->db->query("SELECT * FROM service WHERE id='$id'");
    $result = $query->result_array();
    return $result;
}

控制器内

$id = $this->uri->segment(4);
$data['service_price'] = $this->service_model->get_service_price($id);
$price_with_vat=0;
$price_with_vat = $data[0]['table_field_name'] + ($vat*($data[0]['table_field_name']/100)); //$price_with_vat=78.005;
$price_with_vat = round($price_with_vat, 2);
$this->load->view('admin/service/vat', $price_with_vat);

在视图

foreach ($service_price as $new_service_price)
{
    echo $new_service_price['table_field_name'];//exapmle echo $new_service_price['service_price']
}