PHP PDO Sql connection from a Class.

[G1K777]

Hi,

I'm trying to connect to my database and it doesn't work for some reason.

Why isn't this working? Woke up at 2am and now sitting and doing the login system.

userlist.php
 

include_once 'dbh.php';

class Users extends Dbh
{
    private $sql = 'SELECT id,username FROM users';

    function __construct()
    {
        parent::__construct();
    }

    public function getUsers(){
        return $this->conn->query($this->sql);
    }
}

$users = new Users();

$result = $users->getUsers();
echo var_dump($result);

dbh.php
 

<?php

class Dbh
{
    private $host = '127.0.0.1';
    private $port = '3306';
    private $username = 'root';
    private $password = '123';
    private $dbname = 'loginsystemdb';
    private $charset = 'utf8mb4';

    protected $conn;

    function __construct()
    {
        try {
            $this->conn = new PDO("mysql:host=$this->host;port=$this->port;dbname=$this->dbname;charset=$this->charset", $this->username, $this->password);
            $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            return $conn;
        } catch (PDOException $e) {
            echo 'Mysql Connection failed: '.$e->getMessage();
        }
    }
}

 

[leodaniel]

You should use the prepare method

<?php

$statement = $this->conn->prepare($this->sql);
$statement->execute();
return $statement->fetchAll(\PDO::FETCH_ASSOC);