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