<?php
$dbHost = 'localhost';
$dbUsername = 'root';
$dbPassword='';
$dbName = 'kontrolna';
$connection = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);

$result = $connection->query("SELECT * FROM `products` p JOIN `cathegory` c ON p.product_cathegory = c.cathegory_id"); //vikame metoda query dinamichno t.e pravim zaqvka kam bazata. Ako iskame da izvlechem neshto s uslovie dobavqme samo WHERE .....

$arrayData = array();

while($row = $result->fetch_assoc()) // chete kolkona po kolona i vkarva value-tata v promenlivata row i stava v masiv. klucha na masiva e imeto na kolonata
{
	$arrayData['product_id'][] = $row['product_id'];
	$arrayData['product_name'][] = $row['product_name'];
	$arrayData['product_price'][] = $row['product_price'];
	$arrayData['product_cathegory'][] = $row['product_cathegory'];
	$arrayData['quantity'][] = $row['quantity'];
	$arrayData['cathegory_name'][] = $row['cathegory_name']; //dobavqme q kogato napravim JOIN i otdolu na TD sashto
}
//echo var_dump($arrayData); za pregled

extract($arrayData); //da se razdeli na malki masivcheta kato rezarhivirane
//echo var_dump($product_id);
?>

<table border="1">
	<?php
	foreach($product_id as $key=>$value)
	{

	?>

	<tr>
		<td><?=$product_id[$key] ?></td>
		<td><?=$product_name[$key] ?></td>
		<td><?=$product_cathegory[$key] ?></td>
		<td><?=$product_price[$key] ?></td>
		<td><?=$quantity[$key] ?></td>
		<td><?=$cathegory_name[$key] ?></td>

	</tr>

	<?php
	}
	?>

</table>