php - 如何从 SQL 中选择多条记录并插入到 Session 中

Question

我正在寻找如何将 SQL 表中的多条记录插入到 session 变量或多个唯一 session 变量中。

$userID = $_SESSION['user']['id']; 

$coursequery = " 
            SELECT
                coursename,
                location,
                description 
            FROM courses 
            WHERE 
                teacherID = '$userID' 
        "; 

        try 
        { 
            $stmt = $db->prepare($coursequery); 
            $result = $stmt->execute(); 
        } 
        catch(PDOException $ex) 
        {  
            die("Failed to run query: " . $ex->getMessage()); 
        } 

        $row = $stmt->fetch(); 

            $_SESSION['courseinfo'] = $row;   

“courses”表里面有几条记录，所有的teacherID都是当前userID的，定义在开头。当我 print_r($_SESSION['courseinfo']);它只显示表中的一条记录。

我正在尝试创建一个循环来显示每条记录所抓取的所有信息，因为您无法确定在任何给定时间将抓取多少条记录。非常感谢任何答案!

Answer 1

$userID = $_SESSION['user']['id']; 

$coursequery = " 
            SELECT
                coursename,
                location,
                description 
            FROM courses 
            WHERE 
                teacherID = '$userID' 
        "; 

        try 
        { 
            $stmt = $db->prepare($coursequery); 
            $result = $stmt->execute(); 
        } 
        catch(PDOException $ex) 
        {  
            die("Failed to run query: " . $ex->getMessage()); 
        } 

        while ($row = $stmt->fetch()):

         $row['YourColumn'];

         endwhile;

使用 while() 循环根据您的查询获取所有记录