在今天的这个专题内，我们先把用户管理系统模块中最后一项：注册信息的修改抛到一边，而直接进入我们程序的主体部分：用户个人帐户管理系统。
在开始这个专题之前，我们要在account（帐户列表）的结构中增加两个字段：account_type bigint NOT NULL/*帐户类型*/，currency bigint NOT NULL/*帐户币种*/，这样，我们相应的建库程序将改为：
CREATE TABLE account (
code bigint DEFAULT '0' NOT NULL auto_increment,/*编码*/
account_type bigint NOT NULL,/*帐户类型*/
currency bigint NOT NULL,/*帐户币种*/
name varchar(40) NOT NULL,/*名称*/
comment varchar(40) NULL,/*简要说明*/
money_open decimal(15,2) NOT NULL, /*开户余额*/
date_open date NOT NULL,/*开户日期*/
id_account varchar(30) NULL,/*帐号*/
password varchar(12) NULL,/*密码*/
interest_rate decimal(8,4) NULL,/*利率*/
user char(12) NOT NULL,/*用户*/
period tinyint NULL,/*存期*/
PRIMARY KEY (code))
|
在currency（币种列表）的结构中增加一个字段：exchange_rate decimal(12,6) NOT NULL/*外汇汇率*/，这样，我们相应的建库程序将改为：
CREATE TABLE currency (
code bigint DEFAULT '0' NOT NULL auto_increment,/*编码*/
name varchar(40) NOT NULL,/*名称*/
exchange_rate decimal(12,6) NOT NULL,/*外汇汇率*/
PRIMARY KEY (code))
|
今天我们将完成个人账户管理的网页account.php，在这个网页中，我们应该能完成帐户的新建、修改及删除。
我们的帐户类型分为现金、活期存款、定活两便、整存整取、零存整取、信用卡六种。
下面我们给出account.php的源程序:
<?php
include ("cookie_check.php");
?>
<HTML>
<TITLE> 网上理财：个人帐户管理 </TITLE>
<BODY>
<P ALIGN=CENTER><FONT FACE="隶书" SIZE="7" COLOR="#0000FF">网上理财
</FONT><BR>
<P ALIGN=LEFT>
<FONT FACE="宋体" SIZE="3" COLOR="#0000FF"><a href=index.php
STYLE=Text-Decoration:none>首页</a>>><a href=account.php
STYLE=Text-Decoration:none>个人帐户管理</a><BR>
<?php echo $cookie_name ?>的个人帐户列表：</FONT><BR>
<TABLE BORDER="1" CELLPADDING="0" CELLSPACING="0" align=center>
<TR>
<TD BGCOLOR="#FFFFFF" ALIGN="center" VALIGN="MIDDLE" width=100><
Font Face=宋体 Size=2 Color="#0000FF" >
帐户类型</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=150><Font
Face=宋体 Size=2 Color="#0000FF" >
帐户名称</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=150>
<Font Face=宋体 Size=2 Color="#0000FF" >
开户日期</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=300>
<Font Face=宋体 Size=2 Color="#0000FF" >
简要说明</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=150>
<Font Face=宋体 Size=2 Color="#0000FF" >
余额-折合人民币</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=100>
<Font Face=宋体 Size=2 Color="#0000FF" >
币种</FONT>
</TD><TD BGCOLOR="#FFFFFF" ALIGN="center" width=50>
</TD></TR>
<?php
if (!$limit) $limit=0;
$query = "select account.code as code,account_type.name as name_type,
account.name as name_account,CEILING money_open*exchange_rate*100)/100
as money,DATE_FORMAT(date_open,'%Y年%m月%d日') as mydate,comment,
currency.name as name_currency from account,account_type,currency
where (account.account_type=1 or account.account_type=6 or
money_open<>0) and user='".$cookie_user."' and
account.account_type=account_type.code and account.
currency=currency.code limit ".$limit.",15";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
$i=1;
while ($i<=14 and $row)
{$i++;
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['name_type'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['name_account'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['mydate'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['comment']." ";
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['money'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' align=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['name_currency'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' align=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "<a href='account_edit.php?code=.$row['code'].'
STYLE='Text-Decoration:none'>编辑</a></FONT>";
echo "</TD></TR>";
$row = mysql_fetch_array($res); }
$query = "select sum(CEILING(money_open*exchange_rate*100)/100)
as money_sum from account,currency
where (account.account_type=1 or account.account_type=6 or
money_open<>0) and user='".$cookie_user."'
and account.currency=currency.code";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo "<TR>";
echo "<TD BGCOLOR='#FFFFFF' ALIGN=left colspan=4>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo "合计";
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' ALIGN=right>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo $row['money_sum'];
echo "</FONT>";
echo "</TD><TD BGCOLOR='#FFFFFF' align=right colspan=3>";
echo "<Font Face=宋体 Size=2 Color='#0000FF' >";
echo " </FONT>";
echo "</TD></TR>";
echo "</TABLE>";
echo "<P ALIGN=RIGHT>";
$query = "select count(*) as count from account where
(account.account_type=1 or account.account_type=6 or money_open<>0)
and user='".$cookie_user."'";
$res = mysql_query($query);
$row = mysql_fetch_array($res);
$total=floor($row['count']/15)*15;
$limit_pre=$limit-15;
$limit_next=$limit+15;
echo "<Font Face=宋体 Size=3 Color='#0000FF' >";
echo "第";
echo $limit/15+1;
echo "页 共";
echo $total/15+1;
echo "页 ";
if ($limit!=0)
echo "<a href='account.php?limit=0'
STYLE='Text-Decoration:none'>";
echo "首页 ";
if ($limit!=0)
echo "</a>";
if ($limit!=$total)
echo "<a href='account.php?limit=.$total.'
STYLE='Text-Decoration:none'>";
echo "尾页 ";
if ($limit!=$total)
echo "</a>";
if ($limit_pre>=0)
echo "<a href='account.php?limit=.$limit_pre.'
STYLE='Text-Decoration:none'>";
echo "前页 ";
if ($limit_pre>=0) echo "</a>";
if ($limit_next<=$total)
echo "<a href='account.php?limit=.$limit_next.'
STYLE='Text-Decoration:none'>";
echo "后页 ";
if ($limit_next<=$total)
echo "</a>";
echo "</FONT>";
?>
<FORM NAME="form1" ACTION="account_insert.php"
METHOD="POST">
<P ALIGN=CENTER><INPUT TYPE=SUBMIT
VALUE=加入新帐户></FORM></BODY>
</HTML>
cookie_check..php的源程序为：
<?php
if (!$cookie_user)
{echo "<script language='javascript'>";
echo "alert('请先登录');";
echo "parent.location.href='index.php'";
echo "</script>";}
else {include ("connect.inc.php");
$query = "select * from my_user where user='".$cookie_user."'
and password='".$cookie_password."'";
$res = mysql_query($query);
if (!$res)
{echo "<script language='javascript'>";
echo "alert('参数错误，请重新登录');";
echo "parent.location.href='index.php'";
echo "</script>";}}
?>
如果您对本文有任何疑问或者建议，请到讨论区发表您的意见:
>>
论坛入口 <<
上一篇：一个网上理财站点的设计（四）
下一篇：一个网上理财站点的设计（六）
【文章评论】
【收藏本文】
【推荐好友】
【打印本文】
【我要投稿】 【论坛讨论】
更多相关文章
|
|
