创立文件交流功能的台本(一卡塔尔
分类:热门资源

因为工作的原因需要在局域网上安装一个文件交换的东西,也可以作成一个文件上下载的功能块。 用的是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

本文由威尼斯在线注册平台发布于热门资源,转载请注明出处:创立文件交流功能的台本(一卡塔尔

上一篇:Whois 的PHP代码 下一篇:没有了
猜你喜欢
热门排行
精彩图文