Tad 教材網 - 線上書籍

:::

\[982\]PHP網站開發 進階應用技巧
=====================

<?php  
 $root\_pass="12345"; //資料庫root密碼  
 $db\_name="test"; //資料庫名稱  
   
 /\* 連資料庫檢查 \*/  
 $link=mysql\_connect("localhost","root",$root\_pass); //資料庫連線  
 mysql\_select\_db("test");  
 mysql\_query("SET NAMES 'utf8'"); //設定語系  
 error\_reporting(0);  
   
   
 if($\_POST\['op'\]=="save"){  
 save\_event();  
 }  
   
 //儲存事件  
 function save\_event(){  
   
 $sql="insert into diary (`date`,`event`) values ('{$\_POST\['date'\]}','{$\_POST\['event'\]}')";  
 mysql\_query($sql) or die($sql);  
   
 $id=mysql\_insert\_id();  
   
 if(!empty($\_FILES\['pic'\]\['tmp\_name'\])){  
 foreach($\_FILES\['pic'\]\['tmp\_name'\] as $i=>$tmp\_name){  
 move\_uploaded\_file($tmp\_name , "myfiles/{$id}\_{$\_FILES\['pic'\]\['name'\]\[$i\]}");  
 }  
 }  
   
 header("location:index.php");  
 }  
   
 //讀取事件的下拉選單  
 function select\_event($select\_sn=""){  
 $sql="select \* from diary order by date desc , sn";  
 $result=mysql\_query($sql) or die($sql);  
 $main="<select onChange=\\"location.href='index.php?sn='+this.value\\">  
 <option value=''>撰寫日記</option>";  
 while(list($sn,$date,$event)=mysql\_fetch\_row($result)){  
 $selected=($select\_sn==$sn)?"selected":"";  
 $main.="<option value='$sn' $selected>$date</option>";  
 }  
 $main.="</select>";  
 return $main;  
 }  
   
 //讀取某個事件  
 function show\_event($sn=""){  
 if(empty($sn))return;  
 $sql="select \* from diary where sn='$sn'";  
 $result=mysql\_query($sql) or die($sql);  
 list($sn,$date,$event)=mysql\_fetch\_row($result);  
 $pic=get\_pic($sn);  
 $main="<div class='page'>  
 $event  
 $pic  
 </div>";  
 return $main;  
 }  
   
 //讀取圖檔  
 function get\_pic($sn=""){  
 $dir="myfiles";  
 include\_once('easyphpthumbnail.class.php');  
   
 $main="<script type='text/javascript' language='javascript' src='lytebox/lytebox.js'></script>  
 <link rel='stylesheet' href='lytebox/lytebox.css' type='text/css' media='screen' />";  
 if (is\_dir($dir)) {  
 if ($dh = opendir($dir)) {  
 while (($file = readdir($dh)) !== false) {  
 $ff=explode("\_",$file);  
 if($ff\[0\]==$sn){  
 if(!file\_exists("{$dir}/\_thumbs/{$file}")){  
 $thumb = new easyphpthumbnail;  
 $thumb -> Chmodlevel = '0755';  
 $thumb -> Thumblocation = "{$dir}/\_thumbs/";  
 $thumb -> Thumbprefix = '';  
 $thumb -> Thumbheight=100 ;  
 $thumb -> Backgroundcolor = '#F0F0F0';  
 $thumb -> Shadow = true;  
 $thumb -> Clipcorner = array(2,10,0,0,0,1,1);  
 $thumb -> Framewidth = 6;  
 $thumb -> Framecolor = '#F0F0F0';  
 $thumb -> Binder = true;  
 $thumb -> Binderspacing = 10;  
 $thumb -> Watermarkpng = 'watermark.png';  
 $thumb -> Watermarkposition = '20% 90%'; //位置  
 $thumb -> Watermarktransparency = 100; //透明度（數字越大，越不透明）  
   
 $thumb -> Copyrightfonttype = 'cwheib.ttf';  
 $thumb -> Copyrightfontsize = 10;  
 //$thumb -> Copyrighttextcolor = '#FFFFFF'; //不設會自動偵測  
 $thumb -> Copyrighttext = '點兩下';  
 $thumb -> Copyrightposition = '15% 15%';  
   
 $thumb -> Createthumb("{$dir}/{$file}",'file');  
 }  
 $main.="<a href='$dir/$file' rel='lyteshow\[{$ff\[0\]}\]' title='$file'><img src='{$dir}/\_thumbs/{$file}' alt='$file' style='border:0px;'></a>  
 ";  
 }  
 }  
 closedir($dh);  
 }else{  
 return "無法開啟目錄";  
 }  
 }else{  
 return "無法讀取圖檔目錄";  
 }  
 return $main;  
 }  
   
   
 ?>  
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
 <html>  
 <head>  
 <meta http-equiv="content-type" content="text/html; charset=UTF-8">  
 <link rel='stylesheet' type='text/css' media='screen' href='style.css' />  
 <title>我的記事本</title>  
 <script type="text/javascript" src="ckeditor/ckeditor.js"></script>  
 <script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>  
 <script src="js/jquery\_ui\_datepicker/jquery\_ui\_datepicker.js" type="text/javascript"></script>  
 <script type="text/javascript">  
 $(function() {  
 $('#date').datepicker({  
 userLang : 'zh-TW',  
 americanMode: false,  
 dateFormat: 'yy-mm-dd'  
 });  
 });  
 </script>  
 <script src="js/jquery\_ui\_datepicker/i18n/ui.datepicker-zh-TW.js" type="text/javascript"></script>  
 <link rel="stylesheet" type="text/css" href="js/jquery\_ui\_datepicker/smothness/jquery\_ui\_datepicker.css">  
   
 <script src="js/jquery.MultiFile.js" type="text/javascript" language="javascript"></script>  
 </head>  
 <body>  
 <?php echo show\_event($\_GET\['sn'\]);?>  
 <form action="index.php" method="post" enctype="multipart/form-data">  
 日期：<input name="date" type="text" id="date" size="20">  
 <?php echo select\_event($\_GET\['sn'\]);?><br>  
 插圖：<input type="file" name="pic\[\]" class="multi"/>  
 <input type="submit" value="儲存" id="submit"><br>  
 <textarea name='event' cols=80 rows=15 class="ckeditor"></textarea>  
 <input name="op" type="hidden" value="save">  
   
 </form>  
 </body>  
 </html>

:::