public function frontendIndex(Request $request)
{
$page = $request->input('page', 1);
$limit = 20;
$offset = ($page - 1) * $limit;
$result = News::offset($offset)->take($limit)->get();
$result1 = DB::table('parent_menu')->get();
$siteTitle = Setting::where('name', 'title')->get();
if (count($siteTitle) > 0) {
$bah = $siteTitle->first()->value;
} else {
$bah = 'Website';
}
$footer = Setting::where('name', 'footer')->get();
if (count($footer) > 0) {
$footer = $footer->first()->value;
} else {
$footer = '(c) 2015, Ordent, All Right Reserved.';
}
$logo = Setting::where('name', 'logo')->get();
if (count($logo) > 0) {
$logo = asset('/uploads/logo/') . '/' . $logo->first()->value;
$logo = preg_replace('/\\s+/', '', $logo);
} else {
$logo = '#';
}
$count = ceil(count(News::all()) / 20);
return view('frontend.news-index', compact('result', 'title', 'result1', 'footer', 'count', 'logo'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$news = News::all()->where('status_id', 3);
return view('front.news.index', compact('news'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
return $news = News::all();
return $news;
}
/**
* Display a listing of the resource in administration side.
*
* @return Response
*/
public function admin()
{
$news = News::all();
return view('news.backend.index', compact('news'));
}
<br/><br/>
<div class="dataTable_wrapper">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th>Title</th>
<th width="30%">Category</th>
<th width="10%">Edit</th>
<th width="10%">Delete</th>
</tr>
</thead>
<tbody>
<?php
use App\Models\News;
use App\Models\Category;
$news = News::all();
?>
@foreach ($news as $item)
<tr>
<td><?php
echo $item->nTitle;
?>
</td>
<td><?php
echo Category::find($item->catId)->catName;
?>
</td>
<td><a href="{{URL::to('news/edit',$item->nId)}}">Edit</a></td>
<td><a href="{{URL::to('deleteNews',$item->nId)}}" onclick="if(!confirm('Are you sure to delete this item?')){return false;};" title="Delete this Item">Delete</a></td>
</tr>
@endforeach