Tad 教材網 - 線上書籍

:::

\[981\]PHP入門+XOOPS模組設計
======================

//顯示所有結果  
 function list\_all(){  
 global $xoopsDB,$xoopsUser,$xoopsModuleConfig;  
   
 $i=0;  
   
 $tbl=$xoopsDB->prefix('contact');  
 $sql="select \* from $tbl";  
   
 //PageBar(資料數, 每頁顯示幾筆資料, 最多顯示幾個頁數選項);  
 $result = $xoopsDB->query($sql) or redirect\_header($\_SERVER\['PHP\_SELF'\],3, mysql\_error());  
 $total=$xoopsDB->getRowsNum($result);  
   
 $navbar = new PageBar($total, $xoopsModuleConfig\['show\_num'\], 10);  
 $mybar = $navbar->makeBar();  
 $bar= sprintf(\_BP\_TOOLBAR,$mybar\['total'\],$mybar\['current'\])."{$mybar\['left'\]}{$mybar\['center'\]}{$mybar\['right'\]}";  
 $sql.=$mybar\['sql'\];  
 //分頁工具列為 $bar  
   
   
 $result=$xoopsDB->query($sql) or die(mysql\_error());  
   
 $tool\_title=($xoopsUser)?"<th>".\_MD\_CONTACT\_FUNCTION."</th>":"";  
   
   
 $main="  
 <font color="#ff0000" size="4">".sprintf(\_MD\_CONTACT\_TOTAL,$total,$mybar\['total'\])."</font>  
 <table border=1 style='width:auto;'>  
 <tr><th>".\_MD\_CONTACT\_PHOTO."</th><th>".\_MD\_CONTACT\_NAME."</th><th>".\_MD\_CONTACT\_SEX."</th><th>Email</th>$tool\_title</tr>";   
   
 while($data=$xoopsDB->fetchArray($result)){   
   
 $sex=($data\['sex'\]=="m")?\_MD\_CONTACT\_MAN:\_MD\_CONTACT\_WOMEN;  
 $color=($i % 2)?"white":"#f0f0f0";  
 $i++;  
   
 $photo=\_DIR."/{$data\['sn'\]}\_s.png";  
 $show\_photo=XOOPS\_URL."/uploads/tad\_contact/{$data\['sn'\]}\_s.png";  
 $pic=(file\_exists($photo))?"<img src='$show\_photo'>":"沒有圖";  
   
 $tool=($xoopsUser)?"<td>  
 <a href='index.php?op=modify&sn={$data\['sn'\]}'>編輯</a> |   
 <a href='index.php?op=del&sn={$data\['sn'\]}'>刪除</a>  
 </td>":"";  
   
   
 $main.= "  
 <tr bgcolor='$color'>  
 <td>$pic</td>  
 <td><a href='view.php?sn={$data\['sn'\]}'>{$data\['name'\]}</a></td>  
 <td>{$sex}</td>  
 <td>{$data\['email'\]}</td>  
 $tool  
 </tr>";  
 }  
   
 $main.="</table>  
 <p>$bar</p>";  
   
 return $main;  
 }

:::

搜尋

進階搜尋

QR Code 區塊

https%3A%2F%2Ftad0616.net%2Fmodules%2Ftad_book3%2Fmarkdown.php%3Ftbdsn%3D131

快速登入

書籍目錄

展開 | 闔起

線上使用者

52人線上 (10人在瀏覽線上書籍)

會員: 0

訪客: 52

更多…

MarkDown

搜尋

QR Code 區塊

快速登入

書籍目錄

線上使用者