<?php
	$DB_HOST = "nk2ishere.ga";
  $DB_LOGIN = "fair";
  $DB_PASSWORD = "imafair_lul_alikhanov_loves_me";
  $DB_NAME = "fair";

	$code = 0;

	$parent_category_id = $_GET['parent_category_id'];

	try {  
		$DBH = new PDO("mysql:host=$DB_HOST;dbname=$DB_NAME", $DB_LOGIN, $DB_PASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'')); 
	}
	catch(PDOException $e) {  
		var_dump($e);
	}

	if ($code == 0){
		$result = array();
		$DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		try 
		{  
			$sql = $DBH->prepare("SELECT * FROM `categories` WHERE `parent_category_id` = ?");
			$sql -> bindValue(1, $parent_category_id, PDO::PARAM_INT);
			$sql ->execute();
			while($row = $sql->fetch(PDO::FETCH_ASSOC)) 
			{
				$row_array = array();
				$row_array['id'] = intval($row['id']);
				$row_array['name'] = $row['name'];
				$row_array['img'] = $row['img_url'];
				$row_array['parentCategoryId'] = $row['parent_category_id'];
				$row_array['isRelated'] = (bool)$row['is_related'];
				array_push($result, $row_array);
			}
		}catch(PDOException $e) {  
			
		}
	}
	if ($code == 0)
	{
		echo json_encode($result);
	}else{
		header('HTTP/1.0 404 Not Found', true);
		echo 1;
	}
?>