1. Go to this page and download the library: Download zoujingli/type-orm-sqlite library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
zoujingli / type-orm-sqlite example snippets
declare(strict_types=1);
use Type\Orm\Database;
use Type\Orm\Sqlite\SqliteDriver;
use Type\Runtime\ExecutionScope;
/**
* 在单一连接内执行查询，内存库会随连接关闭销毁。
*
* @param list<string> $argv 可选第二项为已准备目录中的 SQLite 绝对路径。
*/
function main(int $argc, array $argv): void
{
$filename = $argv[1] ?? ':memory:';
$database = new Database(new SqliteDriver($filename), 1, 0);
$scope = new ExecutionScope();
try {
$connection = $database->connect($scope);
echo json_encode($connection->query('SELECT ? AS value', [7]), JSON_THROW_ON_ERROR) . "\n";
} finally {
try {
$scope->close();
} finally {
$database->close();
}
}
}