\App\Models\Articles::create(['article_title' => '文章測試Facade', 'article_content' => '這是一篇測試文章，第Facade篇。', 'feature' => rand(0, 1), 'page_view' => rand(0, 200), 'created_at' => Carbon::now('Asia/Taipei'), 'updated_at' => Carbon::now('Asia/Taipei')]);
echo "Facade!!<br />";
// 使用new建構式
$post = new \App\Models\Articles();
$post->article_title = '文章測試new';
$post->article_content = '這是一篇測試文章，第new篇。';
$post->feature = rand(0, 1);
$post->page_view = rand(0, 200);
$post->created_at = Carbon::now('Asia/Taipei');
$post->updated_at = Carbon::now('Asia/Taipei');
$post->save();
echo "new!!<br />";
}]);
Route::get('search', ['as' => 'ORM.search', function () {
// 收尋資料
$data = \App\Models\Articles::all();
// var_dump($data);
// exit();
dd($data);
// 條件收尋
$data = \App\Models\Articles::where('feature', '=', true)->orderBy('id')->get();
// dd($data);
}]);
Route::get('update', ['as' => 'ORM.update', function () {
// 更新資料
$data = \App\Models\Articles::find(1);
$data->update(['article_title' => 'update test.', 'feature' => true]);
$data = \App\Models\Articles::where('id', '=', 10);
$data->update(['article_title' => 'update test=3=.', 'feature' => false]);
// save方法
$data = \App\Models\Articles::where('id', '=', 11)->first();
public function delete($slug)
{
if (Input::has('selected_article')) {
return Redirect::to('admin/articles/' . Input::get('selected_article') . '/delete');
} else {
if (Input::has('confirmed_delete')) {
try {
$article = Articles::where($slug, $slug)->get();
Articles::where('slug', $slug)->get()->delete();
return View::make('admin.articles.delete', ['status' => 'successful', 'article' => $article, 'articles' => Articles::all(), 'id' => $article->id]);
} catch (Illuminate\Database\Eloquent\ModelNotFoundException $e) {
return View::make('admin.articles.delete', ['status' => 'unsuccessful', 'article' => $article, 'id' => $id]);
}
} else {
$article = Articles::where('slug', $slug);
return View::make('admin.articles.delete', ['status' => 'confirm', 'article' => $article, 'articles' => Articles::all(), 'id' => $id]);
}
}
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$qArticles = Articles::all();
return view('admin.article.index', compact('qArticles'));
}
