<?php
require "kwitter.php";
session_start();
$db = new Database($config);
$kweets = $db->getKweets();
$my_title = "Posts";
// Add username to each tweet
if ($kweets) {
foreach ($kweets as &$kweet) {
$user = $db->getUserById($kweet["user_id"]);
$username = $user["username"];
$kweet["username"] = $username;
$kweet[] = $db->getUserById($kweet["user_id"])["username"];
}
view("posts", $kweets, false);
} else {
view("posts");
}
<?php
session_start();
include_once "database.php";
$bad_login = false;
$db = new Database();
if (isset($_SESSION['current_user_id'])) {
$me = $db->getUserById($_SESSION['current_user_id']);
}
if ($me === null && isset($_POST['action']) && $_POST['action'] === 'login') {
if (isset($_POST['username']) && isset($_POST['password'])) {
if ($me = $db->authenticate($_POST['username'], $_POST['password'])) {
$_SESSION['current_user_id'] = $me->id;
} else {
$bad_login = true;
}
}
}
$pages = array();
$dir = opendir("pages");
while ($entry = readdir($dir)) {
if (preg_match('/\\.php$/', $entry)) {
$pages[substr($entry, 0, -4)] = 'pages/' . $entry;
}
}
closedir($dir);
$page = isset($_GET['page']) ? $_GET['page'] : "home";
if (!isset($pages[$page])) {
$page = "home";
}
include $pages[$page];
<?php
require_once 'includes/dbconnection.inc.php';
$db = new Database();
$usuarioData = json_decode($db->getUserById(19));
// echo $usuarioData[0]->usu_nombre;
$image = $usuarioData[0]->usu_imagen;
// header("Content-type: image/jpeg", true, 200);
// print_r (pg_unescape_bytea($image));
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<img src="data:image;base64,<?php
echo $image;
?>
" alt="">
<p><?php
echo $usuarioData[0]->usu_nombre;
?>
</p>
</body>
</html>
