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> |