public function getNewsList()
{
$condition = [];
$cond = [];
if (!empty($_GET['title'])) {
array_push($condition, ["title", "like", "%{$_GET['title']}%"]);
$cond['title'] = $_GET['title'];
}
if (!empty($_GET['status'])) {
array_push($condition, ["status", "=", "{$_GET['status']}"]);
$cond['status'] = $_GET['status'];
}
$data = CaijiModel::where($condition)
->orderBy('id', 'desc')
->paginate(2);
return view('caiji.index', compact('data', 'cond'));
}
<?php
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
<link rel="stylesheet" href="/css/bootstrap.css">
</head>
<body>
<form action="/caiji/getNewsList" method="get">
<input type="text" name="title"><input type="submit" value="查询">
<select name="status">
<option value="1">已审核</option>
<option value="2">未审核</option>
<option value="3">不合法</option>
</select>
</form>
<table border="1">
<th>编号</th>
<th>标题</th>
<th>图片</th>
<th>作者</th>
<th>浏览量</th>
<th>点赞量</th>
<?php foreach ($data as $key => $v): ?>
<tr>
<td><?php echo $v['id']; ?></td>
<td><a href="/caiji/info/{{$v['id']}}"><?php echo $v['title']; ?></a></td>
<td><img src="<?php echo $v['img']; ?>"/></td>
<td><?php echo $v['author']; ?></td>
<td><?php echo $v['views']; ?></td>
<td><?php echo $v['zan']; ?></td>
</tr>
<?php endforeach; ?>
</table>
{{$data->appends($cond)->links()}}