当前位置: 首页 > 图文教程 > 网络编程 > PHP > 杏林同学录(四)

PHP
工作笔记:配置MySQL为高可用集群 (1)
MySQL (C API)VC实例及代码下载 (1)(5)
MySQL (C API)VC实例及代码下载 (1)(4)
MySQL (C API)VC实例及代码下载 (1)(3)
MySQL (C API)VC实例及代码下载 (1)(2)
MySQL (C API)VC实例及代码下载 (1)
用JSP连接mysql数据库的方法 (1)(2)
用JSP连接mysql数据库的方法 (1)
MySQL数据库账户授权的相关管理解析 (1)(2)
MySQL数据库账户授权的相关管理解析 (1)
SAP MaxDB MySQL修补数据库严重漏洞
MySQL研发中心成立发布会会后访问整理 (1)(2)
MySQL研发中心成立发布会会后访问整理 (1)
MySQL中SQL-TEXT、DATE和SET数据类型
MySQL存在权限提升及安全限制绕过漏洞
MySQL 卸载的问题
windows下安装、卸载mysql服务
如何正确卸载MySQL
MySQL手册版本 5.0.20-MySQL优化(四) (1)(5)
MySQL手册版本 5.0.20-MySQL优化(四) (1)(4)

PHP 中的 杏林同学录(四)


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-10-12   浏览: 290 ::
收藏到网摘: n/a

个人管理:
班级通讯录:class/address.php
<?
session_start(); // 开始session
if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值,重新注册.
{
echo "<a href='../index.php'>请重新注册<BR>";
exit;
}
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>班级通讯录</TITLE>
<style type="text/css">
<!--
.white12 { font-size: 12pt; color: #FFFFFF; text-decoration: none}
.blue9 { font-size: 9pt; color: #9999FF}
-->
</style>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<table width="98%" border="0" cellspacing="0" cellpadding="0" height="65">
<tr>
<td width="35%"><img src="/upload/tech/20091012/20091012013226_3ad7c2ebb96fcba7cda0cf54a2e802f5.gif" width="224" height="60"> </td>
<td width="65%">
<table width="97%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CC0000" bordercolordark="#FFFFFF" bordercolor="#FFFFFF">
<tr>
<td><img src="/upload/tech/20091012/20091012013226_a1d0c6e83f027327d8461063f4ac58a6.gif" width="470" height="70" alt="班级通讯录"></td>
</tr>
</table>
</td>
</tr>
</table>
<?php
include "config.php";
$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');
$sex=mysql_result($result,$i,'sex');
$birth=mysql_result($result,$i,'birth');
$ph=mysql_result($result,$i,'ph');
$bp=mysql_result($result,$i,'bp');
$email=mysql_result($result,$i,'email');
$oicq=mysql_result($result,$i,'oicq');
$work=mysql_result($result,$i,'work');
$photo=mysql_result($result,$i,'photo');
$ad=mysql_result($result,$i,'ad');
$post=mysql_result($result,$i,'post');
$account=mysql_result($result,$i,'account');
$face=mysql_result($result,$i,'face');
$face='image/face/icon'.$face;
echo "<table width='76%' border='1' cellspacing='0' cellpadding='0' bordercolorlight='#330099' bordercolordark='#FFFFFF' align='center' class='blue9'> <tr bgcolor='#3399FF'> <td colspan='8'> <div class='white12' align='center'>......................○班级通讯录○....................</div> </td> </tr> <tr> <td width='30%'><img src='/upload/tech/20091012/20091012013227_8f468c873a32bb0619eaeb2050ba45d1.gif' width='32' height='32'> 姓名:$name</td> <td colspan='6'>性别:$sex</td> <td width='35%'>生日:$birth</td> </tr> <tr> <td colspan='7'>电话: $ph</td> <td width='34%'>传呼:$bp</td> </tr> <tr> <td colspan='7'>Email:<a href='mailto:$email'>$email</a></td> <td width='34%'>oicq:$oicq</td> </tr> <tr> <td colspan='7'>工作单位:$work</td> <td width='34%'>邮编:$post</td></tr> <tr><td colspan='8'>通讯地址:$ad</td></tr> <tr> <td colspan='8'>个人照片:$photo</td> </tr> <tr> <td colspan='8'>个人说明:$account</td> </tr></table>";
}
?>
</BODY>
</HTML>
个人资料修改:class/modify.php
<?
session_start(); // 开始session
if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值,重新注册.
{
echo "<a href='../index.php'>请重新注册<BR>";
exit;
}
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>个人资料修改</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<?php
include "config.php";
if ($submit){
if (!$username||!$psw||!$psw2||!$name||!$ad||!$ph||!$email){ //检查是否填写完整
echo "对不起,您必须填所有带*的项目!<BR>"."<a href='javascript:history.back()'>重填</a>";
exit;
}
$user=trim($username);
$psw=trim($psw);
$psw2=trim($psw2);
$name=trim($name);
$birth=trim($birth);
$work=trim($work);
$ad=trim($ad);
$post=trim($post);
$ph=trim($ph);
$bp=trim($bp);
$email=trim($email);
$oicq=trim($oicq);
$account=strip_tags(trim($account));//去掉首尾空格及html标记
$signature=strip_tags(trim($signature));
//检查密码重复是否正确
if (!$psw==$psw2){
echo "请确认密码,<a href='javascript:history.back()'>返回</a>";
exit;
}
//检查email的合法性
if(!ereg('^[-!#$%&'*+./0-9=?A-Z^_`a-z{|}~]+'.'@'.'[-!#$%&'*+\/0-9=?A-Z^_`a-z{|}~]+.'.'[-!#$%&'*+\./0-9=?A-Z^_`a-z{|}~]+$',$email)&&$email){
echo "email不合法!<BR>"."<a href='register_step2.php?yname=$name'>重填</a><BR>";
exit;}
//写入数据库
$sql="UPDATE user SET user='$user',psw='$psw',name='$name',sex='$sex',birth='$birth',work='$work',ad='$ad',post='$post',ph='$ph',bp='$bp',email='$email',oicq='$oicq',account='$account',signature='$signature',face='$face' where user='$userregister'";
$result = mysql_query($sql,$db);
mysql_close($db);
//发祝贺邮件
$subject="祝贺你成功修改个人信息".$sitename."!";//主题
$message=$name.",你好:<BR> 祝贺你成功修改个人信息!您的用户名为".$username.",密码为".$psw."<BR>现在登陆<a href='$url'>$sitename</a>";//信件内容
$headers .= "Content-Type: text/html; charset=gb2312n"; // Mime type
mail($email,$subject,$message,$headers);
echo "恭喜您修改成功!一封欢迎信已发到您的邮箱,请注意查收。";
exit;
}
$result = mysql_query("SELECT * FROM user where user='$userregister'",$db);
$psw=mysql_result($result,0,"psw");
$name=mysql_result($result,0,"name");//读取个人注册信息
$sex=mysql_result($result,0,"sex");
$birth=mysql_result($result,0,"birth");
$work=mysql_result($result,0,"work");
$ad=mysql_result($result,0,"ad");
$post=mysql_result($result,0,"post");
$ph=mysql_result($result,0,"ph");
$bp=mysql_result($result,0,"bp");
$email=mysql_result($result,0,"email");
$oicq=mysql_result($result,0,"oicq");
$photo=mysql_result($result,0,"photo");
$account=mysql_result($result,0,"account");
$signature=mysql_result($result,0,"signature");
$face=mysql_result($result,0,"face");
mysql_close($db);
?>
<table width='95%' border='0' cellspacing='0' cellpadding='0' align='center'>
<tr>
<td colspan="2">
<div align="center"><img src="/upload/tech/20091012/20091012013226_3ad7c2ebb96fcba7cda0cf54a2e802f5.gif" width="224" height="60"></div>
</td>
</tr>
<tr>
<td>
<div align="center">个人资料修改<br>
注意不要有空格,带*的项目为必填。</div>
</td>
</tr>
<tr>
<td colspan="2">
<form method='post' action='<? echo $PHP_SELF;?>'>
<table width="95%" border="1" cellspacing="1" cellpadding="0" align="center" bordercolor="#FFCC00">
<tr>
<td height="153" width="60%"><br>
用户名:
<input type='Text' name='username' size='12' maxlength='12' value="<? echo $userregister;?>">
*<br>
(英文字母或加数字,长度不超过12)<br>
密码:
<input type='password' name='psw' size='8' maxlength='8' value="<? echo $psw; ?>">
*<br>
(英文字母或加数字,长度不超过8个字符)<br>
确认密码:
<input type='password' name='psw2' size='8' maxlength='8' value="<? echo $psw; ?>">
*<br>
姓名:
<input type='Text' name='name' size='8' maxlength='8' value="<? echo $name; ?>">
*<br>
性别:男
<input type='radio' name='sex' value='男' <? if ($sex=='男'){echo "checked";} ?>>

<input type='radio' name='sex' value='女' <? if ($sex=='女'){echo "checked";} ?>>
<br>
生日:<input type="text" name="birth" size="12" maxlength="12" value="<? echo $birth; ?>"><br>
工作单位:
<input type='Text' name='work' size='30' maxlength='50' value="<? echo $work; ?>">
<br>
通讯地址:
<input type='Text' name='ad' size='30' maxlength='50' value="<? echo $ad; ?>">
*<br>
邮编:
<input type='Text' name='post' size='6' maxlength='6' value="<? echo $post; ?>">
<br>
电话:
<input type='Text' name='ph' size='15' maxlength='30' value="<? echo $ph; ?>">
*<br>
传呼:
<input type='Text' name='bp' size='15' maxlength='20' value="<? echo $bp; ?>">
<br>
Email:
<input type='Text' name='email' size='15' maxlength='35' value="<? echo $email; ?>">
*<br>
oicq:
<input type='Text' name='oicq' size='12' maxlength='12' value="<? echo $oicq; ?>">
<br>
个人说明:(在通讯录里显示,不超过125个汉字)<BR>
<textarea name='account' cols='50' rows='5'><? echo $account; ?></textarea>
<br>
个人签名:(在留言簿的自动签名,不超过125个汉字)<br>
<textarea name="signature" cols="50" rows="5"><? echo $signature; ?></textarea>
</td>
<td height="153" width="40%"><br>
选择一个自己喜欢的头像:<br>
<?
for ($i=1;$i<=64;$i++){
echo "<img src='image/face/icon".$i.".gif' width='32' height='32'>";
echo "<input type='radio' name='face' value='$i' ";
if ($face==$i){
echo "checked";
}
echo ">";
if (($i%4)==0){ //隔4行,换行
echo "<br>";
}
}
?><br>
</td>
</tr>
</table>
<div align="center">
<br>
<input type='Submit' name='submit' value='提交'>
<input type='reset' name='Reset' value='重写 '>
</div>
</form>
</td>
</tr>
</table>
</BODY>
</HTML>
上传照片:class/uploadphoto.php
<?
session_start(); // 开始session
if(!session_is_registered("userregister")||($userregister==""))//检查是否注册,如userregister未注册或session为空值,重新注册.
{
echo "<a href='../../index.php'>请重新注册<BR>";
exit;
}
?>
<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<TITLE>上传照片</TITLE>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<?php
include "../config.php";
if ($upload){
if ($picurl=="none"){
echo "你没有上传任何文件.";
exit;
}
$v=opendir("image");
if ($v==0)
{ mkdir("image"); //若目录不存在,则新建一个
$v=opendir("image"); //取得目录handle
}
$up=copy("$picurl","image/$picurl_name");
if($up==1)
{
//初始化写入内容
$result = mysql_query("SELECT * FROM user where user='$userregister'",$db);//查询以往照片信息
$photo=mysql_result($result,0,'photo');
$photo=str_replace("'","'",$photo);//将'用'代替
$photo=$photo."<a href='upload/image/$picurl_name'>看照片</a>|";//加上此次内容
mysql_query("UPDATE user SET photo='$photo' where user='$userregister'",$db);//写入
mysql_close($db);
echo "文件上传成功!<BR>";
echo "文件名:$picurl_name 文件大小:$picurl_size byte 文件类型:$picurl_type<BR>";
}
else
{echo "文件上传失败.";exit;}
unlink ($picurl); //从临时文件夹中删除档案$picurl
closedir ($v); //关闭目录handle
exit;
}
?>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="56" width="32%"><img src="..//upload/tech/20091012/20091012013226_3ad7c2ebb96fcba7cda0cf54a2e802f5.gif" width="224" height="60"></td>
<td height="56" width="68%">
<div align="center">上传照片</div>
</td>
</tr>
<tr>
<td height="108" colspan="2"><form action="<? echo $PHP_SELF;?>" method="post" enctype="multipart/form-data" name="UL">
<!--注意:这里必须加上‘enctype="multipart/form-data" ',否则不会产生上
传动作-->
<div align="center">上传照片:
<input type="file" name="picurl" size="15" accept="image/x-png,image/gif,image/jpeg">
<br>
<input type="Submit" name="upload" value="上传">
<input type="reset" name="Reset" value="重写">
</div>
</form>
</td>
</tr>
</table>
</BODY>
</HTML>