iofficedk/mybasemodel

扩展您的PHP模型

v1.0.7 2020-06-21 17:38 UTC

This package is auto-updated.

Last update: 2024-09-22 02:52:09 UTC


README

使用myBaseModel,您可以扩展自己的模型并获取一些额外的查询功能。它的设计目的是简单,而不是laravel illuminate。 :) 我曾经在项目中首先使用它来快速创建一个“工作”模型,以展示如果尚未选择框架,以及在小脚本中。

使用

使用 .io.json 文件中的部分设置

{
    "mysql": {
        "default": {
            "host": "localhost",
            "user": "",
            "pass": "",
            "base": "",
            "port": "3306"
        }
    }
}
namespace App\Model;

Class Users extends \Io\Model\Base\myBaseModel
{
    protected $table = 'user';
}

单次调用

$User = Users::new()
$User = Users::id({row id})
$User = Users::sql({query})

多次调用

::where({field}, {Operator}, {value})
::whereOr({field}, {Operator}, {value})
::fields([{field name}])
::sort({field name DESC|ASC})

ex. $Users = Users::where('active', 'IS NOT NULL')->fields('name')->sort('name DESC');

资源

$Users->count()
$Users->next()
$Users->getArray()    

结果

$User = $Users->next()

$User->{fieldname}
$User->isReady()
$User->getId()
$User->getObject()

$Status = $User->save()
$Status = $User->delete()

ex. $User = $Users->next()
if ($User)
{
    return $User->name;
}

保存 | 删除

$Status->success
$Status->updated
$Status->created
$Status->matched
$Status->warning
$Status->error

安装

$ composer require iofficedk/mybasemodel