上課範例：pda.php

:::

[1012]PHP進階開發及TadTools工具應用

11-2 上課範例：pda.php

01<?php
02/*-----------引入檔案區--------------*/
03include_once "header.php";
04include_once "up_file.php";
05/*-----------function區--------------*/
06 
07//抓所有分類
08$cate=get_contact_cate_all();
09 
10$sql = "select * from `".$xoopsDB->prefix("contact")."` ";
11$result = $xoopsDB->query($sql) or redirect_header($_SERVER['PHP_SELF'],3, mysql_error());
12$content="<li data-role='list-divider'>所有通訊錄列表</li>";
13while($all=$xoopsDB->fetchArray($result)){
14    //以下會產生這些變數： $tel , $email , $name , $gsn , $sn , $birthday , $zip , $county , $city , $addr
15    foreach($all as $k=>$v){
16        $$k=$v;
17    }
18     
19    $photo_file = get_pic_file('photo' , $sn , 1 , 'thumb');
20  $photo=empty($photo_file)?"" : "<img src='{$photo_file}'>";
21     
22    $content.="
23  <li>
24  <a href='data.php?sn=$sn'>{$photo}<h3>{$name}</h3><p>電話：{$tel} 信箱：{$email}</p></a>
25  <span class='ui-li-count'>{$cate[$gsn]['title']}</span>
26  </li>
27  ";
28     
29}
30 
31 
32echo "<!DOCTYPE html>
33<html>
34  <head>
35   <title></title>
36   <meta charset='utf-8'>
37   <meta name='viewport' content='width=device-width, initial-scale=1'>
38   <link rel='stylesheet' href='".XOOPS_URL."/modules/tadtools/jquery.mobile/jquery.mobile.css' />
39   <script src='".XOOPS_URL."/modules/tadtools/jquery/jquery.js'></script>
40   <script src='".XOOPS_URL."/modules/tadtools/jquery.mobile/jquery.mobile.js'></script>
41 
42  </head>
43  <body>
44   
45  <div data-role='page' id='p1'>
46    <div data-role='header'>
47      <a data-icon='arrow-l' data-rel='back'>回上頁</a>
48      <h1>所有通訊錄列表</h1>
49      <a href='pda.php' data-icon='home'>回首頁</a>
50    </div>
51    <div data-role='content'>
52 
53      <ul data-role='listview' data-inset='false'>
54        $content
55      </ul>
56 
57    </div>
58    <div data-role='footer'></div>
59  </div>
60 
61  </body>
62</html>
63";
64?>