如何从我的代码中使用php准备好的语句从数据库中获取数据并在网页中回显它们？

I'm trying to get out data in a page with a prepared statement. Is this code wrong or:`

$conn = mysqli_connect("localhost", "root", "123456", "test");
if (mysqli_connect_errno()) {
    die("error".mysqli_connect_error());
    exit();
}

$query=" SELECT * FROM persons WHERE name=? AND last=? ;";
$stm=mysqli_stmt_init($conn);
if(! mysqli_stmt_prepare($stm, $query)){
    echo "statment  failed";
}
else{
    mysqli_stmt_bind_param( $stm , "ss", $name , $last);
};

mysqli_stmt_execute($stm);

`

mysqli_stmt_execute($stm);    
$result = mysqli_stmt_get_result($stm);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM))
{
    var_dump($row); # your result
}
mysqli_stmt_close($stm);
mysqli_close($conn);

Try this:

    $conn = mysqli_connect("localhost", "root", "123456", "test");
    if (mysqli_connect_errno()) {
    die("error".mysqli_connect_error());
    exit();
    }

    $name = 'eliot';
    $last = 'carbone';

    $query=" SELECT * FROM persons WHERE name=? AND last=? ;"

    if($stmt1 = mysqli_prepare($conn, $query)){
        mysqli_stmt_bind_param($stmt1,"ss", $name , $last);

        if(mysqli_stmt_execute($stmt1)){    

            $result = mysqli_stmt_get_result($stmt1);
            if(mysqli_num_rows($result) > 0){
            $foundnum = mysqli_num_rows($result);

            while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){

            echo $name = $row['year'];

                }
            }
        }
    }
    mysqli_stmt_close($stmt1);