Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include 'config.php';
- $query = "UPDATE Chitateli SET address = 'Варна' WHERE id = 1";
- $result = mysqli_query($dbConn, $query);
- $query = "DELETE FROM Chitateli WHERE id = 2";
- $result = mysqli_query($dbConn, $query);
- $query = "SELECT * FROM Chitateli";
- $result = mysqli_query($dbConn, $query);
- $count = mysqli_num_rows($result);
- if ($count > 0)
- {
- echo "<table border='2'><tr><th>Номер на читателска карта</th><th>Име</th><th>Фамилия</th><th>Адрес</th><th>Телефон</th><th>Година на издаване</th>";
- while ($row = mysqli_fetch_array($result))
- {
- echo "<tr><td>" . $row["id"] . "</td><td>" . $row['firstname'] . "</td><td>" . $row['lastname'] . "</td><td>" . $row['address'] . "</td><td>" . $row['phonenumber'] . "</td><td>" . $row['year'] . "</td></tr>";
- }
- echo "</table>";
- }
Add Comment
Please, Sign In to add comment