<?php
session_start ();
?>
<?php
include ('./config.php');
include ('./banner.php');
?>
<link rel="stylesheet" href="./styles/styles.css">
<script src="./styles/styles.js"></script>
<?php
include ('./styles/head.php');
?>
<iframe="./collection.php"></iframe>
<div class="overall">
<?php
$name = $_GET ["searchname"];
$handle = mysql_connect ($server, $MYSQL_NAME, $MYSQL_PASSWORD);
$name = htmlentities(mysql_real_escape_string($name, $handle));
mysql_query ("use " . $databasename, $handle);
$result2 = mysql_query ("SELECT * FROM users WHERE nickname=\"" . $name ."\"", $handle);
if ($row2 = mysql_fetch_assoc ($result2));
else
echo "This user doesn't exist<br>";
$result = mysql_query ("SELECT * FROM postings WHERE nickname=\"" . $name ."\" AND public=\"1\"", $handle);
while ($row = mysql_fetch_assoc ($result))
//echo "<div class=\"post01\" id=\"postid" . $i . "\">\n<div class=\"postdatetime01\" id=\"postdatettimeid" . $i . "\">" . $row ["datetime"] . "</div>\n<br><hr><br>\n<div class=\"postcontent01\" id=\"postcontentid" . $i++ . "\">" . $row ["content"] ."</div>\n</div>\n\n";
echo "<div class=\"post01\" id=\"postid" . $i . "\">\n<div class=\"postdatetime01\" id=\"postdatetimeid" . $i . "\">" . $row ["datetime"] . "</div>\n<br><hr><br>\n<div class=\"postcontent01\"><div class=\"usercontent01\">" . $name . "<br><hr><br><code>" . $row2 ["mail"] . "</code><br><hr><br><img width=\"50%\"src=\"showphoto.php?name=".$name."\"></div><div class=\"postcontent02\" id=\"postcontentid" . $i++ . "\">" . $row ["content"] ."</div></div></div>\n\n";
mysql_close ();
include("./collection.php");
?>
</div>