1.Php(список студентов группы кзи-212)
«<?php
require_once '../config/connect.php';
$students = mysqli_query($connect, "SELECT `id`, `name`, `surname`, `middlename`, `group` FROM `students` WHERE `group`= (SELECT `id` FROM `groupskzi` WHERE `name` = 'КЗИ-212')");
$students = mysqli_fetch_all($students);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/style.css">
<title>Студенты группы КЗИ-212 </title>
</head>
<body>
<table>
<tr>
<th>id</th>
<th>Имя</th>
<th>Фамилия</th>
<th>Отчество</th>
<th>Группа</th>
</tr>
<?php
foreach ($students as $item) {
?>
<tr>
<td><?= $item[0] ?></td>
<td><?= $item[1] ?></td>
<td><?= $item[2] ?></td>
<td><?= $item[3] ?></td>
<td><?= $item[4] ?></td>
</tr>
<?php
}
?>
</table>
<form action="../request.php " method="post">
<button type="submit">Назад</button>
</form>
<form action=" / " method="post">
<button type="submit"> Ha главную страницу</button>
</form>
</body>
</html>»
2.Php(список студентов группы кзи-211)
«<?php
require_once '../config/connect.php';
$students = mysqli_query($connect, "SELECT `id`, `name`, `surname`, `middlename`, `group` FROM `students` WHERE `group`= (SELECT `id` FROM `groupskzi` WHERE `name` = 'КЗИ-211')");
$students = mysqli_fetch_all($students);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/style.css">
<title>Студенты группы КЗИ-211 </title>
</head>
<body>
<table>
<tr>
<th>id</th>
<th>Имя</th>
<th>Фамилия</th>
<th>Отчество</th>
<th>Группа</th>
</tr>
<?php
foreach ($students as $item) {
?>
<tr>
<td><?= $item[0] ?></td>
<td><?= $item[1] ?></td>
<td><?= $item[2] ?></td>
<td><?= $item[3] ?></td>
<td><?= $item[4] ?></td>
</tr>
<?php
}
?>
</table>
<form action="../request.php " method="post">
<button type="submit">Назад</button>
</form>
<form action=" / " method="post">
<button type="submit"> Ha главную страницу</button>
</form>
</body>
</html>»
3.Php(список студентов группы бит-211)
«<?php
require_once '../config/connect.php';
$students = mysqli_query($connect, "SELECT `id`, `name`, `surname`, `middlename`, `group` FROM `students` WHERE `group`= (SELECT `id` FROM `groupskzi` WHERE `name` = 'БИТ-211')");
$students = mysqli_fetch_all($students);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/style.css">
<title>Студенты группы БИТ-211 </title>
</head>
<body>
<table>
<tr>
<th>id</th>
<th>Имя</th>
<th>Фамилия</th>
<th>Отчество</th>
<th>Группа</th>
</tr>
<?php
foreach ($students as $item) {
?>
<tr>
<td><?= $item[0] ?></td>
<td><?= $item[1] ?></td>
<td><?= $item[2] ?></td>
<td><?= $item[3] ?></td>
<td><?= $item[4] ?></td>
</tr>
<?php
}
?>
</table>
<form action="../request.php " method="post">
<button type="submit">Назад</button>
</form>
<form action=" / " method="post">
<button type="submit"> Ha главную страницу</button>
</form>
</body>
</html>»