smithi_3000
37a2ae2c2d
Everything previously under www/src now are under www/ Moved style.CSS under www/ressources, to allow blocking http requests to www/lib completly Moved <head> and <header> generation under lib/PHP/output/sections.php to reduce redundancy within files. Also implemented a system to allow them to generate relatif paht for href to ressources depending on their deepness within www/ hierarchy.
25 lines
682 B
PHP
25 lines
682 B
PHP
<?php
|
|
|
|
function &new_db_connection($host, $port, $database_name, $user, $pw): PDO
|
|
{
|
|
static $pdo = null; if($pdo) return $pdo;
|
|
$dsn = sprintf('mysql:host=%s;port=%d;dbname=%s;charset=utf8mb4', $host, $port, $database_name);
|
|
$pdo = new PDO($dsn, $user, $pw, [
|
|
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
|
|
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
|
|
PDO::ATTR_EMULATE_PREPARES => false
|
|
]);
|
|
return $pdo;
|
|
}
|
|
|
|
function close_db_connection(&$db_object): void
|
|
{
|
|
$db_object = null;
|
|
}
|
|
|
|
function sql_query($query, $db_conn): PDOStatement {
|
|
$qresult = $db_conn->query($query);
|
|
if(!$qresult) die($db_conn->errorInfo[2]);
|
|
return $qresult;
|
|
}
|
|
|