1. <?php
    2. $dsn='mysql:host=localhost;port=3306;dbname=test;charset=utf8';
    3. $pdo=new PDO($dsn,'root','root');
    4. $stmt=$pdo->query("select * from admin");
    5. echo "<pre>";
    6. //$rs=$stmt->fetchALL(PDO::FETCH_BOTH); //默认返回关联和索引
    7. //$rs=$stmt->fetchALL(PDO::FETCH_NUM); //返回索引数组
    8. //$rs=$stmt->fetchALL(PDO::FETCH_ASSOC); //返回关联数组
    9. //echo $stmt->fetchColumn(2); 返回当前行的第三列
    10. ?>

    image.png
    image.png
    image.png