Docs Database Delete

Database : Delete (CRUD)

  • do_delete
    This query method directive is the top level sql setter method for deleting data from database fields. It defines sql select queries that can be executed later.

    Method 1 : set delete query 
      $db->do_delete('from users');


    Method 2 : chain controller 
      $db->do_delete('from users')->where('username = ?', ['Felix']);
    The method above is used to set simple sql queries. Method where() should only be chained once on the do_delete() operator in the predefined order.
    Example 1 : Executing predefined query 
      $db->do_delete('from users')->where('username = ?', ['Felix']);

  $db->delete();
    Deleting from database comes in different formats and the query() method can be applied when handling complex delete queries.
    Example 2 : Deleting with query method
      $db->query('delete * from users')->delete();