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