echo $logo;
echo 'Welcome, ' . pick_users_data($_SESSION['user_id'], 'FIRSTNAME', $conn) . '!';
echo $profile_menu;
echo '<form action="profile.php" method="post" enctype="multipart/form-data">
<input type="file" accept="image/jpeg" name="picture">
<input type="text" name="name">
<input type="submit" value="Опубликовать" name="upload">
</form>';
echo '<h4>Публикации:</h4>';
if (isset($_POST['upload'])) {
$name = $_POST['name'];
$picture = $_FILES['picture']['tmp_name'];
publish($conn, $_SESSION['user_id'], $name, $picture);
header('Location: published.php');
}
$pub = show_publications($_SESSION['user_id'], $conn);
for ($i = count($pub['PDATE']) - 1; $i >= 0; $i--) {
echo substr($pub['PDATE'][$i], 0, -15) . '</br>' . substr($pub['PDATE'][$i], 9, -7) . ' <b>' . $pub['NAME'][$i] . '</b>
<a href="profile.php?d_p_id=' . $pub['ID'][$i] . '">(удалить)</a></br>';
#$row = show_picture($pub['ID'][$i], $conn);
#$img = $row->load();
#print('<img src="data:image/png;base64,'.base64_encode($img).'" />');
$source = show_picture($pub['ID'][$i], $conn);
$img1 = $source->load();
print '<img src="data:image/png;base64,' . base64_encode($img1) . '" />';
}
if (isset($_GET['d_p_id'])) {
delete_publication($_GET['d_p_id'], $conn);
header('Location/profile.php');
}
} else {
if (isset($_POST['subscribe'])) {
if (subscribe($_GET['id'], false, $conn)) {
echo 'Добавлено!';
}
}
} else {
echo '</br><i>У вас в друзьях</i>';
echo '<form action="people.php?id=' . $_GET['id'] . '" method="post"><input type="submit" value="Удалить из друзей" name="unsubscribe"></form>';
if (isset($_POST['unsubscribe'])) {
if (subscribe($_GET['id'], true, $conn)) {
echo 'Удалено!';
}
}
}
echo '</br><a href="messages.php?id=' . $_GET['id'] . '">Написать сообщение</a></br>';
$pub = show_publications($_GET['id'], $conn);
for ($i = count($pub['PDATE']) - 1; $i >= 0; $i--) {
echo substr($pub['PDATE'][$i], 0, -15) . '</br>' . substr($pub['PDATE'][$i], 9, -7) . ' <b>' . $pub['NAME'][$i] . '</b></br>';
#$row = show_picture($pub['ID'][$i], $conn);
#$img = $row->load();
#print('<img src="data:image/png;base64,'.base64_encode($img).'" />');
$source = show_picture($pub['ID'][$i], $conn);
$img1 = $source->load();
print '<img src="data:image/png;base64,' . base64_encode($img1) . '" />';
}
} else {
echo 'Нет такого ID!';
}
} else {
echo '
