设置按view的大小排序提供具体代码php$search = $_GETsearch;$page = isset$_GETpage $_GETpage 1;$number = 20;$page_max = $page $number;$page_min = $page - 1 $number;$con = mysqli_connectlocalhost us420092414795 pO0
要按照view的大小进行排序,只需要在查询语句中加上ORDER BY view DESC即可。以下是修改后的代码:
$search = $_GET['search'];
$page = isset($_GET['page']) ? $_GET['page'] : 1;
$number = 20;
$page_max = $page * $number;
$page_min = ($page - 1) * $number;
$con = mysqli_connect("localhost", "us420092414795", "pO0qm4xlpDZC");
if (!$con) {
die('Could not connect: ' . mysqli_error($con));
}
mysqli_set_charset($con, "utf8");
mysqli_select_db($con, "us420092414795");
$result = mysqli_query($con, "SELECT * FROM search WHERE (name LIKE '%" . $search . "%' OR lianjie LIKE '%" . $search . "%' OR shows LIKE '%" . $search . "%') ORDER BY view DESC LIMIT " . $page_min . ", " . $number);
$lianjie_count = mysqli_query($con, "SELECT COUNT(*) AS total_count FROM search WHERE (name LIKE '%" . $search . "%' OR lianjie LIKE '%" . $search . "%' OR shows LIKE '%" . $search . "%')");
$row = mysqli_fetch_array($lianjie_count);
$total_count = $row['total_count'];
$numerator = $total_count; // 分子
$denominator = $number; // 分母
$page_count = ceil($numerator / $denominator);
$result = mysqli_query($con, "SELECT * FROM search WHERE (name LIKE '%" . $search . "%' OR lianjie LIKE '%" . $search . "%' OR shows LIKE '%" . $search . "%') LIMIT " . $page_min . ", " . $number . "");
$arr = array();
while ($row = mysqli_fetch_array($result)) {
$arr[] = $row;
}
这样,查询结果会按照view的大小进行排序
原文地址: http://www.cveoy.top/t/topic/iNqW 著作权归作者所有。请勿转载和采集!