/** * Insert the values to the article table * @param type Article $article * @param type ArticleRequest $request * @return type */ public function store(Article $article, ArticleRequest $request) { $sl = $request->input('slug'); $slug = str_slug($sl, "-"); $article->slug = $slug; $article->fill($request->except('created_at', 'slug'))->save(); $requests = $request->input('category_id'); $id = $article->id; foreach ($requests as $req) { DB::insert('insert into article_relationship (category_id, article_id) values (?,?)', [$req, $id]); } /* insert the values to the article table */ if ($article->fill($request->except('slug'))->save()) { return redirect('article')->with('success', 'Article Inserted Successfully'); } else { return redirect('article')->with('fails', 'Article Not Inserted'); } }
/** * Insert the values to the article * @param type Article $article * @param type ArticleRequest $request * @return type redirect */ public function store(Article $article, ArticleRequest $request) { // requesting the values to store article data $sl = $request->input('slug'); $slug = str_slug($sl, "-"); $article->slug = $slug; $article->fill($request->except('created_at', 'slug'))->save(); // creating article category relationship $requests = $request->input('category_id'); $id = $article->id; foreach ($requests as $req) { DB::insert('insert into kb_article_relationship (category_id, article_id) values (?,?)', [$req, $id]); } /* insert the values to the article table */ try { $article->fill($request->except('slug'))->save(); return redirect('article')->with('success', 'Article Inserted Successfully'); } catch (Exception $e) { return redirect('article')->with('fails', 'Article Not Inserted' . '<li>' . $e->errorInfo[2] . '</li>'); } }