horsensspejder-web/mobile/inbox.php

<?php
require "../inc/mysql.php";
header("Content-Type: text/html; charset=iso-8859-1");
session_start();
?>

<html>
<head>

<meta name="viewport" content="width=device-width, initial-scale=1" />

<link rel="stylesheet" href="http://code.jquery.com/mobile/1.3.2/jquery.mobile-1.3.2.min.css" />
<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script src="http://code.jquery.com/mobile/1.3.2/jquery.mobile-1.3.2.min.js"></script>
</head>


<body>


<!-- Home -->
<div data-role="page" id="page1">
    <div data-theme="a" data-role="header">
        <h3>
            Horsens Spejder
        </h3>
    </div>
        <div data-role="navbar" data-iconpos="top">
            <ul>
                <li>
                    <a href="moedeprotokol.php" data-transition="fade" data-theme="" data-icon="check">
                        M&oslash;de<br>Protokol
                    </a>
                </li>

                <li>
                    <a href="#page1" data-transition="fade" data-theme="" data-icon="grid"
                    class="ui-btn-active ui-state-persist">
                        Inbox<br>&nbsp;
                    </a>
                </li>
                <li>
                    <a href="personer.php" data-transition="fade" data-theme="" data-icon="bars">
                        Kontakter<br>&nbsp;
                    </a>
                </li>
            </ul>
        </div>

   <div data-role="content">
        <ul data-role="listview" data-divider-theme="b" data-inset="true">
            <li data-role="list-divider" role="heading">
                SMS Inbox
            </li>

<?php
$rows = query("
select i.id,sender,receivetime,body,fornavn,efternavn from
inbox i
left join stamdata d on ( right(i.sender, 8) = right(d.mobil, 8) )
group by i.id
order by receivetime desc
limit 20
");

foreach($rows as $row) {
        echo "<li data-theme='c'>\n";
        echo $row->sender . ": " . $row->fornavn . " " . $row->efternavn . "<br>";
        echo $row->receivetime . "<br>";
        echo $row->body;        
        echo "</li>\n";
}

?>

<!--
            <li data-theme="c">
                <a href="#" data-transition="slide">
                    Button
                </a>
            </li>
                        <li data-theme="c">
                                Noget alm text indhold
                        </li>-->
        </ul>
    </div>
</div>


</body>
</html>
1	<?php
2	require "../inc/mysql.php";
3	header("Content-Type: text/html; charset=iso-8859-1");
4	session_start();
5	?>
6
7	<html>
8	<head>
9
10	<meta name="viewport" content="width=device-width, initial-scale=1" />
11
12	<link rel="stylesheet" href="http://code.jquery.com/mobile/1.3.2/jquery.mobile-1.3.2.min.css" />
13	<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
14	<script src="http://code.jquery.com/mobile/1.3.2/jquery.mobile-1.3.2.min.js"></script>
15	</head>
16
17
18	<body>
19
20
21	<!-- Home -->
22	<div data-role="page" id="page1">
23	<div data-theme="a" data-role="header">
24	<h3>
25	Horsens Spejder
26	</h3>
27	</div>
28	<div data-role="navbar" data-iconpos="top">
29	<ul>
30	<li>
31	<a href="moedeprotokol.php" data-transition="fade" data-theme="" data-icon="check">
32	Møde<br>Protokol
33	</a>
34	</li>
35
36	<li>
37	<a href="#page1" data-transition="fade" data-theme="" data-icon="grid"
38	class="ui-btn-active ui-state-persist">
39	Inbox<br>
40	</a>
41	</li>
42	<li>
43	<a href="personer.php" data-transition="fade" data-theme="" data-icon="bars">
44	Kontakter<br>
45	</a>
46	</li>
47	</ul>
48	</div>
49
50	<div data-role="content">
51	<ul data-role="listview" data-divider-theme="b" data-inset="true">
52	<li data-role="list-divider" role="heading">
53	SMS Inbox
54	</li>
55
56	<?php
57	$rows = query("
58	select i.id,sender,receivetime,body,fornavn,efternavn from
59	inbox i
60	left join stamdata d on ( right(i.sender, 8) = right(d.mobil, 8) )
61	group by i.id
62	order by receivetime desc
63	limit 20
64	");
65
66	foreach($rows as $row) {
67	echo "<li data-theme='c'>\n";
68	echo $row->sender . ": " . $row->fornavn . " " . $row->efternavn . "<br>";
69	echo $row->receivetime . "<br>";
70	echo $row->body;
71	echo "</li>\n";
72	}
73
74	?>
75
76	<!--
77	<li data-theme="c">
78	<a href="#" data-transition="slide">
79	Button
80	</a>
81	</li>
82	<li data-theme="c">
83	Noget alm text indhold
84	</li>-->
85	</ul>
86	</div>
87	</div>
88
89
90	</body>
91	</html>