<?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>