session_start(); include("include/config.php"); //connect sever $link=mysql_connect($db_sever,$db_user,$db_pass)or die("無法連接資料庫"); mysql_select_db($db,$link)or die("選擇的資料庫不存在"); $date=date("y-m-d"); //插入留言資料 if($insert==yes){ if(md5($_POST[authkey])==$_SESSION[se_auth_num]){ $query_insert="INSERT INTO $post_table (p_name, p_email, p_content, p_date, p_web, p_private ,p_time) VALUES ('$name','$mail', '$content', '$date', '$web', '$private' ,'$post_time')"; $result=mysql_query($query_insert)or die("插入資料表失敗"); echo ""; exit(); }else{ echo ""; } } ########################記入私人留言cookie############################### if(!($_COOKIE["aurabbs"])){ $time=time(); setcookie("aurabbs","$time",time()+311040000); }else{ $time=$_COOKIE["aurabbs"]; } #####記入驗證號碼##### srand((double)microtime()*1000000); $auth_num=rand()%10000; session_register("se_auth_num"); $_SESSION[se_auth_num]=md5($auth_num); ###登出### if($logout==true){ session_destroy(); echo "
"; exit(); }elseif($s_user){ echo ?>Hi, echo $s_user ; ?>您好 | ||
|
沒有留言紀錄
"; exit(); }; //得到最大頁碼數 $MaxPage = (int)ceil($nNumRows/$pagesize); if((int)$page > $MaxPage) $page=$maxPage; //用mysql_data_seek得到偏移量 if(mysql_data_seek($result2,($page-1)*$pagesize) ) { ?> $n=0; while($list2=mysql_fetch_array($result2)){ $n++; if($n>$pagesize){break;}//超過$n筆數就停止迴圈 echo ?> //錨點 echo "" ?>echo "共 $MaxPage 頁,目前位於第 $page 頁";?> |