Du musst dich zuerst Einloggen oder Regestrieren
Hier Einloggen
Hier Regestrieren"); } include "db_connect.php"; $username = $_GET['user']; $userId = $_SESSION['user_id']; try { // Benutzerdaten abrufen $stmt = $pdo->prepare("SELECT id, username, email, created_at FROM users WHERE id = :username"); $stmt->execute([':username' => $username]); $selected_user = $stmt->fetch(PDO::FETCH_ASSOC); $stmt1 = $pdo->prepare("SELECT username, email, created_at FROM users WHERE id = :id"); $stmt1->execute([':id' => $userId]); $user = $stmt1->fetch(PDO::FETCH_ASSOC); $stmt2 = $pdo->prepare("SELECT file_path FROM profile_pictures WHERE user_id = :user_id"); $stmt2->execute([':user_id' => $userId]); $profile_pic2 = $stmt2->fetch(PDO::FETCH_ASSOC); $stmt3 = $pdo->prepare(" SELECT users.id, users.username, profile_pictures.file_path FROM users LEFT JOIN profile_pictures ON users.id = profile_pictures.user_id ORDER BY profile_pictures.uploaded_at DESC "); $stmt3->execute(); $users = $stmt3->fetchAll(PDO::FETCH_ASSOC); $stmt2 = $pdo->prepare("SELECT file_path FROM profile_pictures WHERE user_id = :user_id"); $stmt2->execute([':user_id' => $selected_user['id']]); $profile_pic = $stmt2->fetch(PDO::FETCH_ASSOC); if ($profile_pic) { $selected_profile_image = $profile_pic['file_path']; } else { $selected_profile_image = 'profile-pics/default.jpeg'; } if ($profile_pic2) { $selected_profile_image1 = $profile_pic2['file_path']; } else { $selected_profile_image1 = 'profile-pics/default.jpeg'; } $stmt3 = $pdo->prepare("SELECT COUNT(following_id) AS following_count FROM followers WHERE following_id = :user_id "); $stmt3->execute([':user_id' => $selected_user['id']]); $follower_count = $stmt3->fetch(PDO::FETCH_ASSOC)['following_count']; $sender_id = $_SESSION['user_id']; $receiver_id = $_GET['user']; } catch (PDOException $e) { die("Fehler: " . $e->getMessage()); } ?> Profil von <?php echo htmlspecialchars($selected_user['username']); ?>

Profil von

Profilbild

Email:

Registriert seit:

Follower:

Zurück zur Startseite
prepare("SELECT * FROM messages WHERE (sender_id = :sender_id AND receiver_id = :receiver_id) OR (sender_id = :receiver_id AND receiver_id = :sender_id) ORDER BY sent_at ASC"); $stmt->execute([ ':sender_id' => $sender_id, ':receiver_id' => $receiver_id ]); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt3324 = $pdo->prepare("SELECT * FROM users WHERE id = :user_id"); $stmt3324->execute([':user_id' => $receiver_id]); $receiver = $stmt3324->fetch(PDO::FETCH_ASSOC); ?>

Chat mit Benutzer

: