README

Getting started

composer create-project longdhdev/project_holaframework

composer install

What new in version v1.0.9

Add dependency injection
Refactor namespace
Model improvements
Add save, softDelete, pagination, paginationWithCount functions in model
Add application class
add registerCommand and app()
Improve response and queue
php version >= 8.0

List

Router
App
Controller
Model
View
Middleware
Request
Validate request
Rules
Response
Query Builder
Relation
Shared function
Translate
Queue
Mail
Command

Router

Set up in router/web.php
Router will receive 2 parameters, 1st parameter will be url, 2nd parameter will be array including controller and function in controller

use Hola\Core\Router;
use App\Controllers\HomeController;

Router::get('/', [HomeController::class,'index']);
Router::get('/home', [HomeController::class,'index']);

Use parameters

use Hola\Core\Router;
use App\Controllers\HomeController;

// url {domain}/home/1
Router::get('/home/{id}', [HomeController::class,'index']); 

// url {domain}/home/detail/2
Router::get('/home/detail/{id}', [HomeController::class,'detail']);

Use router with prefix

  Router::prefix('home')->group(function (){
      Router::get('/', [HomeController::class,'index']);
      Router::get('/detail', [HomeController::class,'detail']);
      Router::get('/list', [HomeController::class,'list']);
  }); 
  // The path will be 
  // https://domain.com/home
  // https://domain.com/home/detail
  // https://domain.com/home/list

When you want to create another router file, you can create it in the router folder and then add the code below in router/index.php
The add() function will identify your path and the loadFile() function will load the router file you just created

use Hola\Core\ConfigRouter;
$configRouter = new ConfigRouter();
$configRouter->add('api')->loadFile('api'); // https://domain.com/api
$configRouter->add('api_v2')->loadFile('api_v2'); // https://domain.com/api_2
// or 
$configRouter->add([
    'web' => 'web',
    'api_v2' => 'api'
])->work();
// https://domain.com/web
// https://domain.com/api_v2

Parameters in controller

<?php
namespace App\Controllers;

class HomeController extends BaseController {
    public function index($id){
        echo $id;
    }
    public function detail($id){
        echo $id;
    }
}

Request and parameters in controller

<?php
namespace App\Controllers;
use Hola\Core\Request;

class HomeController extends BaseController {
    public function index(Request $request, $id){
        echo $id;
    }
    public function detail(Request $request, $id){
        echo $id;
    }
}

App

Create controller in folder app/Controllers
Create model in folder app/Models
Create view in folder app/views

Use controller

Create controller

<?php
namespace App\Controllers;
use Hola\Core\BaseController;

class HomeController extends BaseController {
    public function __construct()
    {}

    public function index(){
        echo 'index';
    }
    public function store(){
        echo 'store';
    }
}

How to create namespace in controller

File in folder app/Controllers -> namespace App\Controllers 
File in folder app/Controllers/{name_folder} -> namespace App\Controllers\{name_folder}

Run command create controller

- php cli.php create:controller NameController
// or
- php cli.php create:controller folder/folder/NameController

Use model

Create model
To create a function in the model, make it a static function
The variable $times_auto set true when you use the create(),insert(), insertLastId() function will automatically create a date with the date_created column and using the update() function will create a date with the date_updated column set false, you can turn this function off
You can change the 2 default date columns with the $date_create and $date_update variables
You may not need to declare the 3 variables $times_auto, $date_create, $date_update if you do not use them.
Run command create controller

- php cli.php create:model NameModel --table=name

<?php
namespace App\Models;
use Hola\Core\Model;

class Categories extends Model {
    protected static $tableName = 'categories';
//    protected static $times_auto = false;
//    protected static $date_create = "date_created";
//    protected static $date_update = "date_updated";
    protected static $field = [
        'id',
        'name'
    ];

    public static function index(){
        echo 'categories index';
    }
}

Use model in controller

=== use way 1 ===

public function index(){
  $category = $this->model(Categories::class)::index();
}

=== use way 2 ===

class Controller extends BaseController {
    public function __construct()
    {
        $this->model([
            Categories::class,
            Product::class
        ]);
    }
    public function listCategories(){
         $data = $this->Categories::instance()->get()->values();
         // or
         $data = $this->Categories->get()->values();
    }
    public function listProduct(){
         $data = $this->Product::instance()->get()->values();
         // or
         $data = $this->Product->get()->values();
         return $data;
    }
}

=== use way 3 ===

class Controller extends BaseController {
    public function __construct()
    {}
    public function listCategories(){
         $data = Categories::instance()->get()->values();
    }
    public function listProduct(){
         $data = Product::instance()->get()->values();
         return $data;
    }
}

Use attribute in module

Attribute in the model will include set and get functions. For example, if you want to set a column name in the table, the set and get functions will have the structure setAttribute{column_table} and getAttribute{column_table}
Example code below:

namespace App\Models;
use Hola\Core\Database;
use Hola\Core\Model;

class Categories extends Model {
    protected static $tableName = 'categories';
    protected static $times_auto = false;
    protected static $date_create = "date_created";
    protected static $date_update = "date_update";
    protected static $field = [
        'name',
        'view',
        'invalid'
    ];

    public function setAttributeName($value) {
        return json_encode($value);
    }

    public function getAttributeName($value) {
        return json_decode($value);
    }
}

Use view

Create view in folder app/views with name {name_file}.view.php
Use view controller

<?php
namespace App\Controllers;
use App\Models\Categories;
use Hola\Core\BaseController;
use Hola\Core\Request;
use Hola\Core\Response;

class HomeController extends BaseController {
    public function __construct()
    {}

    public function index(){
        return $this->render_view('name_file', ["title" => "Home"]);
    }
    // or
    public function index2(){
        return Response::view('name_file', ["title" => "Home"]);
    }
}

Using the variable in the example view in the code line above to pass the title parameter with the date value, you can declare it as follows

<!doctype html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport"
        content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
  <meta http-equiv="X-UA-Compatible" content="ie=edge">
  <!-- use -->
  <title><?=$title?></title>
  <!-- or use variable var -->
  <title><?=@var('title')?></title>
</head>
<body>

</body>
</html>

Run command create view

- php cli.php create:view name_view
// or
- php cli.php create:view folder/folder/name_view

Use Request

use Hola\Core\Request;
class Controller extends BaseController {
    public function __construct()
    {}
    public function index(Request $request){
         $name = $request->get('name');
         $name = $request->name; // or
         $name = $request->value('name');
         $file = $request->get_file('file');
         $set_file = $request->file('file'); // use set file
         $extension = $request->extension(); // get extension file
         $size = $request->size(); // get size file
         $type = $request->type(); // get type file
         $originName = $request->originName(); // get originName file
         $isFile = $request->isFile(); // check file
         $all = $request->all(); // get all data request
         $session = $request->session('name'); // get session 
         $cookie = $request->cookie('name'); // get cookie 
         $cookie = $request->headers('name'); // get headers 
         $has = $request->has('name'); // check key 
    }
}

Use validate request

=== way 1 ===

       $validate = Validation::create(
            $request->all(),
            [
                'username' => [
                    'required',
                    'number',
                ],
                'password' => [
                    'required',
                    'number',
                    'max:6',
                    'min:6'
                ],
            ]
       );

=== way 2 ===

       $validate = Validation::create(
            [
                'username' => $request->username,
                'password' => $request->password
            ],
            [
                'username' => [
                    'required',
                    'number',
                ],
                'password' => [
                    'required',
                    'number',
                    'max:6',
                    'min:6'
                ],
            ]
       );

You can return your error message with the code below

       $validate = Validation::create(
            [
                'username' => $request->username,
                'password' => $request->password
            ],
            [
                'username' => [
                    'required' => 'Username is required',
                    'number' => 'username is number',
                ],
                'password' => [
                    'required',
                    'number',
                    'max:6',
                    'min:6'
                ],
            ]
       );

Use with regex

      Validation::create([
            'username' => 'long'
        ], [
            'username' => [
                'pattern:/([0-9]+)/'=> 'You must be a number',
            ]
      ]);

Use validateRequest in controller. This validateRequest function will return an error if there are coder-identified fields. If the condition is met, the validateRequest function will return the data that the user submitted

<?php
namespace App\Controllers;
use Hola\Core\BaseController;
use Hola\Core\Request;
use Hola\Core\Response;
use Hola\Core\Validation;

class HomeController extends BaseController {
    public function __construct()
    {}

    public function index(Request $request){
        $validate = Validation::create(
            $request->all(),
            [
                'username' => [
                    'required'=>'Không để trống',
                    'number',
                ],
                'password' => [
                    'required',
                    'number',
                    'max:6' => 'Pass phải lớn hơn hoặc bằng {{password}}',
                    'min:6'
                ],
            ]
        );
        if(!empty($validate->errors())) { // show error
            return false;
        }
        $data = $validate->data(); // get data access
        
        return [
           'data_request' => $data
        ];
    }

}

Use Form Request

Command create form request

 php cli.php create:request name

When you run the command, it will gender a file {name} in the request folder. In this file, you can validate it

<?php
namespace Request;
use Hola\Core\FormRequest;

class AuthRequest extends FormRequest
{
    public function __construct() {
        parent::__construct();
    }

    public function auth() {
        return true;
    }

    public function rules()
    {
        return [
            'username' => [
               'required'=>'Không để trống',
               'number',
            ],
            'password' => [
                'required',
                'number',
                'max:6' => 'Pass phải lớn hơn hoặc bằng {{password}}',
                'min:6'
            ],
        ];
    }

    /**
     * @return string
     * This function you can return view as you want, this function can be declared or not needed
     * If you want to use this function, you must declare the auth function first
     */
    public function view_auth() {
        return 'error.index';
    }

    /**
     * @return array
     * This function you can return data as you want, this function can be declared or not needed
     * If you want to use this function, you must declare the auth function first
     */
    public function data_auth() {
        return [
            'message' => 'unauthorized',
            'code' => 403
        ];
    }
}

Rules can be used

required // check empty
number // check number
max // check max
min // check min
pattern// check with regex
boolean // check boolean
array // check array
date // check date
not_pattern // check with regex

Use response

use Hola\Core\Response;
class Controller extends BaseController {
    public function __construct()
    {}
    public function index(Request $request){
        $data = [];
        return Response::view('name_view', $data);
    }
    
    public function json(Request $request){
        $data = [];
        return Response::json($data, $status ?? 200);
    }
    public function redirectTo(Request $request){
        $data = [];
        return Response::redirectTo('/login');
    }
}

Use variable in view

<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title><?=$title ?? ''?></title> // get data
</head>

<body>
</body>
</html>

Query Builder

Get one record in model

   Categories::instance()->first()->values();

Get one record buy column with function where

   Categories::instance()->where('id','=', 1)->first()->values(); // get by id
   Categories::instance()->where('name','=', 1)->first()->values(); // get by name
   Categories::instance()->where('name','like', '%value%')->first()->values(); // get by name

Get all record in model

   Categories::instance()->get()->values();

Get all record buy column with function where

The get() function will return an object. If you want to return an array data type, you can use the getArray() function.

   Categories::instance()->where('id','=', 1)->get()->values(); // get by id
   Categories::instance()->where('name','=', 1)->get()->values(); // get by name
   Categories::instance()->where('name','like', '%value%')->get()->values(); // get by name
       
   // return data type array
   Categories::instance()->where('id','=', 1)->getArray(); // get by id
   Categories::instance()->where('name','=', 1)->getArray(); // get by name
   Categories::instance()->where('name','like', '%value%')->getArray(); // get by name
   // version 1.0.6
   Categories::instance()->where('id','=', 1)->get()->toArray(); // get by id
   Categories::instance()->where('name','=', 1)->get()->toArray(); // get by name
   Categories::instance()->where('name','like', '%value%')->get()->toArray(); // get by name

    $data1 = Categories::instance()->select('*')->where(function (Database $q){
        $q->where('id',3)->orWhere('id',2);
    })->get()->toArray();
    
    $data2 = Categories::instance()->select('*')->where(function (Database $q){
        $q->where('id',3);
    })->orWhere(function (Database $q){
        $q->where('id',2);
    })->get()->toArray();

use select()

   Categories::instance()->select('*')->get()->values();
   Categories::instance()->select(['*'])->get()->values();
   Categories::instance()->select(['id','name'])->get()->values();

   // with sum and count 
   Summary::instance()->select([
       'SUM(amount) as amount',
       'SUM(amount2) as amount2',
   ])->get()->values();
   Region::instance()->select([
       'COUNT(id) as number'
   ])->get()->values();

use findById()

   Categories::instance()->findById(1);

use orWhere()

   Categories::instance()->where('id','=', 1)->orWhere('id','=',2)->get()->values();

use whereLike()

   Categories::instance()->whereLike('name', '%long')->get()->values(); 
   Categories::instance()->whereLike('name', 'long%')->get()->values(); 
   Categories::instance()->whereLike('name', '%long%')->get()->values();

use orWhereLike()

   Categories::instance()->orWhereLike('name', '%long')->get()->values(); 
   Categories::instance()->orWhereLike('name', 'long%')->get()->values(); 
   Categories::instance()->orWhereLike('name', '%long%')->get()->values();

use whereIn()

   Categories::instance()->whereIn('id', [1,2])->get()->values();

use orWhereIn()

   Categories::instance()->orWhereIn('id', [1,2])->get()->values();

use whereNotIn()

   Categories::instance()->whereNotIn('id', [1,2])->get()->values();

use orWhereNotIn()

   Categories::instance()->orWhereNotIn('name', [1,2])->get()->values();

use whereBetween()

   Categories::instance()->whereBetween('date', ['2023-01-01 00:00:01','2023-12-31 23:59:59'])->get()->values();

use whereRaw()

   Categories::instance()->whereRaw('id = 1 and age = 18')->get()->values();

use orWhereRaw()

   Categories::instance()->where('id', 1)->orWhereRaw('id = 2')->get()->values();

use join

   // way 1
   Blog::instance()->select('*')->join('categories', function ($q) {
      $q->on('categories.id','=','category_blogs.category_id');
   })->get()->values(); 
   // way 2
   Blog::instance()->select('*')->join('categories')->on('categories.id','=','category_blogs.category_id')->get()->values();

use left join

   // way 1
   Blog::instance()->select('*')->leftJoin('categories', function ($q) {
      $q->on('categories.id','=','category_blogs.category_id');
   })->get()->values(); 
   // way 2
   Blog::instance()->select('*')->leftJoin('categories')->on('categories.id','=','category_blogs.category_id')->get()->values();

use right join

   // way 1
   Blog::instance()->select('*')->rightJoin('categories', function ($q) {
      $q->on('categories.id','=','category_blogs.category_id');
   })->get()->values(); 
   // way 2
   Blog::instance()->select('*')->rightJoin('categories')->on('categories.id','=','category_blogs.category_id')->get()->values();

use order by

   News::instance()->select('*')->orderBy('id', 'DESC')->get()->values(); // ASC, DESC

use group by

   // way 1
   News::instance()->select('*')->groupBy('id')->get()->values(); 
   // way 2
   News::instance()->select('*')->groupBy(['field1','field2','field3'])->get()->values();

use limit

   News::instance()->select('*')->limit(100)->get()->values();

use limit and offset

   News::instance()->select('*')->page(0)->limit(100)->get()->values(); // offset 0 limit 100
   News::instance()->select('*')->page(1)->limit(100)->get()->values(); // offset 100 limit 100
   News::instance()->select('*')->page(2)->limit(100)->get()->values(); // offset 200 limit 100

use insert

   News::instance()->insert([
       'name' => 'Test',
       'status' => 1
   ]);
       
   // returns id on successful insert
   News::instance()->insertLastId([
       'name' => 'Test',
       'status' => 1
   ]);

use update
The second parameter in the update function will default to id
If you want to use another column, leave it as an array with the column key and value

   News::instance()->update([
       'name' => 'New2',
       'status' => 1
   ], 1); // id

   // other key
   News::instance()->update ([
        'name' => 'New2',
        'status' => 1
   ], [
       'id' => 1,
       'name' => 'Test'
   ]); // id, name

use update or insert
This function will check to see if the data already exists. If so, update it; if not, insert it
The second parameter in the updateOrInsert function will default to id
If you want to use another column, leave it as an array with the column key and value

   News::instance()->updateOrInsert([
       'name' => 'New2',
       'status' => 1
   ], 1); // id
// other key
   News::instance()->updateOrInsert([
        'name' => 'New2',
        'status' => 1
   ], [
       'id' => 1,
       'name' => 'Test'
   ]); // id, name

Additionally, you can use pure SQL statements with custom functions

   News::instance()->query("SELECT * FROM news WHERE id = 1")->get()->values();
   News::instance()->query("SELECT * FROM news")->get()->values();

Or you can use pure SQL statements with the database class like the example below

  $database = new Database();
  $database->query("SELECT * FROM categories")->fetch();
  $database->query("SELECT * FROM categories")->fetchAll();

In addition to the insert function, you can use the create function to insert data into the table
Note that the create function will insert the column according to the key you declared the key in the $field variable inside the model. If you have not declared a key, when using the create function when inserting data, that column will be ignored.

<?php
namespace App\Models;
use Hola\Core\Database;
use Hola\Core\Model;

class News extends Model {
    protected static $tableName = 'new';
    protected static $field = [
        'title',
        'name',
        'status',
        'date'
    ];

    public static function index(){
         News::instance()->create([
             'title' => 'title'
             'name' => 'new',
             'status' => 1,
             'date' => '2023-09-28'
        ]);
    }
}

Use pagination() function
This function will help shorten the code instead of having to use the page() and limit() functions as before.
The first parameter will be the limit and the second parameter will be the page
How to use

       News::instance()->pagination(10, 1);

Use paginationWithCount() function
This function will take 2 parameters and the page will then return the data forms that have been formatted according to the design
How to use

     $result = News::instance()->paginationWithCount(10, 1);
     //  Return data
     [
         "total" => 50,
         "items" => [],
         "page" => 1,
         "limit" => $limit,
         "total_page" => 10,
     ]

Use save() function
This function will be used to add or update 1 record
If the object has id data that already exists, it will be updated in the database, otherwise a new one will be added
How to use

   $blog = new Blog();
   $blog->name = 'Hi';
   $blog->save();

use table with Database class

<?php
namespace App\Controllers;
use Hola\Core\BaseController;
use Hola\Core\Database;

class HomeController extends BaseController {
   
    public function index(){
        $all = Database::instance()->table('categories')->get()->values();
        $first = Database::instance()->table('categories')->where('id','=',1)->first()->values();
    }

}

use transaction

<?php
namespace App\Controllers;
use Hola\Core\BaseController;
use Hola\Core\Database;
use App\Models\Categories;

class HomeController extends BaseController {
    public function __construct()
    {
        $this->model([Categories::class]);
    } 
   
    public function index(){
       Database::beginTransaction();
       try {
          Categories::instance()->insert(['name' => 'name1']);
          Database::commit();
       }catch (\Exception $e) {
          Database::rollBack();
       } 
    }
}

log sql with Database

<?php
namespace App\Controllers;
use Hola\Core\BaseController;
use Hola\Core\Database;
use App\Models\Categories;

class HomeController extends BaseController {
    public function __construct()
    {
        $this->model([Categories::class]);
    } 
   
    public function index(){
       Database::enableQueryLog();
       Categories::instance()->get()->values();
       log_debug(Database::getQueryLog());
    }
}

log sql with model class

<?php
namespace App\Controllers;
use Hola\Core\BaseController;
use Hola\Core\Database;
use App\Models\Categories;

class HomeController extends BaseController {
    public function __construct()
    {
        $this->model([Categories::class]);
    } 
   
    public function index(){
       log_debug(Categories::instance()->where('id','=',1)->toSqlRaw());
    }
}

use union

    Categories::instance()->union_all(Categories::clone())->get()->values();
    /*
     * SELECT * FROM categories 
     * UNION ALL
     * SELECT * FROM categories
     * */
    Categories::instance()->union(Categories::clone())->get()->values();
    /*
     * SELECT * FROM categories 
     * UNION 
     * SELECT * FROM categories
     */

use subQuery

    Categories::instance()->subQuery(Categories::clone(), 'sub')->get()->values();
    /*
     * SELECT * FROM (SELECT * FROM categories) as sub 
     */
    Categories::instance()->subQuery(Categories::select('id')->clone(), 'sub')->get()->values();
     /*
     * SELECT * FROM (SELECT id FROM categories) as sub 
     */

use collection
With collections you can use functions toArray, toObject, values, value, count, map, filter, push, add, chunk to manipulate the query builder

    Categories::instance()->get()->values(); // get all value
    Categories::instance()->get()->toArray(); // get all value type array
    Categories::instance()->get()->toObject(); // get all value type object
    Categories::instance()->get()->value(); // get first value, use with map and filter functions
    Categories::instance()->get()->count(); // Count the amount of data
    Categories::instance()->get()->map(function ($item) {
       return $item->id;
    })->values(); // Map the data
    Categories::get()->filter(function ($item) {
       return $item->id === 1;
    })->values(); // filter data

    Categories::get()->map(function ($item) {
       return $item->id;
    })->value(); // Map the data and get one
    Categories::get()->filter(function ($item) {
       return $item->id === 1;
    })->value(); // filter data and get one
    
    // use chunk
    Categories::get()->chunk(3, function ($items) {
         foreach ($items as $item) {
            echo $item;
         }
    });

Use relation

Different types of relationships:
- One to One
- One to Many
- Many to Many
Note that when you use relation, you will always have to declare the Relations trait ** Let's start with the One to One relationship first **
A one-to-one relationship is a very basic relationship. For example, a User can be associated with 1 Email. To define this relationship, we place an email method on the User model. The email method should return the result of a hasOne method:
The hasOne function will receive parameters. For example, the first parameter is the model call or the name of the table you want to join. The second parameter is the foreign key of the table. The third parameter will be the primary key you want to map with the foreign key.

<?php
namespace App\Models;
use Hola\Core\Model;
use Hola\Traits\Relations;

class User extends Model {
    use Relations;
    /**
     * Get the phone record associated with the user.
     */
    public function email()
    {
        return $this->hasOne(Phone::class, 'user_id', 'id');
    }
}

Once you have successfully created the association with hasOne then you can call it like the code below

   $email = User::instance()->with('email')->find(1)->email; // or
   $email = (new User())->email()->find(1)->email;

Now, we will define a relationship on the Email model that will allow us to access the User model. We use hasOne's inverse belongsTo method

<?php
namespace App\Models;
use Hola\Core\Model;
use Hola\Traits\Relations;

class Email extends Model {
    use Relations;
    /**
     * Get the user that owns the email.
     */
    public function user()
    {
        return $this->belongsTo(User::class, 'id', 'user_id');
    }
}

** One To Many **

A one-to-many relationship is used to define relationships when one model owns multiple quantities of another model. For example, a blog post has many comments. Like many other Eloquent relationships, one-to-many is defined by a function placed on your model:

<?php
namespace App\Models;
use Hola\Core\Model;
use Hola\Traits\Relations;

class Blog extends Model {
    use Relations;
     /**
     * Get the comments for the blog post.
     */
    public function comments()
    {
        return $this->hasMany(Comment::class, 'blog_id', 'id');
    }
}

Once the relationship is defined, we can access the comments collection by accessing the comments property as follows

$comments = Blog::with('comments')->find(1)->comments; // or
$comments = (new Blog())->comments()->find(1)->comments;

Now that we can access all comments, let's define a relationship to allow comments to be accessed from a post. To determine the inverse of a hasMany relationship, we use the belongsTo method

<?php
namespace App\Models;
use Hola\Core\Model;
use Hola\Traits\Relations;

class Comment extends Model {
    use Relations;
     /**
     * Get the post that owns the comment.
     */
    public function blog()
    {
        return $this->belongsTo(Blog::class, 'id', 'blog_id');
    }
}

Once the relationship is defined, we can get the Post model for a Comment by accessing the blog

$blog = Comment::instance()->with('blog')->find(1)->blog; // or
$blog = (new Comment())->blog()->find(1)->blog;

** Many To Many **

many-to-many, a slightly more complex relationship than hasOne and hasMany. An example of this relationship is that 1 user will have many roles and 1 role will also belong to many users. To define this relationship, it is necessary to have 3 tables: users, roles and user_role. The user_role table will contain 2 columns user_id and role_id.
A many-to-many relationship is defined by calling the belongsToMany or manyToMany based method. For example, let's define the roles method on the User model.

<?php
namespace App\Models;
use Hola\Core\Model;
use Hola\Traits\Relations;

class User extends Model {
    use Relations;
     /**
     * The roles that belong to the user.
     */
    public function role()
    {
        return $this->belongsToMany(Role::class, 'user_role', 'user_id', 'role_id', 'id');
    }
    // way two
    public function role()
    {
        return $this->manyToMany(Role::class, 'user_role', 'user_id', 'role_id', 'id');
    }
}

For example

$roles = User::with('role')->find(1)->role; // or
$roles = (new User())->role()->find(1)->role;

Additionally, you can use the query builder inside the with function as in the example below
The syntax below will get the id, title for blogs with views greater than 0 in category 6

<?php
  $query = Categories::with(['blog' => function ($query) {
      return $query->select('id, title')->where('view','>',0);
  }])->find(6)->value();

By default, the relationships will follow the whereIn conditions with 1 query. If you want to change if you want to query n + 1, you can change it like the code line below.
Setting the second parameter in the with function to true will result in query n + 1

<?php
  $query = Categories::with(['blog'], true)->find(6)->value();

Use count and sum

$sum = Categories::sum('view')->values();
$count = Categories::count('id')->values();

use collection with array

    $array = [
       ["id" => 1, "name" => "Name 1"],
       ["id" => 2, "name" => "Name 2"],
    ];
    $data = new \Hola\Core\Collection($array);
    $data->values(); // get all value
    $data->toArray(); // get all value type array
    $data->toObject(); // get all value type object
    $data->value(); // get first value, use with map and filter functions
    $data->count(); // Count the amount of data
    $data->map(function ($item) {
       return $item->id;
    })->values(); // Map the data and get all
    $data->filter(function ($item) {
       return $item->id === 1;
    })->values(); // filter data and get all
    $data->map(function ($item) {
       return $item->id;
    })->value(); // Map the data and get one
    $data->filter(function ($item) {
       return $item->id === 1;
    })->value(); // filter data and get one
    // use chunk
    $data->chunk(3, function ($items) {
         foreach ($items as $item) {
            echo $item;
         }
    });

Use middleware

The middleware will be the place to check whether the request goes forward to be processed or not. It will often be used to authenticate the user and many other things depending on how you write the code in the middleware.
To create middleware you will create it in the middleware folder
Folder middleware/{name}Middleware.php
Run command create middleware

php cli.php create:middleware NameMiddleware