Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- <title>Поиск: <?php session_start(); echo $_GET['query'];?></title>
- <link rel="stylesheet" href="/css/main.css" type="text/css">
- </head>
- <div class="header"><?php include_once 'includes/header.php'; include_once 'includes/functions.php'; include_once 'includes/db.php'?></div>
- <div class="main">
- <div class="left">Категории<hr>
- <?php echo getCatMatListAll(); ?>
- </div>
- <div class="content">
- <?php
- if(!empty($_GET['query'])) {
- $query = mysql_real_escape_string($_GET['query']);
- $queries = array_unique(preg_split("/[,. ]/", $query));
- $q = '';
- if(count($queries)>1) {
- for($i=0; $i<count($queries); $i++) {
- $q.=" OR (`name` LIKE '%$queries[$i]%'";
- $q.=" OR short_description LIKE '%$queries[$i]%'";
- $q.=" OR full_description LIKE '%$queries[$i]%')";
- }
- }
- $query = "SELECT * FROM `data`
- WHERE (
- (`name` LIKE '%$query%'
- OR short_description LIKE '%$query%'
- OR full_description LIKE '%$query%'
- )".$q.")
- AND (data.id IN (SELECT data_id FROM data_category WHERE maincat_id
- IN (SELECT id FROM categories WHERE active=1)))
- ";
- //exit($query);
- //echo $query;
- $results = mysql_query($query);
- if(mysql_num_rows($results)!=0) {
- echo '<table border=0 align=center>';
- echo '<tr><td>Результаты поиска по запросу <b>'.$_GET['query'].'</b>. Найдено совпадений: '.mysql_num_rows($results);
- echo '<td></tr>';
- while ($row = mysql_fetch_object($results)) {
- echo '<tr><td><a href=/file.php?id='.$row->id.'>'.str_replace($_GET['query'],'<b>'.$_GET['query'].'</b>',$row->name).'</a></td></tr>';
- echo '<tr"><td>'.str_replace($_GET['query'],'<b>'.$_GET['query'].'</b>',$row->full_description).'</td></tr>';
- echo '<tr"><td><hr></td></tr>';
- }
- echo '</table>';
- }
- }
- else {
- echo "Не задан запрос для поиска";
- }
- ?>
- </div>
- </div>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement