/**
* 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>');
}
}
