<?php
error_reporting(E_ALL);
$servername = "localhost";
$username = "root";
$password = "password";
$dbname = "Intel";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if (!$conn) {
    echo "Error: Unable to connect to MySQL." . PHP_EOL;
    echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;
    echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;
    exit;
}

$pos_query = "SELECT * FROM posData ";
$pos_result = mysqli_query($conn, $pos_query);

$pos_data = array();
while($row = mysqli_fetch_array($pos_result)) {
	$pos_data[] = $row;
}


echo "<pre>";
print_r($pos_data);
echo "</pre>";
?>

<?php

function posData($pos_Data){
	echo "<table = border='1'>";
	echo "<th> ID </th>";
	echo "<th> Moon </th>";
	echo "<th> Coperation </th>";
	echo "<th> Online </th>";
	echo "<th> Minerals </th>";
	foreach ($pos_Data as $row)
	{
		echo "<tr>";
		echo "<td>";
		echo $row["0"];
		echo "</td>";

		echo "<tr>";
		echo "<td>";
		echo $row["moon"];
		echo "</td>";

		echo "<td>";
		echo $row["corperation"];
		echo "</td>";


		echo "<td>";
		echo $row["online"];
		echo "</td>";
		echo "</tr>";

		echo "<td>";
		echo $row["minerals"];
		echo "</td>";
		echo "</tr>";
	}
	echo "</table>";
}
?>
<?php
		posData($pos_Data);
?>