PHP完全自学手册(珍藏版) 中文pdf扫描版下载
user.php
/* 显示页面的action列表 */ $ui_arr = array('register', 'login', 'profile',... 增加 cz 然后在下面代码处加入 if ($action == 'cz')//冲值 { if($_GET['a']=='add'){ if (empty($_SESSION['user_id'])){ show_message("该用户不存在。", '返回上一页', 'user.php?act=cz'); } else{ $k=strtoupper(substr($_POST['k'],0,8)); $p=strtoupper(substr($_POST['p'],0,8)); $row = $db -> getRow("SELECT * FROM cz_access WHERE `kid`='$k' and kpass='$p'"); if (empty($row[id])){ show_message("卡号,密码不正确。", '返回上一页', 'user.php?act=cz');} if ($row[yes]>0){show_message("卡号已经被使用了。", '返回上一页', 'user.php?act=cz');} $r = $db -> getRow("SELECT num,name FROM cz_type WHERE id=".$row['type']); if(!(time()>=strtotime($r['ksj']) and strtotime(time()<=$r['jsj']))){show_message("该卡号不在使用范围之内。".$r['ksj']."--".$r['jsj'], '返回上一页', 'user.php?act=cz');} $db->query("update cz_access set yes=1,uid=".$_SESSION['user_id'].",sj='".date("Y-n-j G:i:s")."' where id=".$row['id']); log_account_change($_SESSION['user_id'],$r[num],0,0,0,'易购卡冲值'); $db->query("insert into cz_logs (log) values ('用户:".$_SESSION['user_id'].$_SESSION['user_name']."|冲值金额:".$r[num]."元|卡类型:".$r['name']."|时间:".date("Y-n-j G:i:s")."') "); show_message("冲值成功。", '返回上一页', 'user.php?act=cz'); } } include_once(ROOT_PATH .'includes/lib_clips.php'); $info=get_user_default($user_id); $smarty->assign('surplus', $info['surplus']); $sql = 'SELECT b.name,b.num,a.kid,a.kpass,a.sj FROM cz_access as a left join cz_type as b on a.type=b.id WHERE a.uid='.$user_id.' ORDER BY a.sj desc'; $list = $db->getAll($sql); $smarty->assign('list', $list); $smarty->display('user_transaction.dwt'); } -------------------------------------------------------------------------------------------------------------------- themes\default\user_transaction.dwt 模板里增加充值模板 <!-- {if $action eq "cz"} --> <h5 class="user-title"><span>我的易购卡</span></h5> <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#EDD28B"> <tr align="center"> <td bgcolor="#ffffff">{$lang.process_time}</td> <td bgcolor="#ffffff">{$lang.surplus_pro_type}</td> <td bgcolor="#ffffff">{$lang.money}</td> <td bgcolor="#ffffff">卡号</td> <td bgcolor="#ffffff">密码</td> </tr> <!--{foreach from=$list item=item}--> <tr> <td align="center" bgcolor="#ffffff">{$item.sj}</td> <td align="center" bgcolor="#ffffff">{$item.name}</td> <td align="center" bgcolor="#ffffff">{$item.num}</td> <td align="center" bgcolor="#ffffff">{$item.kid}</td> <td align="center" bgcolor="#ffffff">{$item.kpass}</td> </tr> <!--{/foreach}--> <tr> <td colspan="7" align="right" bgcolor="#ffffff">{$lang.current_surplus}{$surplus}</td> </tr> </table><br> <h5 class="user-title"><span>添加充值卡</span></h5> <div style="border:1px solid #EDD28B" class="box"> <form name="form1" method="post" action="user.php?act=cz&a=add"> <table width="80%" border="0"> <tr> <td width="80" align="center">卡号:</td> <td width="23%"><input name="k" type="text" id="k" maxlength="8" class="inputBg" ></td> <td width="80" align="center">密码:</td> <td width="39%"><input name="p" type="text" id="p" maxlength="8" class="inputBg" ></td> <td width="23%"> <input type="submit" name="button" id="button" value="冲 值" style="border:none;" class="bnt_blue_1"> </td> </tr></table></form> </div> <!-- {/if} --> ---------------------------------------------------------------------------------------------------------------------------------------------------------- themes\default\library\user_menu.lbi <a href="user.php?act=cz"{if $action eq 'cz'}class="curs"{/if}>我的充值卡</a> ------------------------------------------------------------------------------------------------------------------------ 数据库 充值卡表 CREATE TABLE IF NOT EXISTS `cz_access` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `kid` varchar(10) NOT NULL, `kpass` varchar(10) NOT NULL, `type` int(11) NOT NULL -->转载请注明:谷谷点程序 » ecshop 充值卡功能