<?php
namespace App\Models;

class NamaModelBaru extends \App\Plugin\DataTablesMysql
{
    /* Constructor */
    public function __construct(\Slim\Container $container)
    {
        /* Call Parent Constructor */
	parent::__construct($container);
    }

    public function NamaMethodPdo($id)
    {
        try {
            // gunakan $this->db->pdo untuk mengakses fungsi pdo
            $sql = $this->db->pdo->prepare("SELECT * FROM tabel_tujuan WHERE id =:id");
            $query = $this->db->pdo->prepare($sql);
            $query->bindParam(':id', $ud, \PDO::PARAM_INT);
            $query->execute();
            $output = $query->fetchAll(\PDO::FETCH_ASSOC);
            return $output;
        } catch (\Exception $e) {
            //overrideSQLMsg untuk mengganti error menjadi bahasa Indonesia
            throw new \Exception($this->overrideSQLMsg($e->getMessage()));
        }        
    }

    public function NamaMethodQuery()
    {
        try {
            return $this->db->query("SELECT * FROM tabel_tujuan")->fetchAll();
        } catch (\Exception $e) {
            //overrideSQLMsg untuk mengganti error menjadi bahasa Indonesia
            throw new \Exception($this->overrideSQLMsg($e->getMessage()));
        }        
    }
}