Расписание пассажирских поездов по станции Тернополь на 2022 г."; $altSort = "Порядок сортировки"; } if($lan == "ua") { echo "

Розклад пасажирських поїздів по станції Тернопіль на 2022

"; $altSort = "Сортування"; } require ("accessr.php3"); $conn = new mysqli($db_server, $user, $pwd, $db); // //mysqli_connect($db_server,$user,$pwd) or die("No connect"); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; // ====== sorting block ====== if($sortorder == "desc") { $SetOrderWay = "desc"; $NextOrder = "asc";} if($sortorder == "asc") { $SetOrderWay = "asc"; $NextOrder = "desc";} if($sortorder == "") { $SetOrderWay = "asc"; $NextOrder = "desc";} // ----- set field of order ---- $SetIMGnum = "";$SetIMGroute = "";$SetIMGtime_dep = ""; $SetIMGtime_arr = ""; $SetIMGfinish = ""; $SetIMGdays = ""; $SetIMGnumer = ""; if($setorder == "") { $setorder = "prib";} if($setorder == "num") { $SetMyOrder = "nn"; $SetIMGnum = "$altSort";} if($setorder == "prib") { $SetMyOrder = "time_arr";$SetIMGprib = "$altSort";} if($setorder == "vidpr") { $SetMyOrder = "time_dep";$SetIMGvidpr = "$altSort";} if($setorder == "kolia") { $SetMyOrder = "koliya";$SetIMGkolia = "$altSort";} if($setorder == "spol") { $SetMyOrder = "spoluchenia";$SetIMGspol = "$altSort";} if($setorder == "route") { $SetMyOrder = "marshrut";$SetIMGroute = "$altSort";} if($setorder == "finish") { $SetMyOrder = "pributya";$SetIMfinish = "$altSort";} if($setorder == "kurs") { $SetMyOrder = "period";$SetIMGkurs = "$altSort";} if($setorder == "prim") { $SetMyOrder = "vagon";$SetIMGprim = "$altSort";} if($setorder == "traintype") { $SetMyOrder = "train_type";$SetTrainType = "$altSort";} // ====== end of sort order ====== $query="select * from timetable order by $SetMyOrder $SetOrderWay"; echo "==".$query; $res= mysqli_query($conn, $query); //$numr=mysqli_num_rows($res); $rows = mysqli_fetch_all($res, MYSQLI_ASSOC); //echo "=======".$rows; echo "
"; if($lan == "ru" or $lan == "") { echo ""; } if($lan == "ua") { echo ""; } $rowCount = 0; foreach ($rows as $row) { //print("train_type: " . $row['train_type'] . "; time_arr: . " . $row['time_arr'] . "
"); // For InterCity color row selection ============= if($row['train_type']== "Інтерсіті") { $SetRowColor ="style='background-color:#c9d6f7'"; } else { $SetRowColor =""; }; // Table Generation ========== if($rowCount == 0) { echo ""; $rowCount = 1;} else { echo "\n"; $rowCount = 0;} // ================================================ echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; // Table Generation stop ===== } // foreach stop echo "
Номер$SetIMGnum Приб.$SetIMGprib Отпр.$SetIMGvidpr Стоянка$SetIMGkolia Сообщение$SetIMGspol Периодичность$SetIMGkurs Нумерация$SetIMGprim Тип поезда$SetIMGprim
Номер$SetIMGnum Приб.$SetIMGprib Відпр.$SetIMGvidpr Зупинка$SetIMGperon Сполучення$SetIMGspol Курсування$SetIMGkurs Нумерація$SetIMGprim Тип поїзду$SetIMGprim
".$row['nn'].""; if( $row['time_arr'] == "00:00:00") { echo "--";} else { echo substr(row['time_arr'],0,5);} echo "".substr(row['time_dep'],0,5)."".substr(row['koliya'],0,5)."".row['spoluchenia']."".row['period']."".row['comments']."".row['train_type']."
"; echo "
"; ?>