使用 PHP 数据库框架编写 CRUD 操作

$ composer require ramsey/uuid

use Ramsey\Uuid\Uuid;

$uuid1 = Uuid::uuid1();
echo $uuid1->toString();

$ apt-cache search php7.4|grep mysql
php7.4-mysql - MySQL module for PHP

$ sudo apt-get install php7.4-mysql
$ sudo service apache2 restart

$stmt = $connection->prepare("
    INSERT INTO user (
        uuid,
        name,
        slug,
        created_on,
        updated_on
    ) VALUES (
        :uuid,
        :name,
        :slug,
        :created_on,
        :updated_on
    )
");
$stmt->bindParam(':uuid', $uuid);
$stmt->bindParam(':name', $name);
$stmt->bindParam(':slug', $slug);
$stmt->bindParam(':created_on', $createdOn);
$stmt->bindParam(':updated_on', $updatedOn);

$uuid = "25769c6c-d34d-4bfe-ba98-e0ee856f3e7a";
$name = "John Doe";
$slug = "john-doe";
$createdOn = (new DateTime())->getTimestamp();
$updatedOn = $createdOn;
$stmt->execute();

$ composer require catfan/medoo

use Medoo\Medoo;

$database = new Medoo([
    'database_type' => 'mysql',
    'database_name' => '<dbname>',
    'server' => 'localhost',
    'username' => '<username>',
    'password' => '<password>'
]);

// backend/routes.php
$modules = require './config/routes.php';
foreach ($modules as $module) {
    require './module/' . $module . 'index.php';
}

// backend/config/routes.php
return [
    'Home/',
    'User/',
    // ...
];

// backend/core/mysql.php
$dbconfig = require './config/mysql.php';
$mysql = new Medoo\Medoo([
    'database_type' => $dbconfig['type'],
    'database_name' => $dbconfig['name'],
    'server' => $dbconfig['host'],
    'username' => $dbconfig['username'],
    'password' => $dbconfig['password']
]);
return $mysql;

// backend/public/index.php
chdir(dirname(__DIR__));
require_once 'vendor/autoload.php';
$request = Zend\Diactoros\ServerRequestFactory::fromGlobals(
    //...
);
$router = new League\Route\Router;
try {
    require 'middlewares.php';
    require 'routes.php';
    $response = $router->dispatch($request);
} catch(Exception $exception) {
    // handle errors
}
(new Zend\HttpHandlerRunner\Emitter\SapiEmitter)->emit($response);

└── module
    ├── Home
    │   ├── index.php
    │   └── _routes
    │       └── hello_world.php
    └── User
        ├── index.php
        └── _routes
            └── ...

// module/Home/_routes/hello_world.php
use Psr\Http\Message\ResponseInterface;
use Psr\Http\Message\ServerRequestInterface;

$router->get('/', function (ServerRequestInterface $request) : ResponseInterface {
    return new Zend\Diactoros\Response\JsonResponse(
        'Hello world!'
    );
});

└── User
    ├── index.php
    ├── _routes
    │   ├── delete_user.php
    │   ├── fetch_user.php
    │   └── ...
    └── Controller
        └── ...

└── Controller
    ├── Controller.php
    ├── Insert
    │   └── User.php
    ├── Fetch
    │   ├── User.php
    │   └── Users.php
    ├── Update
    │   └── User.php
    └── Delete
        └── User.php

// module/User/Controller/Controller.php
namespace Spectre\User\Controller;

use Medoo\Medoo;

abstract class Controller
{
    protected $database;

    public function __construct(Medoo $database)
    {
        $this->database = $database;
    }
}

// module/User/Controller/Fetch/Users.php
namespace Spectre\User\Controller\Fetch;

use Spectre\User\Controller\Controller;

class Users extends Controller
{
    public function fetch()
    {
        $columns = [
            'uuid',
            'name',
            'slug',
            'created_on',
            'updated_on',
        ];
        return $this->database->select('user', $columns);
    }
}