# FireSqlite

**Repository Path**: ownfire/FireSqlite

## Basic Information

- **Project Name**: FireSqlite
- **Description**: pdo sqlite
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-12-16
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

Sqlite数据库操作

use FireSqlite\Sqlite;

$sqlite = Sqlite::init(__DIR__.'/db/test.db',[
        'tablePrefix'=>'tbl_',
        'username'=>'user',
        'password'=>'pass',
        'debug'=>true,
]);

Sqlite::table('records')->find_one(2);
Sqlite::table('records')->where('function',333)->find_one();
Sqlite::table('records')->where('line','=',1)->or_where('line','>',2)->limit(5)->as_array()->find_all();
Sqlite::table('records')->where('args',5555)->where('file','like','%6%')->update(['source'=>mt_rand()]);
$sqlite->table('records')->timestamp('create_at')->insert(['function'=>3,'args'=>4]);
$sqlite->table('records')->timestamp(['create_at','update_at'])->mutil_insert([['function'=>777,'args'=>888],['function'=>999,'file'=>000]]);
$sqlite->table('records')->where('id','=',7)->delete(2);