Edit File - fetch-team-details.php

<?php
include("config.php");

$id = intval($_GET['id']);

// Fetch from team
$stmt = $conn->prepare("SELECT * FROM team WHERE sno = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$team = $stmt->get_result()->fetch_assoc();
$stmt->close();

// Fetch skills
$skills = [];
$stmt = $conn->prepare("SELECT * FROM team_skill WHERE member_id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$skills = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();

// Fetch social links
$socials = [];
$stmt = $conn->prepare("SELECT * FROM team_social_media WHERE member_id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$socials = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();

// Fetch experience
$experiences = [];
$stmt = $conn->prepare("SELECT * FROM team_work_expr WHERE member_id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$experiences = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
$stmt->close();
?>

<div class="container">
    <h4 class="text-info"><?php echo htmlspecialchars($team['name']); ?> - <?php echo htmlspecialchars($team['work']); ?></h4>
    <img src="<?php echo $team['image']; ?>" alt="Member Image" style="max-height:200px;" class="my-3 d-block mx-auto">

<p><strong>Education:</strong> <?php echo nl2br(htmlspecialchars($team['education'])); ?></p>
    <p><strong>Skill Overview:</strong> <?php echo nl2br(htmlspecialchars($team['skills_view'])); ?></p>
    <p><strong>General Overview:</strong> <?php echo nl2br(htmlspecialchars($team['overview'])); ?></p>

<hr>

<h5>Skills</h5>
    <ul>
        <?php foreach ($skills as $skill): ?>
            <li><?php echo htmlspecialchars($skill['skill']); ?> (Level: <?php echo htmlspecialchars($skill['level']); ?>)</li>
        <?php endforeach; ?>
    </ul>

<h5>Social Media</h5>
    <ul>
        <?php foreach ($socials as $social): ?>
            <li><strong><?php echo htmlspecialchars($social['social_platform']); ?>:</strong> <a href="<?php echo htmlspecialchars($social['link']); ?>" target="_blank"><?php echo htmlspecialchars($social['link']); ?></a></li>
        <?php endforeach; ?>
    </ul>

<h5>Work Experience</h5>
    <ul>
        <?php foreach ($experiences as $exp): ?>
            <li><?php echo nl2br(htmlspecialchars($exp['exp'])); ?></li>
        <?php endforeach; ?>
    </ul>
</div>

Kembali