connect_error) {
die("Savienojuma kļūda: " . $conn->connect_error);
}
?>
Kopu aprēķins
Kopu aprēķini
query($sql);
echo "Matemātika ∩ Programmēšana:
";
while($row = $result->fetch_assoc()){
echo $row['name']."
";
}
}
// Tikai Matemātika
if(isset($_POST['only_m'])){
$sql = "
SELECT s.name
FROM students s
JOIN student_club sc ON s.id = sc.student_id
WHERE sc.club_id = 1
AND s.id NOT IN (
SELECT student_id FROM student_club WHERE club_id <> 1
)
";
$result = $conn->query($sql);
echo "Tikai Matemātika:
";
while($row = $result->fetch_assoc()){
echo $row['name']."
";
}
}
// Apvienojums
if(isset($_POST['union_mp'])){
$sql = "
SELECT DISTINCT s.name
FROM students s
JOIN student_club sc ON s.id = sc.student_id
WHERE sc.club_id IN (1,2)
";
$result = $conn->query($sql);
echo "Matemātika ∪ Programmēšana:
";
while($row = $result->fetch_assoc()){
echo $row['name']."
";
}
}
$conn->close();
?>