fragment

fragm1.php

<?php

if (!isset($_GET['params']))
{

	if ($result = $pdo->query("SELECT a.title, b.category FROM `chase` AS a
								JOIN `categories` AS b ON a.cat_id = b.id"))
	{

		$result->execute();
		
		$data = $result->fetchAll(PDO::FETCH_ASSOC);
		
		foreach ($data as $value)
		{
			$cool[$value['category']][] = $value['title'];
		}
		
		foreach ($cool as $article => $name)
		{
			
			echo "<h1><a href='".strtolower($article)."'>".$article."</a></h1>";
			
			echo "<div class='content'>";
			
			echo "<div>";
			
			foreach ($name as $title) 
			{
			
				echo "<p><a href='".strtolower($article)."/".strtolower(translitIt($title))."'>".$title."</a></p>";
			
			}
			
			echo "</div>";
			
			echo "</div>";
		
		}
		
	}

}
else 
{

	$explode = explode("/",$_GET['params']);
	
	if (count($explode)==1)
	{
	
		$cat = $explode[0];
		
		if ($result = $pdo->prepare("SELECT `id` FROM `categories` WHERE `category`=:cat"))
		{
		
			$result->bindParam(":cat",$cat,PDO::PARAM_STR);
			$result->execute();
			$cat_id = $result->fetch(PDO::FETCH_ASSOC);
			
			$cat_id = (int) $cat_id['id'];
			
			if ($result = $pdo->prepare("SELECT `title` FROM `chase` WHERE `cat_id`=:cat_id"))
			{
			
				$result->bindParam(":cat_id",$cat_id,PDO::PARAM_INT);
				$result->execute();
				
				$articles = $result->fetchAll(PDO::FETCH_ASSOC);
				
				echo "<h1><a href='http://bawyka.loc/".$cat."'>". $cat . "</a></h1>";
				
				echo "<div class='content'>";
	
				
				foreach ($articles as $article)
				{
				
					echo "<p><a href='http://bawyka.loc/".$cat."/".$article['title']."'>".$article['title']."</a></p>";
				
				}
			
				echo "</div>";
			
			}
			
			
		
		}
		
	
	}
	else
	{
	
		echo $explode[0] . " ". $explode[1];
	
	}
	

}