<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("button").click(function(){
$("p").toggle();
});
});
</script>
<style type="text/css">
button{
background: none;
border:none;
}
</style>
</head>
<body>
<form action="do.php" method="post">
<input type="text" name="keyword" >
<button type="button"><input type="submit" name="btn" VALUE="搜索"></button>
</form>
<h2 style="color:#f00;">最近搜索</h2>
<?php
header('Content-type:text/html;charset=utf-8');
//连接数据库
$con = mysqli_connect('localhost', 'root', 'root', 'test');
if (!$con) {
die('连接数据库失败，失败原因：'.mysqli_error());
}
//设置数据库字符集
mysqli_query($con, 'SET NAMES UTF8');
//查询最新10条数据
$result = mysqli_query($con, 'SELECT * FROM sou ORDER BY id DESC LIMIT 0,10');
//输出
while ($row = mysqli_fetch_array($result)) {
echo '<p>'.$row['keywords'].'</p>';
}
echo "<h2 style='color:#f00;'>最近热搜</h2>";
//查询搜索次数最多的5条数据
$result = mysqli_query($con, 'SELECT keywords, count(*) as sum FROM sou group by keywords Order By sum DESC LIMIT 0,6');
//输出
while ($row = mysqli_fetch_array($result)) {
echo '<p>'.$row['keywords'].'</p>';
}
//关闭连接
mysqli_close($con);
?>
</body>
</html>
<?php
header('Content-type:text/html;charset=utf-8');
$keyword = $_POST['keyword'];
if ($keyword == '') {
echo "<script>alert('请不要留空！'); history.go(-1);</script>";
} else {
//连接数据库
$con = mysqli_connect('localhost', 'root', 'root', 'test');
if (!$con) {
die('连接数据库失败，失败原因：'.mysqli_error());
}
//设置数据库字符集
mysqli_query($con, 'SET NAMES UTF8');
//查询数据
$result = mysqli_query($con, "SELECT * FROM sou where title like '%$_POST[keyword]%'");
$num = mysqli_num_rows($result);
if ($num) { //如果已经存在
//输出
while ($row = mysqli_fetch_array($result)) {
echo '<p>'.$row['title'].'</p>';
}
} else {
echo '暂无资源！';
}
//插入数据
$conn = mysqli_query($con, "INSERT INTO sou (keywords)
VALUES ('$_POST[keyword]')");
//关闭连接
mysqli_close($con);
}
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- 数据库: `test`
--
-- --------------------------------------------------------
--
-- 表的结构 `sou`
--
CREATE TABLE IF NOT EXISTS `sou` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`keywords` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=120 ;
--
-- 转存表中的数据 `sou`
--
INSERT INTO `sou` (`id`, `title`, `keywords`) VALUES
(1, '一键转发', ''),
(2, '抢红包', ''),
(3, '微信', ''),
(4, 'vpn', ''),
(5, '免费领流量', ''),
(6, '里客云', ''),
(7, '哈哈啊哈', ''),
(8, '轰炸机', ''),
(9, '轰炸机', ''),
(10, '苏泊尔厨电3L智能电饭煲CFXB30FC829-60', ''),
(11, '话费', ''),
(12, '短信', ''),
(13, '视频', ''),
(14, '视频', ''),
(15, '是的福娃十多个', ''),
(16, '个人我个人个改变', ''),
(17, '视频', ''),
(18, '视频', ''),
(19, '视频', ''),
(20, 'AKJGDF', ''),
(21, 'AKJGDF', ''),
(22, 'ASFSAF', ''),
(23, '我完全', ''),
(24, '去文如其人放弃我', ''),
(25, '微信', ''),
(26, '水电费十多个', ''),
(27, '按时发顺丰', ''),
(28, '按时发顺丰', ''),
(29, '啊飒飒晚上发发的话', ''),
(30, '啊飒飒晚上发发的话', ''),
(31, '啊飒飒晚上发发的话', ''),
(32, '', ''),
(33, '', ''),
(34, '1111', ''),
(35, '', ''),
(36, '1111', ''),
(37, '红包', ''),
(38, '去我的期望', ''),
(39, '微信', ''),
(40, '德国大使馆', ''),
(41, '色发给各位哥哥', ''),
(42, '分为氛围', ''),
(43, '哈哈', ''),
(44, '思索', ''),
(45, '思索', ''),
(46, '沙发上地方', ''),
(47, '飞机', ''),
(48, '哈市佛号；撒', ''),
(49, '', '微信'),
(50, '', '微信'),
(51, '', '给io都是一个是一样'),
(52, '', '对方更多更多的是噶生'),
(53, '', '红包'),
(54, '', '红包'),
(55, '', 'haSHAIHFID'),
(56, '', ''),
(57, '', ''),
(58, '', '里客云'),
(59, '', '视频'),
(60, '', ''),
(61, '', ''),
(62, '', ''),
(63, '', ''),
(64, '', '微信'),
(65, '', '微信'),
(66, '', '视频'),
(67, '', '吃饭咯V地方'),
(68, '', '吃饭咯V地方'),
(69, '', '按时发送给哥'),
(70, '', '我哥我人格'),
(71, '', '我特我听过'),
(72, '', '调节人体很热'),
(73, '', '挺好听符合人体'),
(74, '', '而非晚饭'),
(75, '', '我个然后突然让家人'),
(76, '', '色图围观'),
(77, '', 'RTGER '),
(78, '', 'TYUEE5 '),
(79, '', 'ASFFGS '),
(80, '', '司法改革'),
(81, '', '微信'),
(82, '', '微信'),
(83, '', '红包'),
(84, '', '红包'),
(85, '', '红包'),
(86, '', '红包'),
(87, '', '而非晚饭'),
(88, '', '而非晚饭'),
(89, '', '而非晚饭'),
(90, '', '而非晚饭'),
(91, '', '而非晚饭'),
(92, '', '谁的风格'),
(93, '', '谁的风格'),
(94, '', '是地方撒'),
(95, '', '郭德纲'),
(96, '', '郭德纲'),
(97, '', '郭德纲'),
(98, '', '郭德纲'),
(99, '', '啊水电费多少'),
(100, '', '啊水电费多少'),
(101, '', '啊水电费多少'),
(102, '', '啊水电费多少'),
(103, '', '啊水电费多少'),
(104, '', '啊水电费多少'),
(105, '', '啊水电费多少'),
(106, '', '是地方撒'),
(107, '', '反对和热火'),
(108, '', '发帖截图软件认同'),
(109, '', '阿德AF同'),
(110, '', 'TYJRWS'),
(111, '', '风格化'),
(112, '', '而野人'),
(113, '', '就如同和人啊啊'),
(114, '', '二合安静'),
(115, '', '阿德AF同'),
(116, '', '红包'),
(117, '', '微信'),
(118, '', '啊司法所'),
(119, '', '广东省');
网友评论