php - 在 codeigniter 上的选择查询中选择错误

Question

我是 codeigniter 的新手。当我使用这个查询时

$last_insert_id =$this->db->insert_id();
    $name = 'Auto loan';
    $q = $this->db->select('id')->where('name_of_loan',$name)->limit(1)->get('loan_type');

$data_batch = array(
'borrower_id' => $last_insert_id,
'loan_type_id'=> $q,

);
//$this->db->set('loan_type_id', $query);
$this->db->set('created_on', 'NOW()', FALSE);
$this->db->set('updated_on', 'NOW()', FALSE);
$this->db->insert('loan_application',$data_batch);

我收到以下错误: 您的 SQL 语法有误；检查与您的 MySQL 服务器版本对应的手册，了解在第 1 行的 ')' 附近使用的正确语法

Answer 1

试试这个

$last_insert_id =$this->db->insert_id();
$name = 'Auto loan';
$query = $this->db->query("SELECT * FROM loan_type WHERE name_of_loan = '$name' ");
$result = $query->result_array();
$q = $result[0]['id'];

$data_batch = array(
    'borrower_id' => $last_insert_id,
    'loan_type_id'=> $q,        
);