<?php
require 'vendor/autoload.php';
require 'libs/NotORM.php';

//membuat dan mengkonfigurasi slim app
$app = new \Slim\app;

// konfigurasi database
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'mabes_tni';
$dbmethod = 'mysql:dbname=';

$dsn = $dbmethod.$dbname;
$pdo = new PDO($dsn, $dbuser, $dbpass);
$db  = new NotORM($pdo);

//mendefinisikan route app untuk home
$app-> get('/', function(){
    echo "selamat datang mabes tni";
});

// fungsi untuk mengambil berita
$app->get('/allarticles', function() use($app, $db) {
	// fungsi query di table article
	$q = $db->article->order("id desc");

	// check jumlah article di table
	if(count($q) > 0){

		// looping data di table
		foreach ($q as $data) {

			// Tampung di variabel array
			$article['article'][] = array(
					'id' => $data['id'],
					'title' => $data['title'],
					'tanggal' => $data['tanggal'],
					'content' => $data['content'],
					'image' => $data['image'],
				);

		}
		$article['code'] = 200;
		// output json
		echo json_encode($article);

	}else{

	}

});

$app->run();
?>