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	torben	2125	<?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			?>