mysql - 使用 codeigniter 进行条件插入

Question

我想在表中插入行(如果尚不存在)，否则更新它。如何在 codeignitor 中重新表述此查询？

插入 fa_seat_details (mall_id, cineplex_name, audi_number, number_of_rows, number_of_columns) VALUES(15, "PVR", 1, 18, 16) ON DUPLICATE KEY UPDATE cineplex_name = "some name", number_of_rows=10, number_of_columns =20;

这是表结构，

+--------------------+-------------+-----+-- ---+---------+----------------+
|领域|类型 |空 |关键|默认 |额外 |
+--------------------+-------------+------+-----+-- -------+----------------+
|编号 |整数(11)|否 |优先原则 |空|自动增量 |
|商城 ID |整数(11)|否 |乘法 |空 | |
| cineplex_name | 电影院名称varchar(64) | varchar(64) |否 | |空 | |
|奥迪号码 |整数(11)|否 | |空 | |
|行数 |整数(11)|否 | |空 | |
|列数 |整数(11)|否 | |空 | |
+--------------------+-------------+------+-----+-- -------+----------------+

Answer 1

试试这个

public function FunctionName($value)//pass data to here
{
    $query = $this->db->query("SELECT * FROM category WHERE aa = 'bbbbb'");
    $result = $query->result_array();
    $count  = count($result);

    if (empty($count)) {

        # insert code
        $data = array(
           'title' => 'My title' ,
           'name' => 'My Name' ,
           'date' => 'My date'
        );

        $this->db->insert('mytable', $data); 
    }
    elseif ($count >1 ) {
        # Having Multiple data on it
        echo "Wrong data selected";
    }
    else{

        #update code
        $data = array(
           'title' => $title,
           'name' => $name,
           'date' => $date
        );

        $this->db->where('id', $id);
        $this->db->update('mytable', $data); 
    }
}