| Server IP : 104.21.80.248 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/news/cooprat/src/ |
Upload File : |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<link href="bootstrap/css/font-awesome.css" rel="stylesheet">
<link href="css/style.css" rel="stylesheet">
<script src="bootstrap/js/jquery-1.9.0.min.js"></script>
<style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.style1 {color: #666666}
-->
</style></head>
<body>
<?php
include('db.php');
if($_POST)
{
$q = mysqli_real_escape_string($mysqli,$_POST['search']);
$strSQL_Result = mysqli_query($mysqli,"select `posts`.`id`,
`posts`.`title`,`posts`.`image`,`users`.`school`,`posts`.`date`,
`categories`.`c_name`,`users`.`name` FROM `posts` INNER JOIN `categories` ON `posts`.`cat_id` = `categories`.`id` INNER JOIN `users` ON `posts`.`uid` = `users`.`id` where title like '%$q%' or c_name like '%$q%' or name like '%$q%' limit 6");
while($row=mysqli_fetch_array($strSQL_Result))
{
$id = $row['id'];
$title= $row['title'];
$c_name= $row['c_name'];
$name= $row['name'];
$image= $row['image'];
$date= $row['date'];
$b_id = '<strong>'.$q.'</strong>';
$b_title = '<strong>'.$q.'</strong>';
$b_c_name = '<strong>'.$q.'</strong>';
$b_name = '<strong>'.$q.'</strong>';
$final_id = str_ireplace($q, $b_id, $id);
$final_title = str_ireplace($q, $b_title, $title);
$final_c_name = str_ireplace($q, $b_c_name, $c_name);
$final_name = str_ireplace($q, $b_name, $name);
?>
<div class="show" align="left">
<a href="http://news.sesao8.go.th/story-<?php echo $id ?>.html" target="_blank" >
<img src="<?=$image; ?>" style="width:100px; height:70px; float:left; margin-right:6px;" />
<span class="name"><font color="#00CC00"><?php echo $final_title; ?></font></span> <br/>
<font color="#999999"><?php echo $final_c_name ; ?> <?php echo $date ; ?></font>
</a>
</div>
<?php
}
}
?>
</body>
</html>