README

datatableswebutility/dwuty

dwuty提供了一种简单易用的方法，在您的网站上生成可编辑的表格。
数据可以通过php的pdo接口存储在3种不同类型的数据库中。

安装

在您的composer.json中添加"minimum-stability": "dev"和"prefer-stable": true非常重要

composer.json

{
  "minimum-stability": "dev",
  "prefer-stable": true
}

通过composer安装此包

composer require datatableswebutility/dwuty

确保在您的代码库中某处包含composer的自动加载器

为环境创建.env文件并更新数据库凭据

.env

API_KEY="*******"

HOST_ENV="*******"
DATABASE_ENV="*******"
USER_ENV="*******"
PASSWORD_ENV="*******"

设置.htaccess以隐藏.env

.htaccess

# Disable index view

Options -Indexes

# Hide a specific file(s)

<Files ~ "\.(env)$">
Order allow,deny
Deny from all
</Files>

示例（mysql）

<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "/vendor/autoload.php";
Dotenv\Dotenv::createImmutable($_SERVER['DOCUMENT_ROOT'])->load();

use App\webutility;

$config_webutility = array(
    "debug" => array(
        "database_tools" => false
        , "webutility_ssp" => false
        , "tools" => false
    )
    , "database" => array(
        "type" => "mysql"
        , "credentials" => array(
            "host" => "HOST_ENV"
            , "database" => "DATABASE_ENV"
            , "user" => "USER_ENV"
            , "pass" => "PASSWORD_ENV"
        )
    )
    , "crud" => array(
        "create" => array(
            "activ" => true
        )
        , "update" => array(
            "activ" => true
        )
        , "delete" => array(
            "activ" => true
        )
    )
    , "datasource" => "root_table root"
    , "primarykey" => "root.ID"
    , "lang_iso_639_1" => "en"
);
$obj_webutility = new webutility($config_webutility);
$obj_webutility->new_column("root.TEXT_FIELD", "column: TEXT", EDIT, TEXT);
?>
<link rel="stylesheet" type="text/css" href="/vendor/twbs/bootstrap/dist/css/bootstrap.min.css" />
<link rel="stylesheet" type="text/css" href="/vendor/datatables.net/datatables.net-bs5/css/dataTables.bootstrap5.min.css" />
<link rel="stylesheet" type="text/css" href="/vendor/datatables.net/datatables.net-fixedheader-bs5/css/fixedHeader.bootstrap5.min.css" />
<link rel="stylesheet" type="text/css" href="/vendor/select2/select2/dist/css/select2.min.css" />
<script src="/vendor/components/jquery/jquery.min.js"></script>
<div class="container-fluid mt-1">
    <?= $obj_webutility->table_header(); ?>
</div>
<?php
$ary_config = array(
    "default_order" => array(
        "column_no" => 0
        , "direction" => "asc"
    )
    , "datatables_ext" => array(
        "fixedHeader" => "true"
    )
);
$obj_webutility->config($ary_config);
?>

链接

您可以在datatableswebutility.net上找到更多详细信息，并查看实时演示