".$q."
";
echo "| sename | name | form | no |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['sename']." | ".$row['name']." | ".$row['form']." | ".$row['no']." |
";
echo "
";
$q="SELECT * FROM classroom WHERE (16 < capacity) and (capacity < 24);";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| building | room_number | capacity |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['building']." | ".$row['room_number']." | ".$row['capacity']." |
";
echo "
";
$q="SELECT * FROM classroom WHERE capacity BETWEEN 17 AND 23;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| building | room_number | capacity |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['building']." | ".$row['room_number']." | ".$row['capacity']." |
";
echo "
";
$q="SELECT sename, name FROM pupils WHERE sename LIKE '%УК';";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| sename | name |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['sename']." | ".$row['name']." |
";
echo "
";
$q="SELECT sename, name FROM pupils WHERE name IN ( 'АНДРІЙ', 'ГРИГОРІЙ');";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| sename | name |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['sename']." | ".$row['name']." |
";
echo "
";
$q="SELECT COUNT(*) FROM pupils;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| COUNT(*) |
|---|
";
while ($row = mysqli_fetch_array($result))
echo "| ".$row[0]." |
";
echo "
";
$q="SELECT quality, COUNT(no) FROM teachers GROUP BY quality;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| quality | COUNT(no) |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['quality']." | ".$row['COUNT(no)']." |
";
echo "
";
$q="SELECT quality, COUNT(no) FROM teachers GROUP BY quality HAVING COUNT(no) > 1;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| quality | COUNT(no) |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['quality']." | ".$row['COUNT(no)']." |
";
echo "
";
$q="SELECT sename,mark FROM marks WHERE (day='2020-09-24') ORDER BY mark;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| sename | mark |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['sename']." | ".$row['mark']." |
";
echo "
";
$q="SELECT sename,mark FROM marks WHERE (day='2020-09-24') ORDER BY mark DESC;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| sename | mark |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['sename']." | ".$row['mark']." |
";
echo "
";
$q="SELECT sename AS 'Прізвище',mark AS 'Оцінка' FROM marks WHERE (day='2020-09-24') ORDER BY mark DESC LIMIT 3,3;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| Прізвище | Оцінка |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['Прізвище']." | ".$row['Оцінка']." |
";
echo "
";
$q="SELECT * FROM courses JOIN department ON courses.dept_name = department.dept_name;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| title | form | no | hours | dept_name | persons |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['title']." | ".$row['form']." | ".$row['no']." | ".$row['hours']." | ".$row['dept_name']." | ".$row['persons']." |
";
echo "
";
$q="SELECT * FROM courses LEFT OUTER JOIN department ON courses.dept_name = department.dept_name;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| title | form | no | hours | dept_name | persons |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['title']." | ".$row['form']." | ".$row['no']." | ".$row['hours']." | ".$row['dept_name']." | ".$row['persons']." |
";
echo "
";
$q="SELECT * FROM courses RIGHT OUTER JOIN department ON courses.dept_name = department.dept_name;";
$result = mysqli_query($link, $q);
echo "".$q."
";
echo "| title | form | no | hours | dept_name | persons |
|---|
";
while ($row = mysqli_fetch_assoc($result))
echo "| ".$row['title']." | ".$row['form']." | ".$row['no']." | ".$row['hours']." | ".$row['dept_name']." | ".$row['persons']." |
";
echo "
";
mysqli_close($link); // закриття сполучення
?>