Number of variables doesn't match number of parameters in prepared statement

$query = mysqli_prepare($db, "SELECT * FROM `users_db` WHERE `user_name`='?' || `e_mail`='?'");
mysqli_stmt_bind_param($query, 'ss', $name, $name);
$raw_data = mysqli_stmt_execute($query);
$data = mysqli_fetch_array($query, MYSQLI_ASSOC);
print_r($data);

    /* bind result variables */
    mysqli_stmt_bind_result($stmt, $name, $code);
 
    /* fetch values */
    while (mysqli_stmt_fetch($stmt)) {
        printf ("%s (%s)\n", $name, $code);
    }

$stmt->execute();
        $result = $stmt->get_result();
        while ($row = $result->fetch_array()) { ... }

while ($row = $result->fetch_array()) { ... }

where($row = mysql_fetch_array($result))
{
    // вывод
}

where($row = mysqli_fetch_array($result))
{
    // вывод
}

$db = new MySQLi('localhost', 'imgswow', 'password', 'imgswow');
    $tmp = $db->prepare("SELECT * FROM users_db WHERE user_name=?");
    $tmp->bind_param('s', $name);
    $tmp->execute();
    $result_ = $tmp->get_result();
    $result = $result_->fetch_assoc();