misc/horsensspejder-web/moedeprotokol.php

<?php
require("header.php");
require("inc/mysql.php");

$enhed = $_GET["enhed"];

$sql = "
SELECT DISTINCT enhed 
FROM roller
WHERE enhed LIKE '%{$enhed}%'";
$rows = query($sql);

$enhednavn = $rows[0]->enhed;

?>
<script type='text/javascript'>
$( function() {
    $(".datovalg").click( function() {
        var id = $(this).attr("id");
        var url = "ajax/moedeprotokol_detaljer.php?id=" + id;
        
        $("#detaljer").load( url );
        
    });
});
</script>

<h3>M&oslash;deprotokol for <?php echo $enhednavn;?></h3>

<?php

$sql = "
SELECT id,dato,emne
FROM moedeprotokol
WHERE enhed = '{$enhednavn}'
ORDER BY dato DESC
";

$rows = query( $sql );
$count = sizeof($rows);
if ($count > 0) {
        echo "<table border='1' cellpadding='3'>";
        for ($i=0; $i<$count; $i++) {
        if ( ($i%6) == 0) {
                if ($i>0)
                echo "</tr>\n";
                echo "<tr>";
        }
        
            $row = $rows[$i];
    
        echo "<td><a class='datovalg' href='#' id='{$row->id}'> {$row->dato}: {$row->emne} </a></td> \n"; 
        }
        echo "</tr> \n";
        echo "</table> \n";
}

?>

<br>

<div id="detaljer">
</div>

<?php
require("footer.php");
?>
1	torben	2128	<?php
2			require("header.php");
3			require("inc/mysql.php");
4
5			$enhed = $_GET["enhed"];
6
7			$sql = "
8			SELECT DISTINCT enhed
9			FROM roller
10			WHERE enhed LIKE '%{$enhed}%'";
11			$rows = query($sql);
12
13			$enhednavn = $rows[0]->enhed;
14
15			?>
16			<script type='text/javascript'>
17			$( function() {
18			$(".datovalg").click( function() {
19			var id = $(this).attr("id");
20			var url = "ajax/moedeprotokol_detaljer.php?id=" + id;
21
22			$("#detaljer").load( url );
23
24			});
25			});
26			</script>
27
28			<h3>Mødeprotokol for <?php echo $enhednavn;?></h3>
29
30			<?php
31
32			$sql = "
33	torben	2141	SELECT id,dato,emne
34	torben	2128	FROM moedeprotokol
35			WHERE enhed = '{$enhednavn}'
36			ORDER BY dato DESC
37			";
38
39			$rows = query( $sql );
40	torben	2135	$count = sizeof($rows);
41			if ($count > 0) {
42			echo "<table border='1' cellpadding='3'>";
43			for ($i=0; $i<$count; $i++) {
44			if ( ($i%6) == 0) {
45			if ($i>0)
46			echo "</tr>\n";
47			echo "<tr>";
48			}
49	torben	2128
50	torben	2135	$row = $rows[$i];
51	torben	2128
52	torben	2141	echo "<td><a class='datovalg' href='#' id='{$row->id}'> {$row->dato}: {$row->emne} </a></td> \n";
53	torben	2135	}
54			echo "</tr> \n";
55			echo "</table> \n";
56	torben	2128	}
57
58			?>
59
60			<br>
61
62			<div id="detaljer">
63			</div>
64
65			<?php
66			require("footer.php");
67			?>