<?php
class DbOperation{
	private $con;

	function __construct(){
		require_once dirname(__FILE__) . '/Dbconnect.php';
		$db = new Dbconnect();
		$this->con = $db->connect();
	}

		public function getJenisMakanan(){
			$stmt = $this->con->prepare("
					SELECT noid, nama,
					desk, gmbr FROM tb_jenis;
				");
			$stmt->execute();
			$result = $stmt->get_result();
			return $result;
		}

		public function getProduk(){

			$stmt = $this->con->prepare("
					SELECT * FROM tb_produk INNER JOIN tb_jenis ON produk_noid = produk_noid;
				");

			$stmt->execute();
			$result = $stmt->get_result();
			return $result;
		}

	}