README.md

Kode fra undervisning d. 2.10. 2017 CNT1

loop-hold-ud.php

<?php
/*
file: actors.php
purpose: a list of actors from the sakila database
*/

//require_once 'header.php'; // html header
require 'db.php'; // the mysqli object

$sql = "SELECT * FROM `holdliste`";

$result =  $mysqli->query($sql); // query
?>

<h2>Actors</h2>

<?php
// looping out the result
while($row = $result->fetch_assoc()){
		echo $row['hold_navn'] . " " . $row['navn'] . "<br>";
   }

mysqli_close($mysqli); 

//require_once 'footer.php'; // html footer
?>

muskel.php

<?php
/*
file: actors.php
purpose: a list of actors from the sakila database
*/

require_once 'header.php'; // html header

require 'db.php'; // the mysqli object

$sql = "SELECT * FROM `holdliste`";

$result =  $mysqli->query($sql); // query
?>

<h2>Holdliste</h2>

<?php
// looping out the result
echo "<table>\n";

while($row = $result->fetch_assoc()){
		echo "<tr><td class='roed'>" . $row['hold_navn'] . "</td><td>" . $row['navn'] . "</td></tr>\n";
   }

echo "</table>\n";

mysqli_close($mysqli); 

require_once 'footer.php'; // html footer
?>