|
Расписание пассажирских поездов по станции Тернополь на 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 = "";}
if($setorder == "prib") { $SetMyOrder = "time_arr";$SetIMGprib = "";}
if($setorder == "vidpr") { $SetMyOrder = "time_dep";$SetIMGvidpr = "";}
if($setorder == "kolia") { $SetMyOrder = "koliya";$SetIMGkolia = "";}
if($setorder == "spol") { $SetMyOrder = "spoluchenia";$SetIMGspol = "";}
if($setorder == "route") { $SetMyOrder = "marshrut";$SetIMGroute = "";}
if($setorder == "finish") { $SetMyOrder = "pributya";$SetIMfinish = "";}
if($setorder == "kurs") { $SetMyOrder = "period";$SetIMGkurs = "";}
if($setorder == "prim") { $SetMyOrder = "vagon";$SetIMGprim = "";}
if($setorder == "traintype") { $SetMyOrder = "train_type";$SetTrainType = "";}
// ====== 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 "
Номер$SetIMGnum |
Приб.$SetIMGprib |
Отпр.$SetIMGvidpr |
Стоянка$SetIMGkolia |
Сообщение$SetIMGspol |
Периодичность$SetIMGkurs |
Нумерация$SetIMGprim |
Тип поезда$SetIMGprim |
";
}
if($lan == "ua") {
echo "
Номер$SetIMGnum |
Приб.$SetIMGprib |
Відпр.$SetIMGvidpr |
Зупинка$SetIMGperon |
Сполучення$SetIMGspol |
Курсування$SetIMGkurs |
Нумерація$SetIMGprim |
Тип поїзду$SetIMGprim |
";
}
$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 "".$row['nn']." | \n";
echo "";
if( $row['time_arr'] == "00:00:00")
{ echo "--";}
else
{ echo substr(row['time_arr'],0,5);}
echo " | \n";
echo "".substr(row['time_dep'],0,5)." | \n";
echo "".substr(row['koliya'],0,5)." | \n";
echo "".row['spoluchenia']." | \n";
echo "".row['period']." | \n";
echo "".row['comments']." | \n";
echo "".row['train_type']." | \n";
echo " ";
// Table Generation stop =====
} // foreach stop
echo " ";
echo " | ";
?>
|
|