2017-03-31 16:42
浏览 36


I'm using doctrine to fetch data from my MySQL database. This is all done in Silex. These are the lines of code that enable Doctrine for me.

$config = new \Doctrine\DBAL\Configuration();
$connParams = array(
    'driver'   => 'pdo_mysql',
    'dbname'   => 'webshop',
    'host'     => 'localhost',
    'user'     => 'root',
    'password' => '',
    'charset'  => 'utf8'
$conn = \Doctrine\DBAL\DriverManager::getConnection($connParams, $config);
$app['dbcon'] = $conn;

$app->get('/', function () use ($app){

    $user = new User($app['dbcon']);

    return $app['twig']->render('home.twig', [
        'content' => 'Home',


And I'm trying to create a user class for login stuff etc. The user class looks like this:


namespace Models;

class User
    private $db;

    public function __construct($db)
        $this->db = $db;
        $query = $this->db->prepare("SELECT * FROM users");

        $query = $query->fetchAll();

        foreach($query as $user){


Though, the following is the result:

Array ( [id] => 1 [username] => araguera [password] => password [salt] => ksjdfiwe98ru2w98h )

Why does it return as an array and not as an object? Because I want to be able to do something like "$query->username".

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dousuo8400 2017-03-31 17:05

    To add to u_mulder's comment, you can use PDO style to fetch results as object:

    $res = $query->fetchAll(\PDO::FETCH_OBJ);

    And in case you want to use fetch (to get one row) you can use:

    $res = $query->fetchObject();
    点赞 打赏 评论

相关推荐 更多相似问题