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

<?php 
session_start ();
?>

<?php 
include ('./config.php');
?>

<link rel="stylesheet" href="./styles/extern.css">

<div class="dropdown">
  <button class="dropbtn">Menue</button>
  <div class="dropdown-content">
    <a href="./login.html">login</a>
    <a href="./register.php">register</a>
    <a href="./thread.php">thread</a>
    <a href="./search.php">list users</a>
  </div>
</div>

<ul>
<li><a href="./login.html">login</a></li>
<li><a href="./register.php">register</a></li>
<li><a href="./thread.php">thread</a></li>
<li><a href="./search.php">list users</a></li>
</ul>
<?php
    $handle = mysql_connect ($server, $MYSQL_NAME, $MYSQL_PASSWORD);
    mysql_query ("use " . $databasename, $handle);
    $sessionname = $_SESSION ["name"];
    $sessionname = htmlentities(mysql_real_escape_string ($sessionname, $handle));
    echo "<FORM METHOD=\"GET\">\n";
    echo "&nbsp;<SELECT MULTIPLE name=\"friendname[]\" MULTIPLE>\n";
    $result5 = mysql_query ("SELECT * FROM freunde WHERE freund1=\"" . $sessionname . "\"  OR freund2=\"" .$sessioname. "\"", $handle);
    while ($row5 = mysql_fetch_assoc ($result5)) {
        if (strcmp ($row5 ["freund1"], $sessionname) == 0)
            echo "<OPTION style=\"  #FF0000;   background-size: 100%;background-image: url(./showphoto.php?name=".$row6["freund1"]."); background-repeat: no-repeat;\">" . $row5 ["freund2"] . "</OPTION>"; 
        else
            echo "<OPTION style=\"  #FF0000;   background-size: 100%;background-image: url(./showphoto.php?name=".$row6["freund2"]."); background-repeat: no-repeat;\">" . $row5 ["freund1"] . "</OPTION>"; 
    }
    echo "</SELECT>&nbsp;";
    echo "<button formaction=\"./threadfriends.php\">Freunde unterhalten</button><br>\n";
    echo "<FORM><br>\n";
    mysql_close ($handle);
?>
<?php
    $handle2 = mysql_connect ($server, $MYSQL_NAME, $MYSQL_PASSWORD);
    mysql_query ("use " . $databasename, $handle2);
    echo "<FORM METHOD=\"GET\">\n";
    echo "&nbsp;<SELECT MULTIPLE name=\"searchname[]\" MULTIPLE>\n";
    $result6 = mysql_query ("SELECT * FROM freunde", $handle2);
    while ($row6 = mysql_fetch_assoc ($result6)) {
            echo "<OPTION style=\"  #FF0000;   background-size: 100%;background-image: url(./showphoto.php?name=".$row6["freund1"]."); background-repeat: no-repeat;\">" . $row6 ["freund1"] . "." . $row6 ["freund2"] . "</OPTION>"; 
    }
    echo "</SELECT>&nbsp;";
    echo "<button  formaction=\"./threadexternfriends.php\">Freunde Unterhaltung extern</button><br>\n";
    echo "<FORM><br>\n";
    mysql_close ($handle2);
?>