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'"); //設定語系  
   
 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);  
 $sn=mysql\_insert\_id();  
   
 if(!empty($\_FILES\['pic'\]\['tmp\_name'\])){  
 foreach($\_FILES\['pic'\]\['tmp\_name'\] as $i => $tmpname){   
 move\_uploaded\_file($tmpname , "userfiles/images/{$sn}\_{$\_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;  
 <font color="#ff0000"> $pic=get\_pic($sn);</font>  
 $sql="select \* from diary where sn='$sn'";  
 $result=mysql\_query($sql) or die($sql);  
 list($sn,$date,$event)=mysql\_fetch\_row($result);  
 $main="<div class='page'>{$event}<font color="#ff0000">{$pic}</font></div>";  
 return $main;  
 }  
   
   
 <font color="#0000ff">//抓出圖檔  
 function get\_pic($sn=""){  
 $dir = "userfiles/images/";  
 if (is\_dir($dir)) {  
 if ($dh = opendir($dir)) {  
 while (($file = readdir($dh)) !== false) {  
 $ff=explode("\_",$file);  
 if($ff\[0\]==$sn){  
 $pics.="<img src='{$dir}{$file}'>";  
 }  
 }  
 closedir($dh);  
 }  
 }  
 return $pics;  
 }  
 </font>   
 ?>  
 <!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"></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" accept="jpg|png|gif|jpeg" maxlength="3"/>   
   
 <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>

:::