phpmysqlcodeignitersql-deletewhere-in

How to create a DELETE ... WHERE column IN () query with CodeIgniter?

How can I use my passed-in $events array in a DELETE WHERE IN query in CodeIgniter?

public function remove_events(array $events): void
{
    $sql = "DELETE FROM events WHERE event_id IN $events";
    $query = $this->db->query($sql);
}
Solution

  • if $event is a single value then you must use

    $sql = "delete from events where event_id = $events";

    Or if it is an array

    $sql = "delete from events where event_id in (".implode(',', $events).") ";