21,882
社区成员
发帖
与我相关
我的任务
分享
$search=$_GET['search'];
if(!$search){
echo '无信息';
}else{
$q=mysqli_query($db,"select * from html union all
select * from css union all
select * from js union all
select * from asp union all
select * from php union all
select * from mysql
where title like '".$search."'
order by date desc");
while($row=mysqli_fetch_array($q)){
echo "<div class=\"search_box\">
<div class=\"search_title\">".htmlspecialchars($row['title'])."</div>
<div class=\"search_con\">".htmlspecialchars($row['con'])."</div><div class=\"search_date\">".$row['date']."</div> </div>";
}
}
$query=mysqli_query($db,"select title,date from html union all select title,date from css union all select title,date from js order by date desc limit 22");
while($row=mysqli_fetch_array($query)){
echo htmlspecialchars($row['title'])."<br>";
}