php - 获取mysql数据PDO

Question

我是 PDO 新手，我正在尝试从我的 mysql 表中获取数据，我查看了网络和其他 stackoverflow 答案，但它们似乎都添加了额外的代码，这让我感到困惑。

我只想回显到目前为止我得到的一个表中的所有数据:

<?php
$sth = $dbh->prepare("SELECT name, location, age FROM students");
$sth->execute();

$result = $sth->fetchAll(PDO::FETCH_CLASS, "students");
var_dump($result);
?>

连接信息

function getConnection()
{
    $DCONFIG_server = "localhost";
    $DCONFIG_DBuser = "root";
    $DCONFIG_DBpass = "root";
    $DCONFIG_dbname = "school";

    $conn = null;

    try
    {
        $conn = new PDO("mysql:host=$DCONFIG_server;dbname=$DCONFIG_dbname",$DCONFIG_DBuser, $DCONFIG_DBpass );
    }
    catch(PDOException $e)
    {
        echo $e->getMessage();
    }

    return $conn;
}

Answer 1

你们类有同学吗？

<?php
    class students {
        public $name;
        public $location;
        public $age;
    }
$sth = $dbh->prepare("SELECT name, location, age FROM students");
$sth->execute();

$result = $sth->fetchAll(PDO::FETCH_CLASS, "students");
var_dump($result);
?>