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	torben	2125	<?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	torben	2126	<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	torben	2125	class="ui-btn-active ui-state-persist">
39	torben	2126	Inbox<br>
40	torben	2125	</a>
41			</li>
42			<li>
43			<a href="personer.php" data-transition="fade" data-theme="" data-icon="bars">
44	torben	2126	Kontakter<br>
45	torben	2125	</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>