Model

This file defines the Model class, which serves as the foundation for representing and interacting with data in your MVC application. It provides various methods for database operations, including:

Create a new file named like Contacts.php in the App/Models directory.

The changes made are:

• Removed unnecessary phrases like "this pest" and "this example."

• Replaced "at" with "in" for clarity when referring to a directory.

<?php

class Contact extends Model {

  public static $_Table = 'Contacts';

  public static $_ID = 'ID';

  public static $_Trash = 'Deleted'; // if required, Int 1 default 0

  public static $_TrashAt = 'DeletedAt'; // if required, Int 11 default null

}

?>

• 1. Establishing a connection to the database.

  2. Retrieving model-specific information like table name and primary key.

  3. Executing SQL queries and fetching results.

  4. Performing CRUD (Create, Read, Update, Delete) operations on data.

Properties

• private static $DB: Stores an instance of the database connection class.

Methods

• DB(): Returns the database connection object.

• Fetch($Query): Executes a provided SQL query and returns the fetched data.

• Sql($Query): (Placeholder) Intended for executing SQL queries with potential result handling (implementation details depend on your database class).

• Insert($Data): Inserts a new record into the database table. Essentially a wrapper for Save().

• Create(...$args): Creates a new record using a variadic parameter list. Likely replicates Save().

• Save($Data): The core function for data persistence. Saves a new record or updates an existing one based on the provided data.

• Update($Data, $IDs = null, $Where = []): Updates existing records based on data and either IDs or a WHERE clause.

• Delete($IDs = null, $Where = []): Deletes records from the database table. Allows deletion by IDs or using a WHERE clause.

• SoftDelete($IDs = null, $Where = []): Performs soft deletion by marking records as "deleted" in the database (assumes a dedicated "trash" column exists).

• Remove(...$args): Replicates the functionality of Delete().

• Select($S = [], $W = '', $OrderBy = ''): Selects records from the database table with optional filtering and sorting.

• All($S = [], $OrderBy = '', $Deleted = 0): Fetches all records from the associated table, optionally filtering by conditions and excluding deleted records.

• ID($ID = null, $S = []): Fetches a specific record by its ID.

• IDs($IDs = null, $S = []): Fetches multiple records based on an array of IDs.

Usage

Inherit from the Model class to create specific model classes representing your database tables. Each model class should implement the abstract methods (PrimaryKey()) and may optionally override functionalities like TrashKey() and TrashAtKey() for soft deletion handling.