profile3.php

<?php 
    $pdo = new PDO('mysql:host=localhost; port=3306; dbname=misc', 'kings', 'zap');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    session_start();
    require_once "util.php";

    if(!isset($_SESSION['user_id']) && !isset($_SESSION['name'])) {
        die('You are not logged in');
        return false;
    }
    if(!isset($_GET['profile_id'])){
        $_SESSION['error'] = "Missing profile ID";
        header('location: user_acc3.php');
        return;
    }
    if(isset($_POST['submit'])) {
        header('location: user_acc3.php');
        return;
    }

?>
<h1>Profile resume details</h1>
<?php 
    $stmt = $pdo->prepare('SELECT * FROM profile WHERE profile_id = :std');
    $stmt->execute(array(':std' => $_GET['profile_id']));
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        if($row === false){
            $_SESSION['error'] = "Bad value for profile_id";
            header('location: user_acc3.php');
            return;
        }
        echo '<p>First name: '.$row['First_name'].'</p>';
        echo '<p>Last name: '.$row['Last_name'].'</p>';
        echo '<p>Email: '.$row['Email'].'</p>';
        echo '<p>Headline: '.$row['Headline'].'</p>';
        echo '<p>Summary: '.$row['Summary'].'</p>';
    }
//load education
$schools = loadEdu($pdo, $_REQUEST['profile_id']);
    foreach($schools as $school) {
        echo '<ul><li>Education year = '.$school['year'].'</li></ul>';
        echo '<ul><li>School = '.$school['name'].'</li></ul>';
    }

        
    
    
    $stmt = $pdo->prepare('SELECT * FROM position WHERE profile_id = :std');
    $stmt->execute(array(':std' => $_GET['profile_id']));
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        if($row === false){
            $_SESSION['error'] = "Bad value for profile_id";
            header('location: user_acc3.php');
            return;
        }
        echo '<ul><li>Rank = '.$row['rank'].'</li></ul>';
        echo '<ul><li>Year = '.$row['year'].'</li></ul>';
        echo '<ul><li>Description = '.$row['description'].'</li></ul>';
    }
?>
<form method="POST">
    <input type="submit"name="submit" value="Done">
</form>