validation_timestamp and create_new_revision are not part of the data. move them to query parameters
<?php
$config = [
"db" => [
"dsn" => "sqlite:".realpath(dirname(__FILE__))."/../data/renkan.sqlite",
"user" => "dbUser",
"password" => "pa$$"
],
];
/*
I will usually place the following in a bootstrap file or some type of environment
setup file (code that is run at the start of every page request), but they work
just as well in your config file if it's in php (some alternatives to php are xml or ini files).
*/
/*
Creating constants for heavily used paths makes things a lot easier.
ex. require_once(LIBRARY_PATH . "Paginator.php")
*/
defined("LIBRARY_PATH")
or define("LIBRARY_PATH", realpath(dirname(__FILE__) . '/library/'));
defined("TEMPLATES_PATH")
or define("TEMPLATES_PATH", realpath(dirname(__FILE__) . '/templates/'));
defined("RENKAN_PROJECT_TABLE")
or define("RENKAN_PROJECT_TABLE", "renkan_project");
/*
Error reporting.
*/
ini_set("error_reporting", "true");
error_reporting(E_ALL|E_STRCT);