美文网首页
Tp·Db类方法汇总

Tp·Db类方法汇总

作者: 三米板 | 来源:发表于2020-04-16 16:57 被阅读0次
    /**
     * Class Db
     * @package think
     * @method Query table(string $table) static 指定数据表(含前缀)
     * @method Query name(string $name) static 指定数据表(不含前缀)
     * @method Query where(mixed $field, string $op = null, mixed $condition = null) static 查询条件
     * @method Query join(mixed $join, mixed $condition = null, string $type = 'INNER') static JOIN查询
     * @method Query union(mixed $union, boolean $all = false) static UNION查询
     * @method Query limit(mixed $offset, integer $length = null) static 查询LIMIT
     * @method Query order(mixed $field, string $order = null) static 查询ORDER
     * @method Query cache(mixed $key = null , integer $expire = null) static 设置查询缓存
     * @method mixed value(string $field) static 获取某个字段的值
     * @method array column(string $field, string $key = '') static 获取某个列的值
     * @method Query view(mixed $join, mixed $field = null, mixed $on = null, string $type = 'INNER') static 视图查询
     * @method mixed find(mixed $data = null) static 查询单个记录
     * @method mixed select(mixed $data = null) static 查询多个记录
     * @method integer insert(array $data, boolean $replace = false, boolean $getLastInsID = false, string $sequence = null) static 插入一条记录
     * @method integer insertGetId(array $data, boolean $replace = false, string $sequence = null) static 插入一条记录并返回自增ID
     * @method integer insertAll(array $dataSet) static 插入多条记录
     * @method integer update(array $data) static 更新记录
     * @method integer delete(mixed $data = null) static 删除记录
     * @method boolean chunk(integer $count, callable $callback, string $column = null) static 分块获取数据
     * @method mixed query(string $sql, array $bind = [], boolean $master = false, bool $pdo = false) static SQL查询
     * @method integer execute(string $sql, array $bind = [], boolean $fetch = false, boolean $getLastInsID = false, string $sequence = null) static SQL执行
     * @method Paginator paginate(integer $listRows = 15, mixed $simple = null, array $config = []) static 分页查询
     * @method mixed transaction(callable $callback) static 执行数据库事务
     * @method void startTrans() static 启动事务
     * @method void commit() static 用于非自动提交状态下面的查询提交
     * @method void rollback() static 事务回滚
     * @method boolean batchQuery(array $sqlArray) static 批处理执行SQL语句
     * @method string quote(string $str) static SQL指令安全过滤
     * @method string getLastInsID($sequence = null) static 获取最近插入的ID
     */
    
    

    相关文章

      网友评论

          本文标题:Tp·Db类方法汇总

          本文链接:https://www.haomeiwen.com/subject/arldvhtx.html