public function addnewcategory() { if (Request::isMethod('post')) { $data = Input::all(); $data = Input::except(array('_token')); $data['created'] = date('Y-m-d H:i:s'); $slug = DB::table('categories')->select(DB::raw('COUNT(slug) as slugnum'))->where('slug', Input::get('slug'))->get(); if ($slug[0]->slugnum > 0) { $data['slug'] = $slug[0]->slugnum; } DB::table('categories')->insert($data); return Redirect::to('admin/category/add-new'); } $list = Categories::dropdown(); $data['parent'] = $list; $items = categories::tree(); return View::make('admin.addcategory', $data); }