Wester
Новичок
- Регистрация
- 31.10.2017
- Сообщения
- 1
<body>
<div id="wrapper">
<?php include "config/header.php"; ?>
<div id="content">
<div class="container">
<div class="row">
<section class="content__left col-md-8">
<div class="block">
<a href="/article.php">Все записи</a>
<h3>Новое в блоге</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id'];?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
</div>
</div>
</div>
<div class="block">
<a href="article.php?category=<?php echo $art_cat ['id']; ?>">Все записи</a>
<h3>Солнечная система [Новое]</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` WHERE `category_id` = 4 ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id']; ?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
</div>
</div>
</div>
<div class="block">
<a href="article.php?category=<?php echo $art_cat ['id']; ?>">Все записи</a>
<h3>Space IT [Новое]</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` WHERE `category_id` = 3 ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id']; ?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
Нужно что бы при нажатии на "Все записи" в блоке "Солнечная система " или "SPACE IT" выводились все статьи именно из этих категорий. Полный код в закрепленной странице. Article - это страница где выводятся все статьи
<div id="wrapper">
<?php include "config/header.php"; ?>
<div id="content">
<div class="container">
<div class="row">
<section class="content__left col-md-8">
<div class="block">
<a href="/article.php">Все записи</a>
<h3>Новое в блоге</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id'];?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
</div>
</div>
</div>
<div class="block">
<a href="article.php?category=<?php echo $art_cat ['id']; ?>">Все записи</a>
<h3>Солнечная система [Новое]</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` WHERE `category_id` = 4 ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id']; ?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
</div>
</div>
</div>
<div class="block">
<a href="article.php?category=<?php echo $art_cat ['id']; ?>">Все записи</a>
<h3>Space IT [Новое]</h3>
<div class="block__content">
<div class="articles articles__horizontal">
<?php
$articles = mysqli_query($connection, "SELECT * FROM `articles` WHERE `category_id` = 3 ORDER BY `id` DESC LIMIT 4");
while($art = mysqli_fetch_assoc($articles) )
{
?>
<article class="article">
<div class="article__image" style="background-image: url(/static/images/<?php echo $art['images'];?>);"></div>
<div class="article__info">
<a href="/articles.php?id=<?php echo $art ['id']; ?>"><?php echo $art['title'];?></a>
<div class="article__info__meta">
<?php
$art_cat = false;
foreach ($category as $cat)
{
if($cat['id'] == $art['category_id'])
{
$art_cat = $cat;
break;
}
}
?>
<small>Категория: <a href="/articles.php?category=<?php echo $art_cat['id']; ?>"><?php echo $art_cat['title']; ?></a></small>
</div>
<div class="article__info__preview"><?php echo mb_substr (strip_tags($art['text']), 0, 100, 'utf-8') . ' ...'; ?></div>
</div>
</article>
<?php
}
?>
Нужно что бы при нажатии на "Все записи" в блоке "Солнечная система " или "SPACE IT" выводились все статьи именно из этих категорий. Полный код в закрепленной странице. Article - это страница где выводятся все статьи
