建立文件交换功能的脚本(一)

因为工作的原因需要在局域网上安装一个文件交换的东西,也可以作成一个文件上下载的功能块。
用的是php,mysql,apache现将程序编写过程贴出来,因为作这个参考来oso的一些文章,也算是一个补充,
也表达我对前辈们的敬意。
准备工作在你的mysql的yourdatabase库中建一个表upfile /*上传文件表 CREATE
TABLE upfile ( id TINYINT (8) not null AUTO_INCREMENT,//文件的id号
filename VARCHAR (80) not null,//文件名 fileshow VARCHAR (80) not
null,//文件说明 date DATE not null,//上传日期 uploader VARCHAR (40) not
null,//上传者签名 type VARCHAR (40) not null,//文件类型PRIMARY KEY (id)
) */ //这是该程序的主页面,用来显示上载的文件。 //index.php html body
bgcolor=#FFFFFF head title文件交换/title meta content=text/html;
charset=gb2312 /head div align=center table width=500 border=0
cellspacing=0 cellpadding=0 height=25 tr td height=25div
align=center文件交换区/div /td /tr /table table width=600 border=0
cellspacing=0 cellpadding=0 height=20 trtd height=25 width=75div
align=centera href=upload.php上载文件/a/div /td /tr /table table
width=600 border=0 cellspacing=0 cellpadding=0 height=79 tr
valign=toptddiv align=center?
$db=mysql_connect($hostname,$user,$password)or die(无法连接数据库);
//连接书库库 mysql_select_澳门新葡萄京娱乐场,db(yourdatabse,$db) or die(无法打开数据库);
$sql=select * from upfile; $result=mysql_query($sql); if ($myrow =
mysql_fetch_array($result)) {echo table border=1 /n;echo
trtd文件名/tdtd上传日期/tdtd上传者/tdtd文件说明/tdtd文件类型/td/tr/n;do
{printf(trtda
href=/../file/%s/%s/a/tdtd%s/tdtd%s/tdtd%s/tdtd%s/td/tr/n,$myrow[filename],$myrow[filename],$myrow[date],$myrow[uploader],$myrow[fileshow],$myrow[type]);
}//把所有的文件都列出来提供下载。 while ($myrow =
mysql_fetch_array($result));echo /table/p/n; }else {echo
文件交换区没有文件bra href=’index.php’返回/a;} ?/div /td /tr /table /div
/body /html

成员主页:main.php ? session_start(); // 开始session
session_register(userregister); $userregister=$username; include
class/config.php; $result = mysql_query(SELECT * FROM user where
user=’$username’,$db); if
(mysql_num_rows($result)==0){//若返回列的数目为0,说明无此资料 echo
无此用户!; exit;} $userpsw=strtoupper(trim($userpsw));
$password=trim(mysql_result($result,0,’psw’));
$password=strtoupper($password);//取得密码,转换成大写
$userpsw=strtoupper($userpsw); if (!($userpsw==$password)){ echo
密码错误!; mysql_close($db); exit; }
$name=mysql_result($result,0,name);
$count=mysql_result($result,0,count)+1;//成员计数器加1
mysql_query(UPDATE user SET count=$count where user=’$username’,$db); ?
HTML HEAD meta content=text/html; charset=gb2312
TITLE欢迎来到杏林同学录/TITLE style type=text/css !– .deepblue10
{font-family: 宋体; font-size: 10pt; color: #3333FF; text-decoration:
none} A.purple:hover {font-size: 9pt; color: #3366FF; background-color:
#99FFFF; text-decoration: none} A.purple:link {font-size: 10pt;
text-decoration: none} a:hover {text-decoration: none} a:visited
{text-decoration: none} A.purple {font-size: 10pt; color: #CC00FF;
text-decoration: none} .white12 {font-size: 12pt; color: #FFFFFF;
text-decoration: none} .purple {color: #CC00FF; text-decoration: none;
font-size: 10pt} .brown9 {font-size: 10pt; color: #6600CC;
text-decoration: none} .black9 {font-size: 9pt; text-decoration: none}
.yellow12 {font-size: 12px; color: #9900CC; text-decoration: none;
font-weight: normal} .redlarge {font-size: 18px; font-weight: bolder;
color: #FF00CC} .grey9 {font-size: 9pt; color: #CCCCCC} — /style
/HEAD BODY BGCOLOR=#FFFFFF table width=755 border=1 height=65
cellpadding=0 cellspacing=0 bordercolorlight=#FF33CC
bordercolordark=#FFFFFF trtd width=241div align=rightimg
src=class/image/classlogo.gif width=224 height=60 alt=同学录/div /td td
width=508 object classid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000
codebase=#version=4,0,2,0 width=478 height=60 align=right param
name=movie value=class/image/2.swf param name=quality value=high embed
src=class/image/2.swf quality=high
pluginspage=_Prod_Version=ShockwaveFlash
type=application/x-shockwave-flash width=478 height=60 align=right
/embed/object/td /tr /table table width=755 border=0 cellspacing=0
cellpadding=0 trtd class=black9 width=302 北京时间? echo
date(Y年m月d日);? /td td class=black9 width=453?php echo
您好,,$name,。; echo 欢迎您第, $count,次光临本站。; ? /td /tr /table
table width=755 border=0 cellpadding=0 cellspacing=0 tr td width=19%
bgcolor=#FFeeFF valign=toptable width=100% border=0 cellspacing=0
cellpadding=0 trtd height=20 background=class/image/redbar.gifdiv
align=center class=yellow12 同学录/div /td /tr trtd height=19 div
align=centera href=class/address.php title=最新通讯信息 class=purple
target=_blank/a/div /td /tr trtd height=19div align=center class=purple
a href=class/modify.php title=修改个人资料 class=purple
target=_blank/a/div /td /tr trtd height=19div align=centerclass=purplea
href=class/upload/uploadphoto.php title=修改个人资料 class=purple
target=_blank/a/div /td /tr trtd height=21div align=centera
href=class/classphoto.phpclass=purple target=_blank /a/div /td /tr trtd
height=19div align=centera href=class/privatephoto.php
title=展现个人风采 class=purple target=_blank /a/div /td /tr trtd
height=19div align=centera href=class/shoolphoto.php
title=唤起你美好回忆 class=purple target=_blank /a/div /td /tr trtd
height=19div align=centera href=class/privatenote.php
title=给单个同学留言 class=purple target=_blank/a/div /td /tr trtd
height=19div align=centera href=class/notebook/index.php
title=留下你的祝福 class=purple target=_blank /a/div /td /tr tr
bgcolor=#FF99CCtd height=20 bgcolor=#FF99CC
background=class/image/redbar.gif div align=center
class=yellow12班级聊天室/div /td /tr trtd height=21div align=center
class=purple /div /td /tr trtd div align=center class=purple/div /td /tr
trtd height=20 background=class/image/redbar.gifdiv align=center
class=yellow12 友情链接/div /td /tr trtddiv align=centera href=
title=neo的个人主页 target=_blankimg src=class/image/logo2.gif width=82
height=31 border=0/a/div /td /tr trtddiv align=centera href=
target=_blankimg src=class/image/a31.gif width=81 height=33 border=0
alt=国内最好的同学录/a/div /td /tr trtd height=24div align=center
class=purplea href= class=purpletarget=_blank杏林医疗在线/a/div /td /tr
trtd height=22div align=center a href= title=非常有特色的同学录
class=purple target=_blank ChinaRen校友录/a/div /td /tr trtd height=22
bgcolor=#FFCCFFdiv align=centera href=superadmin.php class=purple
target=_blank班级管理/a/div /td /tr /table /td td width=61%
height=308div align=centerimg src=class/image/821036.jpg width=400
height=166 alt=这里换成班级照片/div table width=87% border=1
cellspacing=0 cellpadding=0 align=center height=109
bordercolorlight=#9999FF bordercolordark=#FFFFFF trtddiv align=center
class=redlargeb祝贺词/b /div /td /tr trtd class=brown9 height=19img
src=class/image/bz.gif width=15 height=161.欢迎使用杏林同学录。/td /tr
trtd class=brown9img src=class/image/bz.gif width=15
height=162.如果发现bug,请尽快通知我。/td /tr trtd class=brown9 img
src=class/image/bz.gif width=15 height=163.技术支持: a
href=mailto:webmaster@medguider.51.net
class=purplewebmaster@medguider.51.net/a/td /tr trtddiv align=center
class=redlarge 最新留言/div /td /tr trtd class=brown9?php $result =
mysql_query(SELECT * FROM notebook,$db);
$row=mysql_num_rows($result); if ($row=1) {$x=$row;} else {$x=2;}
$result = mysql_query(select * from notebook ORDER BY time DESC limit
0,$x,$db);//读取最近2条留言 for ($i=0;$i=($x-1);$i++) {
$user=mysql_result($result,$i,’user’); $resulty=mysql_query(select *
from user where user=’$user’,$db);
$name=mysql_result($resulty,0,’name’);
$time=mysql_result($result,$i,’time’);
$title=mysql_result($result,$i,’title’);
$nnote=mysql_result($result,$i,’nnote’); echo ◆留言人:$name 时间 $time
BR主题:$titleBR内容:$nnoteBR; } ? /td /tr /table /td td valign=top
width=20% bgcolor=#CFBD9Btable border=0 cellspacing=0 cellpadding=0
width=100% trtd background=class/image/yellowbar3.gif class=white12
height=19div align=center悄悄话/div /td /tr trtd bgcolor=#FFFEEFFdiv
align=center class=brown9 ?php $result = mysql_query(SELECT * FROM
privatenote where touser=’$userregister’,$db);
$row=mysql_num_rows($result);//悄悄话总数 $unlook=0;if (!$row==0){ for
($i=0;$i$row;$i++){
$look=mysql_result($result,$i,’look’);//计算未看过的悄悄话数目 if
($look==0){$unlook++;}} } echo 您有.$unlook.条新悄悄话.总共有.$row.条。a
href=’class/privatenote.php’ target=’_blank’查看悄悄话/a;? /div /td /tr
trtd bgcolor=#FFCC66 class=white12 height=20div
align=center通讯录名单/div/td /tr trtd class=brown9 height=77
bgcolor=#FFFEEFF ? $result = mysql_query(SELECT * FROM user,$db);
$row=mysql_num_rows($result);//查看结果有多少行,即成员人数 for
($i=0;$i=($row-1);$i++){ $name=mysql_result($result,$i,’name’); echo
$name,,; } mysql_close($db); ? /td /tr trtdtable border=0 cellspacing=0
cellpadding=0 bgcolor=#CFBD9B width=150 trtd height=24 colspan=3img
src=class/image/noticebar.gif width=150 height=25/td /tr trtd height=182
width=6%/td td width=88% bgcolor=#FFFFFF
background=class/image/fanhor01-1.jpg class=deepblue10marquee
direction=up scrollamount=1 scrolldelay=130 font
color=#FFCC66★/font本网站已被搜狐、新浪收录br font
color=#FFCC66★/font感谢leo为我们做的新动画logo.br font
color=#FFCC66★/font经过数日的努力,终于用php和mysql数据库将新版同学录做好。特点:用户可在线修改资料;上传照片;悄悄话,oicq头像。br
font color=#FFCC66★/font5460中国同学录上我们班已有14人加入。br font
color=#FFCC66★/font 如果您有漂亮的扫描好的个人照片,请尽快上传。br
/marqee /td td height=182 width=6%/td /tr trtd colspan=3 height=4/td /tr
/table/td /tr /table /td /tr /table div align=centerp
class=black9您是第?php //总计数器 $fs = fopen(class/counter.txt,r+);$hit
= fgets($fs,10);$hit+=1;rewind($fs);fwrite($fs,$hit,10);$hit =
number_format($hit);fclose($fs); echo font color=’#33FF00’$hit/font; ?
位来访者!br 主页制作:a href= class=black9医学导航网/abr span
class=grey9本页使用了flash,如果不能正常浏览,请安装a href=插件/a/span/p
/div /BODY /HTML

发表评论

电子邮件地址不会被公开。 必填项已用*标注