People Database

<!DOCTYPE HTML>
<html>
<?php
        //set the connection
        $dbhost = //host
        $dbuser = //user
        $dbpass = //password
        $dbname = //databsase name; these are all written inbetween " "

        $db = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
        //verify integrity of the connection
        if ($db->connect_error) {
            die('Could not connect: ' . mysql_error());
        }
        //get the person's id
        $id = $_POST["id"];
        //initialize the variables
        $pid = "err";
        $pname = "err";
        $ppren = "err";
        $pbday = "err";
        $paddr = "err";
        $ptelnr = "err";
        $pphoto = "err";
        //these variables are to store in them the data of the person you've asked for
/*
        //get the values from database _1  (I tried more ways of doing this)
        $sql = "SELECT * FROM `People Info` WHERE `Id` = {$id}";
        $result = $db->query($sql);

        if($result["num_rows"] >0) {
            while($row = $result->fetch_assoc()) {
                $pid = $row[0];
                $pname = $row["Nume"];
                $ppren = $row["Prenume"];
                $pbday = $row["Birthdate"];
                $paddr = $row["Address"];
                $ptelnr = $row["Nr. Telefon"];
                $pphoto = $row["Photo"];
            }
        }
            else { echo "0 results"; }
*/
        //get values from database _2
        $pid = mysqli_query($db, "SELECT `Id` FROM `People Info` WHERE `Id` = {$id}");
        echo $pid;
        $pname = mysqli_query($db, "SELECT `Nume` FROM `People Info` WHERE `Id` = {$id}");
        $ppren = mysqli_query($db, "SELECT `Prenume` FROM `People Info` WHERE `Id` = {$id}");
        $pbday = mysqli_query($db, "SELECT `Birthdate` FROM `People Info` WHERE `Id` = {$id}");
        $paddr = mysqli_query($db, "SELECT `Address` FROM `People Info` WHERE `Id` = {$id}");
        $ptelnr = mysqli_query($db, "SELECT `Nr. Telefon` FROM `People Info` WHERE `Id` = {$id}");
        $pphoto = mysqli_query($db, "SELECT `Photo` FROM `People Info` WHERE `Id` = {$id}");
?>
    <style>
    body {
        background-color: #2f363a;
        color: #ffffff;
        font-size: 30px;

    }
    </style>
    <head>
        <title>prsinf</title>
    </head>
    <body>

        <center>
        <p> Id: <?php echo $pid ?> </p>
        <p> Nume: <?php echo $pname ?> </p>
        <p> Prenume: <?php echo $ppren ?> </p>
        <p> Data de naștere: <?php echo $pbday ?> </p>
        <p> Adresă: <?php echo $paddr ?> </p>
        <p> Număr de telefon: <?php echo $ptelnr ?> </p>

        </center>
    </body>
<?php
    mysqli_close($db);
?>
</html>