mysqli connection prepare statement (PHP)

PHP code to connect and fetch the data from

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test_pdo_db";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$password = "mypassword2";
$email = "john2@example.com";


//Insert code
$stmt = $conn->prepare("INSERT INTO users (email, password) VALUES (?, ?)");
$stmt->bind_param("ss", $email,$password);
$stmt->execute();

//Select code by email id
$stmt = $conn->prepare("SELECT * FROM users WHERE email = ?");
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_array(MYSQLI_ASSOC); //statement to get single record


//Select code by all
$stmt = $conn->prepare("SELECT * FROM users");
$stmt->execute();
$result = $stmt->get_result();
$user = $result->fetch_all(MYSQLI_ASSOC); // statement to get multiple records

print_r($user);

$conn->close();

die;