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="#page1" data-transition="fade" data-theme="" data-icon="home"
                    class="ui-btn-active ui-state-persist">
                        Inbox
                    </a>
                </li>
                <li>
                    <a href="personer.php" data-transition="fade" data-theme="" data-icon="bars">
                        Kontakter
                    </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="#page1" data-transition="fade" data-theme="" data-icon="home"
32	class="ui-btn-active ui-state-persist">
33	Inbox
34	</a>
35	</li>
36	<li>
37	<a href="personer.php" data-transition="fade" data-theme="" data-icon="bars">
38	Kontakter
39	</a>
40	</li>
41	</ul>
42	</div>
43
44	<div data-role="content">
45	<ul data-role="listview" data-divider-theme="b" data-inset="true">
46	<li data-role="list-divider" role="heading">
47	SMS Inbox
48	</li>
49
50	<?php
51	$rows = query("
52	select i.id,sender,receivetime,body,fornavn,efternavn from
53	inbox i
54	left join stamdata d on ( right(i.sender, 8) = right(d.mobil, 8) )
55	group by i.id
56	order by receivetime desc
57	limit 20
58	");
59
60	foreach($rows as $row) {
61	echo "<li data-theme='c'>\n";
62	echo $row->sender . ": " . $row->fornavn . " " . $row->efternavn . "<br>";
63	echo $row->receivetime . "<br>";
64	echo $row->body;
65	echo "</li>\n";
66	}
67
68	?>
69
70	<!--
71	<li data-theme="c">
72	<a href="#" data-transition="slide">
73	Button
74	</a>
75	</li>
76	<li data-theme="c">
77	Noget alm text indhold
78	</li>-->
79	</ul>
80	</div>
81	</div>
82
83
84	</body>
85	</html>