$page, "file" => "pages/$page.php", "title" => $pageArr[$page]);
} else {
return array("id" => "404", "file" => "pages/404.php", "title" => "404");
}
}
function get_style($styleArr)
{
if (isset($_POST["style"])) {
$_SESSION["style"] = $_POST["style"];
}
if (isset($_GET["style"])) {
$_SESSION["style"] = $_GET["style"];
}
$style = isset($_SESSION["style"]) ? $_SESSION["style"] : "default";
if (array_key_exists($style, $styleArr)) {
return array("id" => $style, "file" => $styleArr[$style]);
} else {
return array("id" => "default", "file" => $styleArr["default"]);
}
}
function get_usagedata()
{
return array(
"files" => count(get_included_files()),
"memory" => round(memory_get_peak_usage(true) / pow(10, 6), 1),
"time" => round((microtime(true) - $_SERVER['REQUEST_TIME_FLOAT']) * 1000, 3)
);
}
function create_navbar($pageArr, $pageId)
{
$navButtons = "";
foreach ($pageArr as $id => $name) {
$class = $pageId == $id ? "class=\"selected\"" : "";
$navButtons .= "$name";
}
return $navButtons;
}
function create_stylechooser($styleArr, $styleId)
{
$styleOpts = "";
foreach (array_keys($styleArr) as $id) {
$selected = $styleId == $id ? "selected" : "";
$text = ucfirst($id);
$styleOpts .= "";
}
return $styleOpts;
}
function check_libs()
{
if (class_exists('PDO') && in_array("sqlite", pdo_drivers())) {
return true;
} else {
return false;
}
}
function connect_database($dsn)
{
try {
$db = new PDO($dsn);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $db;
} catch (PDOException $e) {
echo "DSN: $dsn";
echo "$e
";
return null;
}
}
function create_statement($querySql)
{
if (check_libs()) {
$db = connect_database(RASTDB);
if ($db != null) {
return $db->prepare($querySql);
} else {
echo "ERROR: Failed to get the requested database.";
}
} else {
echo "ERROR: The sqlite PDO drive is disabled.";
}
}
function format_comments($queryResult)
{
$rows = null;
foreach ($queryResult as $row) {
$name = htmlentities($row["name"]);
$time = htmlentities($row["time"]);
$text = htmlentities($row["text"]);
$rows .= "";
}
return $rows;
}
function get_comments($parent, $maxResults)
{
$stmt = create_statement("SELECT * FROM comments WHERE parent = ? ORDER BY datetime(time) DESC LIMIT ?");
$params = [$parent, $maxResults];
try {
$stmt->execute($params);
$res = $stmt->fetchAll(PDO::FETCH_ASSOC);
return format_comments($res);
} catch (PDOException $e) {
return "Failed to get comments.
";
throw $e;
}
}
function get_comments_table($res)
{
if (count($res) > 0) {
$rows = "";
#$rows .= "| Id | ";
$rows .= "Time | ";
$rows .= "Parent | ";
$rows .= "Author | ";
$rows .= "Text |
";
foreach ($res as $row) {
#$id = htmlentities($row["id"]);
$name = htmlentities($row["name"]);
$parent = htmlentities($row["parent"]);
$time = htmlentities($row["time"]);
$text = htmlentities($row["text"]);
#$rows .= "| $id | ";
$rows .= "$time | ";
$rows .= "$parent | ";
$rows .= "$name | ";
$rows .= "$text |
";
}
$rows .= "
";
return $rows;
} else {
return "Lyckades inte hitta vad du sökte efter.
Det kan vara så att du stavat fel eller att det du sökte efter inte finns i databasen.
";
}
}
// Ugly AF
function printJettyResultsetToHTMLTable($res)
{
$rows = null;
foreach ($res as $row) {
$rows .= "| {$row['jettyPosition']} | {$row['boatType']} | {$row['boatEngine']} | {$row['boatLength']} | {$row['boatWidth']} | {$row['ownerName']} |
";
}
echo "| jettyPostion | boatType | boatEngine | boatLength | boatWidth | ownerName |
|---|
$rows
";
}
"; $rows .= "
$text
"; $rows .= "