根据DEDE自制报名系统（有后台和权限）

来源：互联网发布：淘宝去边框代码编辑：程序博客网时间：2024/05/04 21:58

模版中的报名连接为index.php?ser_type={dede:field.id/}，就是从商品或软件页面点击“报名预约”后，根据ID转到报名页。

一、首先创建数据库.

以下为index.php相关表格代码：

<form name="myform" method="post" action="ok.php"  onSubmit="javascript:return check(myform);">                <ul class="inputCentent">                    <input type="hidden" name="title" value="预约信息" ></input>        </li>                    <li style="display: none;"><span>预约企业：</span><input type="hidden" name="ser_type" value="<?php echo $ser_type ?>" class="inputcom"></input></li>                                        <li><span>预约企业：</span>                        <div class="select-box">                            <div class="select-wrap">                                <select name="company" class="city">                            <?php$ser_type = $_GET['ser_type'];$result = mysql_query("select id,title from  `数据库`.`表_archives` where channel=3");while($title = mysql_fetch_array($result)){?> <option <?php if($title["id"]==$ser_type) echo("selected");?> ><?php echo $title["title"]; ?></option><?php } ?></select>                            </div>                        </div>                                             </li>                    <li><span>您的称呼：</span><input type="text" name="name"  class="inputcom" maxlength="50"></input>  <span class="style2">*必填</span></li>                    <li><span>联系手机：</span><input type="text" name="mobi"  class="inputcom"></input>  <span class="style2">*必填</span></li>                     <li><span>年　龄：</span><input type="text" name="age"  class="inputcom"></input>  <span class="style2">*必填</span></li>                    <li><span>QQ号码：</span><input type="text" name="QQ"  class="inputcom"></input></li>                    <li><span>地　址：</span><input type="text" name="address"  class="inputcom" style="width:500px;"></input></li>                    <li><span>填验证码：</span><input  name="code" class="inputcom" style="width:120px;"/><img src="img.php" height="25" border="0" alt="" onclick="this.src=this.src+'?'+Math.random()" class="code" alt="点击刷新" title="点击刷新"></img></li>                    <li><input type="hidden" name="referrer"/> <input id="channel" type="hidden" value="submit" name="submit"/><input type="submit" height="38" width="84" value="立即提交网站需求" class="a_demo_one" title="立即提交网站需求"/> </li>                </ul>            </form>

以下为提交后的ok.php页面代码：

<?php date_default_timezone_set('Asia/Shanghai');//时区设置//接收表单提交到的数据，生命变量session_start();if ($_POST[submit]) {        if (strtolower($_SESSION[an]) == strtolower($_POST[code])) {          } else {        echo "<script>alert('验证码不正确请重新输入！');history.back();</script>";exit;    }} $name=$_POST['name'];$company = $_POST['company'];$age = $_POST['age'];$mobi = $_POST['mobi'];$address = $_POST['address'];$QQ = $_POST['QQ'];$time = date("Y-m-d H:i:s");$stm="<html><head><title></title><meta http-equiv='refresh' content='1;url=http://网站/index2.php'><style>.title { font-family: '宋体'; font-size: 13px; line-height: 150% ; color: #FFFFFF}</style></head><body bgcolor=dfdfdf text=#000000></body></html>";require("insert.php"); //提交数据到数据库exit; ?>

然后到插入页面：insert.php

<?php$con = mysql_connect("localhost","用户名","密码");//连接数据库echo "$stm" ;if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("数据库", $con);mysql_query('set names GB2312');//设置插入数据库的字符集格式，避免数据库中的数据出现乱码$sql="insert into `数据库`.`表名_message` (name,company,age,mobi,QQ,address,ordTime) values ('$name','$company','$age','$mobi','$QQ','$address','$time')"; //数据入库if (!mysql_query($sql,$con))  {  die('Error: ' . mysql_error());  }mysql_close($con);?>

以下为后台页面sys_message_user.php

<?php/** * 用户管理 * * @version        $Id: sys_admin_user.php 1 16:22 2010年7月20日Z tianya $ * @package        DedeCMS.Administrator * @copyright      Copyright (c) 2007 - 2010, DesDev, Inc. * @license        http://help.dedecms.com/usersguide/license.html * @link           http://www.dedecms.com */require_once(dirname(__FILE__)."/config.php");CheckPurview('sys_message');require_once(DEDEINC."/datalistcp.class.php");setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/");$query = "SELECT aid,name,company,age,mobi,address,QQ,ordTime FROM `#@__message` WHERE company LIKE '%$company%' ORDER BY aid desc";$dlist = new DataListCP();$dlist->SetTemplet(DEDEADMIN."/templets/sys_message_user.htm");$dlist->SetSource($query);$dlist->Display();

模版代码sys_message_user.htm

{dede:config.pagesize value="20"/}<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>管理员帐号</title><link href="css/base.css" rel="stylesheet" type="text/css"></head><body background='images/allbg.gif' leftmargin='8' topmargin='8'><table width="98%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#D6D6D6">  <tr>    <td height="27" colspan="8" background="images/tbg.gif" bgcolor="#E7E7E7">    <table width="96%" border="0" cellspacing="1" cellpadding="1">        <tr>          <td width="24%" style="padding-left:10px;"><b>报名信息</b> </td>          <td width="76%" align="right"><b>          </td>        </tr>      </table>     </td>  </tr>  <tr bgcolor="#FBFCE2">    <td width="5%" height="24" align="center">登录ID</td>    <td width="8%" align="center">姓名</td>    <td width="22%" align="center">报名公司</td>    <td width="8%" align="center">年龄</td>    <td width="10%" align="center">手机号码</td>    <td width="10%" align="center">地址</td>    <td width="10%" align="center">QQ号码</td>    <td width="10%" align="center">时间</td>  </tr>  {dede:datalist}  <tr bgcolor="#FFFFFF" align="center">    <td>{dede:field.aid /}</td>    <td>{dede:field.name /}<br> </td>    <td>{dede:field.company /}</td>    <td>{dede:field.age /}</td>    <td>{dede:field.mobi /}</td>    <td>{dede:field.address /}</td>    <td>{dede:field.QQ /}</td>    <td>{dede:field.ordTime /}</td>  </tr>  {/dede:datalist}  <tr bgcolor="#F9FCEF">    <td height="24" colspan="8" align="center" valign="top">    {dede:pagelist listsize='7' /}    </td>  </tr></table></body></html>

然后在后台目录/inc/inc_menu.php中添加报名的列表

<m:top item='1_' name='常用操作' display='block'>  <m:item name='网站栏目' link='catalog_main.php'  rank='t_List,t_AccList' target='main' />  <m:item name='单页文档' link='templets_one.php' rank='temp_One' target='main'/> <m:item name='报名信息' link=sys_message_user.php' rank='sys_message' target='main'/>  <m:item name='Tags标签管理' link=tags_main.php' rank='sys_tags' target='main'/></m:top>

不同版本可能有差异，但是大致应该差不多，希望能帮助大家。

0 0