📄 memo_list.php

📁 php写的论坛,代码精简到极点请相看说明文件。是从英文翻译过来的：）
💻 PHP
字号:
<?
include "connect.php";
include "lib.php";
include "header.inc";
echo"<script language=javascript>document.title='便条盒子'</script>\n";

////////////////////////////// 會員登入後才可打開便條盒子
if(!$HTTP_COOKIE_VARS[$member_cookie]){echo"<script>window.close()</script>";exit;}

////////////////////////////// 從資料表讀取會員的便條記錄
edit("$member_table","na3_check_memo='0'","id='$HTTP_COOKIE_VARS[$member_cookie]'");

////////////////////////////// 取得便條的總數
$total=total("$memo_table","and to_id='$HTTP_COOKIE_VARS[$member_cookie]'");

////////////////////////////// 定義每頁可顯示的便條數目
$page=5;

////////////////////////////// 定義每頁可顯示多少個頁次(快速換頁功能)
$pageviewsu=10;

////////////////////////////// 計算頁數
$pagesu=ceil($total/$page);
$start=($page*$pagenum);
$no=$total-$start;
$pagegroup=ceil(($pagenum+1)/$pageviewsu);
$pagestart=($pageviewsu*($pagegroup-1))+1;
$pageend=$pagestart+$pageviewsu-1;
$nowpage=$pagenum+1;
?>
<body>
<div id='Preview' style='position: absolute; z-index: 0; width: 320; visibility: hidden'></div>
<script language=javascript>
  var x = 0;
  var y = 0;
  var snow = 0;
  var sw = 0;
  var cnt = 0;
  var dir = 1;
  var offsetx = 3;
  var offsety = 3;
  var width = 400;
  var height = 30;

  over = Preview.style;
  document.onmousemove = mouseMove;

  function drs(text) {
	  if (text=='') {
	    text='blank';
	  }
	  dts(1,text);
  }

  function nd(st) {
    if ( cnt >= 1 ) { sw = 0; }
    if ( sw == 0 ) { snow = 0; hideObject(over); }
    else { cnt++; }
  }

  function dts(d,text) {
    txt = '<table style="border:1 #eeeeee solid;filter:Alpha(Opacity=80);" cellpadding=6 cellspacing=0 border=0><tr><td bgcolor=white style=word-break:break-all><font color=gray>'+text+'</font></td></tr></table>';
    layerWrite(txt);
    dir = d;
    disp();
  }

  function disp() {
    if (snow == 0) {
      if (dir == 2) { moveTo(over,x+offsetx-(width/2),y+offsety); } // 中
      if (dir == 1) { moveTo(over,x+offsetx,y+offsety); } // 右
      if (dir == 0) { moveTo(over,x-offsetx-width,y+offsety); } // 左
      showObject(over);
      snow = 1;
    }
  }

  function mouseMove(e) {
    x=event.x +5;
    y=event.y +5;
    if (snow) {
      if (dir == 2) { moveTo(over,x+offsetx-(width/2),y+offsety); } // 中
      if (dir == 1) { moveTo(over,x+offsetx,y+offsety); } // 右
      if (dir == 0) { moveTo(over,x-offsetx-width,y+offsety); } // 左
    }
  }

  function layerWrite(txt) { document.all['Preview'].innerHTML = txt; }
  function showObject(obj) { obj.visibility = 'visible'; }
  function hideObject(obj) { obj.visibility = 'hidden'; }
  function moveTo(obj,xL,yL) { obj.left = xL; obj.top = yL; }
</script>
<script language=javascript>
function check(){
to=document.chk.length-6;
if(chk.ok.value=="on"){
for(var i=0;i<to;i++){document.chk[i].checked=true;}
chk.ok.value="off";
chk.select_all.value="不选";
}
else{
for(var i=0;i<to;i++){document.chk[i].checked=false;}
chk.ok.value="on";
chk.select_all.value="全选";
}
}
function chk_del(){
if(!confirm('<?=$warning?>你确定删除选定的便条吗？')){return false;}
}
</script>

<link rel=stylesheet type=text/css href=style.css title=style>
<table width=100% height=100%>
<tr><td height=5></td></tr>
<tr><td valign=top>

<table align=center width=95% cellpadding=2 cellspacing=0 border=0 bgcolor=#F1F9FD>
<tr><td colspan=2 bgcolor=white><img src=image/logo.gif><br><br></td></tr>
<tr><td colspan=2 bgcolor=white>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td><font color=#008CD6 size=3>&nbsp;<b><a href=memo_write.php>传送便条</a></b>．<b>阅读便条</b>．<b>
<a href=member_list.php>会员列表</a></b></font></td>
<td align=right valign=bottom><?=$help?></td>
</tr></table>
</td></tr>

<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td colspan=2 bgcolor=#F1F9FD>

<table width=100% cellpadding=2 cellspacing=2>
<form method=post action=memo_delete.php onsubmit="return chk_del()" name=chk>
<tr>
<td colspan=2>&nbsp;&nbsp;您的便条盒子共有<b><?=$total?></b>张便条，目前显示<b><?=$nowpage?></b>页(共<b><?=$pagesu?></b>页)</td>
</tr>
<tr>
<td colspan=2>


<table align=center width=98% cellpadding=2 cellspacing=0 border=1 bordercolor=white>
<tr bgcolor=#C9F0FF>
<td width=1% nowrap align=center>编号</td>
<td width=1% nowrap align=center>选取</td>
<td width=1% nowrap align=center>寄便条者</td>
<td width=96% nowrap align=center>标题</td>
<td width=1% nowrap align=center>发送日期</td>
</tr>
<?
////////////////////////////// 傳送各項設定值
$send="&page=$page&";
$i=0;

////////////////////////////// 讀取便條記錄
$query="select * from $memo_table where to_id='$HTTP_COOKIE_VARS[$member_cookie]' order by no desc limit $start,$page";
$result=mysql_query($query,$connect);
while($data=mysql_fetch_array($result))
{
////////////////////////////// 選擇便條專用的核取方塊
$check="<input type=checkbox name=chk[$i] value='$data[no]' id=chk[$i]>";

////////////////////////////// 設定顯示日期及時間格式
$data[time]=date('Y年n月j日 H:i',$data[date]);
$data[date]=date('Y/m/d',$data[date]);

////////////////////////////// 設定便條的標記
$mark="<img src=image/memo_new.gif align=absmiddle>";
if($data[na3_check]){$mark="<img src=image/memo_old.gif align=absmiddle>";}
if($data[reply]){$mark="<img src=image/memo_re.gif align=absmiddle>";}

////////////////////////////// 取得寄便條者的會員資料
$from=member_info($data[from_id]);

////////////////////////////// 無論會員是否已保密個人資料，當滑鼠移至寄便條者的名稱時都會顯示即時資訊框
if($from[open]){
$from[memo]=eregi_replace("[\r\n\t\"]","",$from[memo]);
if($from[memo]){$from[memo]="<br><br>".$from[memo];}//kx021215i
$info="onMouseOver=\"drs('<table width=100% bgcolor=#F1F9FD><tr><td><font color=#2CBBFF><b>$from[id]</b> ($from[name])<br><br>邮箱：$from[mail]<br>网站：$from[home]$from[memo]</font></td></tr></table>'); return true;\" onMouseOut=\"nd(''); return true;\"";
}
else{$info="onMouseOver=\"drs('這名會員已設定保密個人資料。'); return true;\" onMouseOut=\"nd(''); return true;\"";}//kx021215m

////////////////////////////// 輸出到表格
echo"
<tr bgcolor=white>
<td width=1% nowrap align=center>$no</td>
<td width=1% nowrap align=center>$check</td>
<td width=1% nowrap align=center $info><label for=chk[$i]>$data[from_id]</label></td>
<td width=96%>$mark <a href=memo_read.php?no=$data[no]$send>".stripslashes($data[title])."</a></td>
<td width=1% nowrap align=center><div title='$data[time]'>$data[date]</div></td>
</tr>
";

////////////////////////////// 準備進入下一迴圈
$no--;$i++;
}
////////////////////////////// 將便條總數傳送到表單
echo"<input type=hidden name=count value=$i>";
?>
</table>

</td></tr>

<tr><td colspan=2 align=center><span style=font-size:8pt>
<?
////////////////////////////// 顯示頁次
index();
?>
</span></td></tr>

<tr><td colspan=2>

<table align=center width=98% cellpadding=2 cellspacing=0 border=0 bordercolor=white bgcolor=#C9F0FF>
<tr><td colspan=2>
<input type=hidden name=ok value=on>
<input type=hidden name=page value=<?=$page?>>
<input type=hidden name=pagenum value=<?=$pagenum?>>
<input type=button name=select_all class=button value='全选' onclick=check()> <input type=submit value='刪除' class=button>
</td></tr></table>

</td></tr>
</form>
</table>

</td></tr>
<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td bgcolor=white><a onclick=window.close() title='关闭视窗' style='cursor:hand'><span lang=zh-cn class=minichi>关闭</span></a></td><td bgcolor=white><?=$copyright?></td></tr>
</table>
</td></tr></table>

<?mysql_close($connect);?>
💿 文件大小 733 K
👤 上传用户 smellteen
📂 所属分类 MySQL数据库
🏷️ 相关标签

#php #论坛 #代码 #英文
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -