Model

m4\m4mvc\core\Model

Abstract model class is intended to be extended by all the other models.

Parameters

Name	Description
query	Holds Query Helper Instance
db	Holds database connection
credentials	DB credentials array, is static

Talking With Database

There are 4 important helper methods to run SQL queries.

1. save - insert / update / delete record

Save method has third optional argument lastInsertedId which if set to true returns last inserted id. Otherwise it returns boolean of success.

1. fetch - get single row

2. fetchAll - get array of results

3. runQuery - run the query

First 3 of them are just extending runQuery for simpler use. All of them take first 2 arguments SQL Query and Array of Parameters.

If you want to use runQuery directly you need to set third parameter type [integer].

type	description
1	Fetch All [Assoc]
2	Fetch [Assoc]
3	Create Update Delete returns boolean
4	Create Update Delete returns last inserted id

<?php
// assuming access to extendeding model instance
$this->model->save("UPDATE users SET name = :name", ['name' => 'John']);
$this->model->save("DELETE FROM users WHERE name = :name", ['name' => 'Jan']);
$this->model->fetch("SELECT * FROM users WHERE id = :id", ['id' => 251]);
$this->model->fetchAll("SELECT * FROM users");

Other core methods

image (received image , folder to upload )

[this method is experimental and will be changed or removed]

This method is storing image records in images table and it also calls Image::upload helper to upload the image.

It returns last inserted id or null if it fails.

---

countTable (table to count *, where clause, like clause)

This method counts number of records from table and you can use where or like clause to filter the results.

Returns number of rows or null.