<body style="background: darkgoldenrod;">
<form method="post" action="">
<input type="checkbox" name="box1[]" value="4"/>
<input type="checkbox" name="box1[]" value="6"/>
<button type="submit" name="commit" style="background-color: transparent; border: 0px;"><img src="https://forum.pasja-informatyki.pl/qa-theme/SnowFlat/icons/key0.png"/></button>
</form>
<?php
$mysqli = new mysqli('localhost', 'root', 'mystrongpass', 'forumpasjainformatyki');
if(isset($_POST['commit']) && isset($_POST['box1'])) {
for($i=0;$i<count($_POST['box1']);$i++) {
$query0 = "SELECT `c` FROM `kl` WHERE `c` = {$_POST['box1'][$i]};";
$query2 = $mysqli->query($query0);
while($result = $query2->fetch_assoc()) {
if($result != null) {
break;
}
}
if($result == null) {
$query1 = "INSERT INTO `kl` values(null, 1, 2, {$_POST['box1'][$i]});";
if($mysqli->query($query1)) {
echo 'Add to favourite.';
} else {
echo 'Not add to favourite.';
}
} else {
echo 'This identifier is already in database.';
}
}
}
$query3 = 'SELECT `c` FROM `kl`';
$query5 = $mysqli->query($query3);
while($result = $query5->fetch_assoc()) {
echo "<br />" . "My favourite something (ID) = " . $result['c'];
}
?>
</body>