du kan gøre det nemt for dig selv, ved at overføre row id (har du vel i db i forvejen), og kun denne.
i valgt.php emploder du disse til en komma seperaret string som du anvender i din sql til at hente alle de poster ud af db igen.
prisen er selvføgelig et ekstra sql kald
test tabel
CREATE TABLE IF NOT EXISTS `kostdata` (
`id` int(11) NOT NULL,
`Navn` varchar(25) COLLATE utf8_danish_ci NOT NULL,
`Energi` float NOT NULL,
`Protein` float NOT NULL,
`Fedt` float NOT NULL,
`Kulhydrat` float NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_danish_ci;
INSERT INTO `kostdata` (`id`, `Navn`, `Energi`, `Protein`, `Fedt`, `Kulhydrat`) VALUES
(1, 'a38', 2, 3, 1, 1),
(2, 'ymerdrys', 5, 1, 0.1, 3);
ALTER TABLE `kostdata`
ADD PRIMARY KEY (`id`);
ALTER TABLE `kostdata`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
index.php
<?php
$sql = "SELECT * FROM kostdata";
$result = mysqli_query($conn, $sql);
$bg = '#eeeeee';
echo "<br>";
echo ' <form action="valgt.php" method="post"><table>';
echo "<tr><td> Navn</td>";
echo "<td>Energi</td>";
echo "<td>Protein</td>";
echo "<td>Fedt</td>";
echo "<td>Kulhydrat</td></tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$bg = ($bg == '#eeeeee') ? '#ffffff' : '#eeeeee';
echo '
<tr bgcolor="' . $bg . '">
<td align="left">' . $row['Navn'] . '</td>
<td align="left">' . $row['Energi'] . '</td>
<td align="left">' . $row['Protein'] . '</td>
<td align="left">' . $row['Fedt'] . '</td>
<td align="left">' . $row['Kulhydrat'] . '</td>
<td align="left"><input type="checkbox" name="checked[]" value="' . $row['id'] . '"></td></tr>
';
}
?>
</table>
<input type="submit" name="submit" value="submit" />
</form>
valgt.php
<table>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
echo 'Følgende har du lagt ind i kostplanen';
echo "<br>";
echo "<tr><td> Navn</td>";
echo "<td>Energi</td>";
echo "<td>Protein</td>";
echo "<td>Fedt</td>";
echo "<td>Kulhydrat</td></tr>";
$sum_Energi = 0;
$sum_protein = 0;
$sum_fedt = 0;
$sum_kulhydrat = 0;
$id_liste = implode(",", $_POST['checked']);
$sql = "SELECT * FROM kostdata where id IN($id_liste)";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
$sum_Energi += $row['Energi'];
$sum_protein += $row['Protein'];
$sum_fedt += $row['Fedt'];
$sum_kulhydrat += $row['Kulhydrat'];
echo "<tr><td>" . $row['Navn'] . " </td>";
echo "<td>" . $row['Energi'] . " </td>";
echo "<td>" . $row['Protein'] . " </td>";
echo "<td>" . $row['Fedt'] . " </td>";
echo "<td>" . $row['Kulhydrat'] . " </td></tr>";
}
echo "<tr><td> totaler</td>";
echo "<td>" . $sum_Energi . "</td>";
echo "<td>" . $sum_protein . "</td>";
echo "<td>" . $sum_fedt . "</td>";
echo "<td>" . $sum_kulhydrat . "</td></tr>";
}
?>
</table>