/media/sda-magnetic/david/Dok-15-2023-11-27/informatik/www-intel-compute-stick-2022-06-13/mysocial20220412a/threadexternfriends.php

<?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');
?>
<div class="overall">
<?php 

    $name = $_GET ["searchname"][0];
    
    $handle = mysql_connect ($server, $MYSQL_NAME, $MYSQL_PASSWORD);
    $name3 = htmlentities(mysql_real_escape_string($name, $handle));
    
    mysql_query ("use " . $databasename, $handle);

    $name = explode (".", $name3) [0];
    $name2 = explode (".", $name3) [1];
        
    $result2 = mysql_query ("SELECT * FROM users WHERE nickname=\"" . $name ."\"", $handle);
    if ($row2 = mysql_fetch_assoc ($result2));
    else
        echo "This user doesn't exist<br>";

        
    $result3 = mysql_query ("SELECT * FROM users WHERE nickname=\"" . $name2 ."\"", $handle);
    if ($row3 = mysql_fetch_assoc ($result3));
    else
        echo "This user doesn't exist<br>";

    
    
    $result = mysql_query ("SELECT * FROM postings WHERE nickname=\"" . $name . "." . $name2 ."\" OR nickname=\"" . $name2 . "." . $name ."\"", $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";
        if (strcmp ($row ["nickname"], $name . "." . $name2) == 0)
            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";
        else if (strcmp ($row ["nickname"], $name2 . "." . $name) == 0)
            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\">" . $name2 .  "<br><hr><br><code>" . $row3 ["mail"] . "</code><br><hr><br><img width=\"50%\"src=\"showphoto.php?name=".$name2."\"></div><div class=\"postcontent02\" id=\"postcontentid" . $i++ . "\">" . $row ["content"] ."</div></div></div>\n\n";

    mysql_close ();

include("./collection.php");

?>
</div>