Tad 教材網 - 線上書籍

:::

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

<?php  
 $link=mysql\_connect("localhost","root","12345");  
 mysql\_query("SET NAMES 'utf8'");  
 if(empty($link)){  
 echo mysql\_error();  
 }  
   
   
 $op=(empty($\_REQUEST\['op'\]))?"":$\_REQUEST\['op'\];  
 $sn=(empty($\_REQUEST\['sn'\]))?"0":intval($\_REQUEST\['sn'\]);  
   
   
 switch($op){  
   
 case "show":  
 $main= show\_data($sn);   
 break;  
   
 case "save":  
 $sn= save\_data();   
 header("location:index.php?op=show&sn=$sn");  
 break;   
   
 case "add":  
 $main= input\_form(0,"#6699ff");   
 break;   
   
   
 case "del":  
 del\_contact($sn);   
 header("location:index.php");  
 break;   
   
 case "modify":  
 $main= input\_form(0,"#6699ff",$sn);   
 break;   
   
 default:  
 $main= list\_all();   
 break;  
 }  
   
 $web\_title="Tad的通訊錄";  
   
 include\_once('tbs\_class.php');  
 $TBS =& new clsTinyButStrong ;  
 $TBS->LoadTemplate('theme.html',False) ;  
 $TBS->Show() ;  
   
   
 //刪除  
 function del\_contact($sn){  
 $sql="delete from contact where sn='{$sn}' ";  
 mysql\_db\_query("tad",$sql) or die(mysql\_error());  
 }  
   
   
   
   
 //顯示所有結果  
 function list\_all(){  
 global $link;  
 $sql="select \* from `contact`";  
 $result=mysql\_db\_query("tad",$sql) or die(mysql\_error());  
   
 $main="<table border=1 align='center'>  
 <tr><th>姓名</th><th>性別</th><th>Email</th><th>功能</th></tr>";   
   
 while($data=mysql\_fetch\_array($result)){   
   
 $sex=($data\['sex'\]=="m")?"先生":"女士";  
 $color=($i % 2)?"white":"#f0f0f0";  
 $i++;  
   
 $main.= "  
 <tr bgcolor='$color'>  
 <td><a href='index.php?op=show&sn={$data\['sn'\]}'>{$data\['name'\]}</a></td>  
 <td>{$sex}</td>  
 <td>{$data\['email'\]}</td>  
 <td>  
 <a href='index.php?op=modify&sn={$data\['sn'\]}'>編輯</a> |   
 <a href='index.php?op=del&sn={$data\['sn'\]}'>刪除</a> </td>  
 </tr>";  
 }  
   
 $main.="</table>";  
   
 return $main;  
 }  
   
 //單選判斷  
 function chk($val,$dbv){  
 if($val==$dbv){  
 return "checked";  
 }  
 }  
   
 //多選判斷  
 function chk2($val,$dbv\_arr){  
 if(in\_array($val,$dbv\_arr)){  
 return "checked";  
 }  
 }  
   
   
 //輸入表單  
 function input\_form($border=5,$bgcolor="#cccc66",$sn=""){  
   
 if(!empty($sn)){  
 $sql="select \* from `contact` where sn='$sn'";  
 $result=mysql\_db\_query("tad",$sql) or die(mysql\_error());  
 $data=mysql\_fetch\_array($result);  
   
 $show\_data=explode(";",$data\['show\_data'\]);  
 }  
   
 $data="   
 <script src='city\_menu/jquery-1.2.6.min.js'></script>  
 <script>  
 $(document).ready(function(){  
 initCS();  
 var disable\_empty\_list = true;  
 });  
 </script>  
 <script language='javascript' src='city\_menu/chainedselects.js'></script>  
 <script language='javascript' src='city\_menu/city\_link.php'></script>  
   
 <script language='javascript'>  
 function initCS() {  
 var form = document.forms\[0\];  
 //初始化縣市鄉鎮選單  
 initListGroup('county', form.city, form.town);  
 setTimeout('initLists()',0);  
 }  
   
 function initLists() {  
 var form = document.forms\[0\];  
   
 form.city.selectedIndex = 0;  
 form.city.onchange();  
   
 setTimeout('initLists2()',0);  
 }  
   
 function initLists2() {  
 var form = document.forms\[0\];  
 form.town.selectedIndex = 0;  
 }  
 </script>  
   
   
 <form action='index.php' method='post'>   
 <table border={$border} align='center' bgcolor='{$bgcolor}'>  
 <tr><th>姓名</th><td><input type='text' name='name' value='{$data\['name'\]}'></td></tr>  
 <tr><th>性別</th><td>  
 <input type='radio' name='sex' value='m' ".chk("m",$data\['sex'\]).">先生  
 <input type='radio' name='sex' value='f' ".chk("f",$data\['sex'\]).">女士  
 </td></tr>  
 <tr><th>Email</th><td><input type='text' name='email' size=30 value='{$data\['email'\]}'></td></tr>  
 <tr><th>電話</th><td><input type='text' name='tel' size=10 value='{$data\['tel'\]}'></td></tr>  
 <tr><th>手機</th><td><input type='text' name='mtel' size=10 value='{$data\['mtel'\]}'></td></tr>  
 <tr><th>地址</th><td>  
 <input type='text' name='zip' size=5 value='郵遞區號' onClick=\\"  
 if(this.value=='郵遞區號'){  
 this.value='';  
 }  
 \\">  
 <select name='city' style='width:80px;'></select>  
 <select name='town' style='width:80px;'></select>  
   
 <input type='text' name='address' size=30 value='{$data\['address'\]}'>  
 </td></tr>  
 <tr><th>服務單位</th><td><input type='text' name='company' size=30 value='{$data\['company'\]}'></td></tr>  
 <tr><th>職稱</th><td><input type='text' name='job' size=10 value='{$data\['job'\]}'></td></tr>  
 <tr><th>大頭照</th><td><input type='file' name='pic' size=20></td></tr>  
 <tr><th>可秀出資料</th><td>  
 <input type='checkbox' name='show\_data\[\]' value='性別' ".chk2("性別",$show\_data).">性別  
 <input type='checkbox' name='show\_data\[\]' value='Email' ".chk2("Email",$show\_data).">Email  
 <input type='checkbox' name='show\_data\[\]' value='電話' ".chk2("電話",$show\_data).">電話  
 <input type='checkbox' name='show\_data\[\]' value='手機' ".chk2("手機",$show\_data).">手機  
 <input type='checkbox' name='show\_data\[\]' value='地址' ".chk2("地址",$show\_data).">地址  
 <input type='checkbox' name='show\_data\[\]' value='服務單位' ".chk2("服務單位",$show\_data).">服務單位  
 <input type='checkbox' name='show\_data\[\]' value='職稱' ".chk2("職稱",$show\_data).">職稱  
 </td></tr>  
 <tr><th>其他說明</th><td>  
 <textarea name='note' cols=50 rows=5>{$data\['note'\]}</textarea></td></tr>  
 </table>  
 <input type='hidden' name='op' value='save'>  
 <p align='center'><input type='submit' value='儲存資料'></p>  
   
 </form>";  
   
 return $data;  
 }  
   
   
   
 //顯示結果  
 function show\_data($sn=""){  
   
 $sql="select \* from `contact` where `sn`='$sn'";  
 $result=mysql\_db\_query("tad",$sql) or die(mysql\_error());  
 $data=mysql\_fetch\_array($result);   
   
 //$\_POST\['note'\]=stripslashes($\_POST\['note'\]);  
 $data= "<table border=5 align='center'>  
 <tr><th>姓名</th><td>{$data\['name'\]}</td></tr>  
 <tr><th>性別</th><td>{$data\['sex'\]}</td></tr>  
 <tr><th>Email</th><td>{$data\['email'\]}</td></tr>  
 <tr><th>電話</th><td>{$data\['tel'\]}</td></tr>  
 <tr><th>手機</th><td>{$data\['mtel'\]}</td></tr>  
 <tr><th>地址</th><td>  
 {$data\['zip'\]}{$data\['city'\]}{$data\['town'\]}{$data\['address'\]}  
 </td></tr>  
 <tr><th>服務單位</th><td>{$data\['company'\]}</td></tr>  
 <tr><th>職稱</th><td>{$data\['job'\]}</td></tr>  
 <tr><th>大頭照</th><td></td></tr>  
 <tr><th>可秀出資料</th><td>{$data\['show\_data'\]}</td></tr>  
 <tr><th>其他說明</th><td>{$data\['note'\]}</td></tr>  
 </table>";  
   
 return $data;  
 }  
   
 //儲存資料  
 function save\_data(){  
 if(!empty($\_POST\['show\_data'\])){  
 $show\_data=implode(";",$\_POST\['show\_data'\]);  
 }  
   
 $sql="insert into contact (`name`, `sex`, `email`, `tel`, `mtel`, `zip`, `city`, `town`, `addr`, `company`, `jobname`, `pic\_type`, `show\_data`, `note`, `post\_date`) values('{$\_POST\['name'\]}' , '{$\_POST\['sex'\]}' , '{$\_POST\['email'\]}' , '{$\_POST\['tel'\]}' , '{$\_POST\['mtel'\]}' , '{$\_POST\['zip'\]}' , '{$\_POST\['city'\]}' , '{$\_POST\['town'\]}' , '{$\_POST\['addr'\]}' , '{$\_POST\['company'\]}' , '{$\_POST\['jobname'\]}' , '{$\_POST\['pic\_type'\]}' , '{$show\_data}' , '{$\_POST\['note'\]}',now())";  
   
 mysql\_db\_query("tad",$sql) or die(mysql\_error());  
   
 $sn=mysql\_insert\_id();  
   
 return $sn;  
 }  
 ?>

:::