<?php
    $DB_HOST = "localhost";
  $DB_LOGIN = "fair";
  $DB_PASSWORD = "imafair_lul_alikhanov_loves_me";
  $DB_NAME = "fair";

	$code = 0;

	$category_id = $_GET['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) {
		
	}
	if ($code == 0){
		$result = array();
		$DBH->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		try{
			$sql = $DBH->prepare("SELECT * FROM `products` WHERE `category_id` = ?");
			$sql -> bindValue(1, $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'];
				$row_array['orders'] = intval($row['orders']);
				$row_array['description'] = $row['description'];
				$row_array['price'] = intval($row['price']);
				$row_array['seller_id'] = intval($row['seller_id']);
				$row_array['category_id'] = intval($row['category_id']);
				$row_array['likes'] = intval($row['likes']);
				$row_array['dislikes'] = intval($row['dislikes']);
                                $row_array['unit_of_quantity'] = $row['unit_of_quantity'];
				$row_array['number_of_unit'] = intval($row['number_of_unit']);
				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;
	}
?>