在php函数中显示来自mysql的多行

Question

I have this PHP function i am using to retrieve rows from a mysql database:

$stmt = $pdo_conn->prepare("SELECT * from admin where sequence > :sequence ");
        $stmt->execute(array(':sequence' => $user_sequence));
        $records = $stmt->fetchAll(PDO::FETCH_ASSOC);
        $results=array();
        foreach($records as $results) {
            return $results;
        }

here i am calling the function:

$test = AdminUserSessionID2('2');
echo $test["forename"];

but it is only displaying one row, what have i done wrong which is making it not display all rows?

Answer 1

Why return in foreach? Of course it will return just the first row. It's like saying foreach(rows as row){ return row; }.

<?php
function MyFunction($user_sequence){
    global $pdo_conn;
    $stmt = $pdo_conn->prepare("SELECT * from admin where sequence > :sequence;");
    $stmt->execute(array(':sequence' => $user_sequence));
    $records = $stmt->fetchAll(PDO::FETCH_ASSOC);
    return $records;
}
var_dump(MyFunction($user_sequence));
?>