예제 #1
0
 public function ambilSemuaSiswaDenganKelas()
 {
     $ps = $this->connection->prepare("SELECT siswa.nomor_siswa,siswa.nama as namaSiswa,kelas.id_kelas,kelas.nama as namaKelas\n\t\t\tFROM siswa INNER JOIN kelas on(siswa.id_kelas=kelas.id_kelas)\n                        ORDER BY namaKelas,namaSiswa");
     $ps->execute();
     $rs = $ps->fetchAll();
     $siswas = new ArrayObject();
     foreach ($rs as $s) {
         $siswa = new Siswa();
         $kelas = new Kelas();
         $siswa->setNomorSiswa($s["nomor_siswa"]);
         $siswa->setNama($s['namaSiswa']);
         $kelas->setIdKelas($s["id_kelas"]);
         $kelas->setNama($s["namaKelas"]);
         $siswa->setKelas($kelas);
         $siswas->append($siswa);
     }
     return $siswas;
 }