<?php
 class Data_anggota_new {
     private $mysqli;

     function __construct($conn)
     {
         $this->mysqli = $conn;
     }

     public function tampil($id = null)
     {
        $db = $this->mysqli->conn;
        $sql = "SELECT id_jurusan, jurusan FROM tb_jurusan INNER JOIN tb_anggota ON tb_jurusan.id_jurusan = tb_anggota.id_jurusan";
        if ($id != null)
        {
            $sql .= " WHERE id_jurusan = $id";
        }
        $query = $db->query($sql) or die ($db->error);
        return $query;
     }
 }

?>