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
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} </a></td> \n"; 
        }
        echo "</tr> \n";
        echo "</table> \n";
}

?>

<br>

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

<?php
require("footer.php");
?>
1	<?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	SELECT id,dato
34	FROM moedeprotokol
35	WHERE enhed = '{$enhednavn}'
36	ORDER BY dato DESC
37	";
38
39	$rows = query( $sql );
40	$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
50	$row = $rows[$i];
51
52	echo "<td><a class='datovalg' href='#' id='{$row->id}'> {$row->dato} </a></td> \n";
53	}
54	echo "</tr> \n";
55	echo "</table> \n";
56	}
57
58	?>
59
60	<br>
61
62	<div id="detaljer">
63	</div>
64
65	<?php
66	require("footer.php");
67	?>