无法获取名称、用户名和密码


Cannot fetch the name,username and password

当我尝试登录它显示不正确的用户详细信息。虽然数据被插入,但没有被取走。以下是我的两个PHP文件。

Register.php

<?php
$con=mysqli_connect("mysql.hostinger.in","name","password","u721174658_swap");

$name = $_POST["name"];
$username = $_POST["username"];
$password = $_POST["password"];
$statement = mysqli_prepare($con, "INSERT INTO `user` (name,username, password) VALUES (?, ?, ?)");
mysqli_stmt_bind_param($statement, "sss", $name,$username, $password);
mysqli_stmt_execute($statement);

mysqli_stmt_close($statement);
mysqli_close($con);
?>

FetchUserData.php

<?php
$con=mysqli_connect("mysql.hostinger.in","name","password","u721174658_swap");

$username = $_POST["username"];
$password = $_POST["password"];
$statement = mysqli_prepare($con, "SELECT * FROM `user` WHERE username = ? AND password = ?");
mysqli_stmt_bind_param($statement, "ss", $username, $password);
mysqli_stmt_execute($statement);
mysqli_stmt_store_result($statement);
mysqli_stmt_bind_result($statement, $userID, $name,$username, $password);
$user = array();
while(mysqli_stmt_fetch($statement)){
    $user["name"] = $name;
    $user["username"] = $username;
    $user["password"] = $password;
}
echo json_encode($user);
mysqli_close($con);
?>

使用下列方式获取和启动会话

    while($row= mysql_fetch_array($statement){
    $name = $row['name'];
}