php_bazy

<?php
$q = intval($_GET['q']);

$servername = 'pascal.fis.agh.edu.pl';
$username = 'u5michalik';
$password = 'arek1996';
$dbname = 'u5michalik';

/*
$con = mysqli_connect($servername, $username, $password, $dbname);
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}
*/
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//mysqli_select_db($con,"ajax_demo");
$sql="SELECT * FROM hotel";
$result = $conn->query($sql);

echo "<table>
<tr>
<th>id_hotelu</th>
<th>Nazwa</th>
<th>Ulica</th>
<th>Gwiazdki</th>
<th>id_standardu</th>
<th>id_miasta</th>
</tr>";

while($row = mysqli_fetch_array($result)) {
    echo "<tr>";
    echo "<td>" . $row['id_hotelu'] . "</td>";
    echo "<td>" . $row['nazwa'] . "</td>";
    echo "<td>" . $row['ulica'] . "</td>";
    echo "<td>" . $row['ile_gwiazdek'] . "</td>";
    echo "<td>" . $row['id_standardu'] . "</td>";
    echo "<td>" . $row['id_miasta'] . "</td>";
    echo "</tr>";
}
echo "</table>";
$conn->close();
?>