Praktikum 07 - Menggunakan PDO

<?php
class usePDO
{
    private $host = "localhost";
    private $user = "root";
    private $pass = "";
    private $base = "webpro";
    protected $connect;

    public function __construct()
    {
        $this->connect = new PDO(
            "mysql:host={$this->host};dbname={$this->base}",
            $this->user,
            $this->pass
            );
    }

    public function query($query)
    {
        return $this->connect->query($query);
    }

}

class pegawai extends usePDO
{

    public function getListPegawai()
    {
        $query = "
            select
                a.nip, a.nama, b.nama_unit
            from
                prt7_pegawai as a
            join
                prt7_unit as b
            on
                a.unit=b.id_unit
            ";

        return $this->query($query);
    }

}

$pegawai = new pegawai();
$result = $pegawai->getListPegawai();

?>

<table border="1">
    <thead>
        <tr>
            <td>NIP</td>
            <td>Nama</td>
            <td>Unit</td>
        </tr>
    </thead>
    <tbody>
        <?php while ($row = $result->fetch(PDO::FETCH_OBJ)) : ?>
            <tr>
                <td><?= str_pad($row->nip, 3, 0, STR_PAD_LEFT); ?></td>
                <td><?= $row->nama; ?></td>
                <td><?= $row->nama_unit; ?></td>
            </tr>
        <?php endwhile; ?>
    </tbody>
</table>