时间戳

首页 > 解决方案 > 1 个模型中的 2 个查询 (CodeIgniter)

php - 1 个模型中的 2 个查询 (CodeIgniter)

问题描述

如何在 1 个模型中放置 2 个查询？这是我的代码

public function declineDec($email,$desc,$prop_id,$fk_table){


        $sql = "INSERT INTO amilyar_applicant_notif (email,notif_fk_table,notif_fk_id,notif_content) VALUES (?,?,?,?)";
        $data = [$email,$fk_table,$prop_id,$desc];
        $query = $this->db->query($sql,$data);
        return $this->db->affected_rows();


        $sql2 ="UPDATE amilyar_properties SET prop_approved = 3 WHERE prop_id = ?";
            $data2 = ($prop_id);
            $this->db->query($sql2, $data2);

        // return $sql;
        return $this->db->affected_rows();

标签： phpcodeigniter

解决方案

尝试进行一些修改，如下所示：

public function declineDec($email,$desc,$prop_id,$fk_table) {
    $sql = "INSERT INTO amilyar_applicant_notif (email,notif_fk_table,notif_fk_id,notif_content) VALUES (?,?,?,?)";
    $data = [$email,$fk_table,$prop_id,$desc];
    $this->db->query($sql,$data);
    $return['insert'] = $this->db->affected_rows();

    $sql2 ="UPDATE amilyar_properties SET prop_approved = 3 WHERE prop_id = ?";
    $data2 = ($prop_id);
    $this->db->query($sql2, $data2);
    $return['update'] =  $this->db->affected_rows();

    return $return;
}

如果您有更多的代码步骤要执行，则无需returnin 。return $this->db->affected_rows();

推荐阅读