misc/horsensspejder-web/smsjobs.php

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


<h3>SMS Jobs</h3>

<?php

$rows = query("
SELECT enheder,individer,besked,antalmodtagere, format(samletpris,2) as samletpris,tidspunkt
FROM smsjob
ORDER BY tidspunkt desc
");


echo "<table border='0'>";
echo "<tr><th width='150'>Enheder</th><th width='250'>Individer</th><th width='400'>Tekst</th><th>Antal Modtagere</th><th>Samlet pris</th><th>Tidspunkt</th></tr>\n";


$i = 0;

foreach($rows as $row) {
        $besked = utf8_decode($row->besked);
        $style = ($i == 0) ? "even" : "odd";

        $individer = utf8_decode($row->individer);
        $individer = str_replace("|", "| ", $individer);

        $enheder = utf8_decode($row->enheder);
        $enheder = str_replace("|", "| ", $enheder);

        echo "<tr class='{$style}'>";
        echo "<td>{$enheder}</td><td>{$individer}</td><td>{$besked}</td><td>{$row->antalmodtagere}</td><td>{$row->samletpris}</td><td>{$row->tidspunkt}</td>";
        echo "</tr>\n";

        $i = ($i+1)%2;
}
echo "</table>";


require("footer.php");
?>
1	<?php
2	require("header.php");
3	include "inc/mysql.php";
4	?>
5
6
7	<h3>SMS Jobs</h3>
8
9	<?php
10
11	$rows = query("
12	SELECT enheder,individer,besked,antalmodtagere, format(samletpris,2) as samletpris,tidspunkt
13	FROM smsjob
14	ORDER BY tidspunkt desc
15	");
16
17
18	echo "<table border='0'>";
19	echo "<tr><th width='150'>Enheder</th><th width='250'>Individer</th><th width='400'>Tekst</th><th>Antal Modtagere</th><th>Samlet pris</th><th>Tidspunkt</th></tr>\n";
20
21
22	$i = 0;
23
24	foreach($rows as $row) {
25	$besked = utf8_decode($row->besked);
26	$style = ($i == 0) ? "even" : "odd";
27
28	$individer = utf8_decode($row->individer);
29	$individer = str_replace("\|", "\| ", $individer);
30
31	$enheder = utf8_decode($row->enheder);
32	$enheder = str_replace("\|", "\| ", $enheder);
33
34	echo "<tr class='{$style}'>";
35	echo "<td>{$enheder}</td><td>{$individer}</td><td>{$besked}</td><td>{$row->antalmodtagere}</td><td>{$row->samletpris}</td><td>{$row->tidspunkt}</td>";
36	echo "</tr>\n";
37
38	$i = ($i+1)%2;
39	}
40	echo "</table>";
41
42
43	require("footer.php");
44	?>