<?php
define('ACTION', true);

include('common.php');
$page_title = 'Export';


$mysql_tb = $userdata['user_name'];
?>
</div>
    </div>



<br>

<?php
include 'config1.php';

$hostname=$config1['DB_HOST'];
$username=$config1['DB_USERNAME'];
$password=$config1['DB_PASSWORD'];
$db = $config1['DB_DATABASE'];

// Create connection
$conn = new mysqli($hostname, $username, $password, $db);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


$dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
foreach($dbh->query("SELECT NazwaStazu, Stanowisko, Data, Miejsce, Inicjaly, Plec, NazwiskoOperatora, NazwiskaAsyst, NazwaZabiegu
FROM " . $mysql_tb . "
") as $row) {
echo "<table width='850' height='500' border='1' cellpadding='4' cellspacing='0' style='border-collapse: collapse;'>";
echo "<tr>";
echo "<td width='50%'>1. /nrwpisu/ </td>";
echo "<td align='center'> " . $row['NazwaStazu'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center'> " . $row['Stanowisko'] . "</td>";
echo "<td align='center'> " . $row['Data'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan = '2'> " . $row['Miejsce'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center'> " . $row['Inicjaly'] . "</td>";
echo "<td align='center'> " . $row['Plec'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan = '2'> " . $row['NazwiskoOperatora'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan = '2'> " . $row['NazwiskaAsyst'] . "</td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan = '2'> " . $row['NazwaZabiegu'] . "</td>";
echo "</tr>";
echo "<tr style='height:150px'>";
echo "<td>11.</td>";
echo "<td>12.</td>";
echo "</tr>";
echo "</table>";
echo "<br><br><br><br><br><br><br><br>";

}


?>
</tbody></table>

</tr>
</div>
</div>
</div>
</body>

</div>
    </div>
</html>