Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table border="1">
- <tr>
- <th>Номер потяга</th>
- <th>Кількість вагонів</th>
- <th>Станція відправлення</th>
- <th>Станція прибуття</th>
- <th>Дата та час відправлення</th>
- <th>Дата та час прибуття</th>
- </tr>
- <?php
- $db = mysqli_connect("localhost:3308", "root", "19801980", "mysitedb") or die(mysqli_error());
- $rs = "SELECT train_number, carriage_count, s1.station_name AS departure, s2.station_name AS arriving,
- departure_time, time_in_journey FROM main_table
- JOIN stations_table s1 ON main_table.departure_point = s1.station_code
- JOIN stations_table s2 ON main_table.arriving_point = s2.station_code;"; //запрос на выборку данных и выбраной таблицы
- $result = $db->query($rs);
- if ($result->num_rows > 0) {
- while ($row = $result->fetch_assoc()) {
- echo "<tr><td>" . $row['train_number'] . "</td>
- <td>" . $row['carriage_count'] . "</td>
- <td>" . $row['departure'] . "</td>
- <td>" . $row['arriving'] . "</td>
- <td>" . $row['departure_time'] . "</td>
- <td>" . $row['departure_time'] + $row['time_in_journey'] . "</td></tr>";
- }
- echo "</table>";
- }
- $db ->close();
- ?>
- </table>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement