Untitled

<?php

    $candidateID = $_GET['id'];

    $dbhost = "localhost";
    $dbname = "linguedo_candidates";
    $dbuser = "linguedo_agathar";
    $dbpass = "Lh+S#b!6[5J#";
    $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);

    if(! $conn ) {
        die('Could not connect to database because: ' . mysqli_error());
    }

    $sql = "SELECT * FROM candidates WHERE id=$candidateID";
    $result = mysqli_query($conn, $sql);


    if (mysqli_num_rows($result) > 0) {

        $name = $row["name"];

        echo $name;

    } else {
        echo "Candidate could not be found in the database :(";
    }

    mysqli_close($conn);

?>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
        <meta name="description" content="">
        <meta name="author" content="Davide Lionetti">
        <title>John Doe | Agatharied candidates</title>
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.3/css/bootstrap.min.css">
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
        <style type="text/css">
            h1.title {
                margin: 50px 0;
            }
        </style>
    </head>
    <body>
        <div class="container">
            <div class="col-10 mx-auto">
                <h1 class="title">Details of the candidate</h1>
                <div class="jumbotron">
                    <h1 class="display-4"><?= $row["name"]; ?></h1>
                    <p class="lead">john@doe.com</p>
                    <hr class="my-4">
                    <p>It uses utility classes for typography and spacing to space content out within the larger container.</p>
                    <a href="http://www.google.com/" target="_blank" class="btn btn-primary">View CV</a>
                </div>
                <div class="alert alert-success" role="alert">
                    This candidate has successfully been added into Bullhorn database.
                </div>
                <div class="alert alert-danger" role="alert">
                    <h4 class="alert-heading">Candidate missing in Bullhorn!</h4>
                    <p>Hmmm... it looks like this candidate has not been inserted yet into the Bullhorn database...</p>
                    <hr>
                    <p class="mb-0">But don't panic, I'm here to help you! Just click here below and I'll try to add this candidate into Bullhorn!</p>
                    <a href="http://www.google.com/" class="btn btn-primary mt-2">Add to Bullhorn</a>
                </div>
            </div>
        </div>
        <script src="https://code.jquery.com/jquery-3.2.1.min.js" integrity="sha256-hwg4gsxgFZhOsEEamdOYGBf13FyQuiTwlAQgxVSNgt4=" crossorigin="anonymous"></script>
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.3/js/bootstrap.min.js"></script>
    </body>
</html>