public function watch($id) { $video = DB::table('katalog')->leftjoin('publisher', 'katalog.publisher', '=', 'publisher.id')->where('katalog.id', '=', $id)->get(array('katalog.id', 'katalog.title', 'katalog.release', 'katalog.numpage', 'publisher.publishername', 'katalog.file', 'katalog.ISBN')); $authors = AuthorKatalog::get_author_katalog($id); $katalog = Katalog::find($id); $katalog->view++; $katalog->save(); return View::make('front.watch', compact('video', 'authors')); }
public function delPublisher($id) { $katalog = Katalog::where('publisher', '=', $id)->get(); foreach ($katalog as $value) { $k = Katalog::find($value->id); $k->publisher = NULL; $k->save(); } $publisher = Publisher::find($id); $publisher->delete(); return Redirect::to('admin/publisher'); }