README

在您的根项目目录中创建自己的 config.json，如下所示。

{
  "mysql" : {
    "dbh"       : "mysql:hostname = localhost; dbname=ProjectDB;",
    "user"      : "root",
    "password"  : ""
  }
}

获取连接

<?php

require_once __DIR__ .'/vendor/autoload.php';

use Felis\Silvestris\Database as DB;

$db = DB::connect('mysql');

选择示例 1

$data = $db->select('users')->fetchAll()->get(); // select all fields from 'users' table
print_r($data);

选择示例 2

$data = $db->select('users', 'name')->fetchAll()->get(); // select 'name' field from 'users' table
print_r($data);

选择示例 3

$data = $db->select('users')->fetchAll()->toJson()->get(); // return JSON data
print_r($data);

选择带有 WHERE 子句的示例

$select = $db->select('users')->where([
  'name' => ['LIKE' => '%John%'],
  'job' => ['=' => 'Developer']
]);
$data = $select->fetchAll()->get();
print_r($data);

插入示例

$insert = $db->insert('users', [
  'name' => 'Johny',
  'job' => 'Developer'
]);
var_dump($insert); //return true or false

更新示例

$update = $db->update('users', 'userid', 2, [
  'name' => 'Pretty',
  'job' => 'Sales'
]);
var_dump($update); //return true or false

删除示例

$delete = $db->delete('users', 'userid', 2);
var_dump($delete); //return true or false

查询构建器 fetch() 数据示例

$query = $db->query("SELECT * FROM users WHERE id = :id", [
  ':id' => 1
]);
$data = $query->fetch()->get(); //use fetch() to fetch data to object and get() to get data
print_r($data); //return data

查询构建器 execute() 示例

$query = $db->query("DELETE FROM users WHERE id = 1");
$exec = $query->execute(); //use execute() to execute a query
var_dump($exec); return true or false

如何使用（Silvestris 分页客户端 ES6 导入）

源代码： Github

通过 npm 安装它 npm i @itpolsri/felis-silvestris-paging

导入模块
导入 { requestPage } from "@itpolsri/felis-silvestris-paging";

定义您的分页 html 元素

const htmlEltOpts = {
    pageElContainerId: '#page-el-container',
    tBodyId: '#tbody',
    pageElChildClassName: 'page-el-child'
}

调用我们的方法 requestPage(...)

requestPage('YOUR_SILVESTRIS_PAGING_ENDPOINT','SILVESTRIS_QUERY_STRING_NAME',
    SILVESTRIS_QUERY_STRING_VALUE,
    htmlEltOpts,
    err=>{
        console.error(err)
    }
)

示例

requestPage('https://:8080/Paging/api.php','page',
    1,
    htmlEltOpts,
    err=>{
        console.error(err)
    }
)