准备工作
帝国CMS领号发号功能起点源码用三个字段来实现,大家可以参考下,先去模型新建这几个字段。
卡号字段(lbh):储存卡号,为textarea字段,一行一个;
总数字段(zongshu):储存“卡号字段”一共储存有多少行总数;
<input name="zongshu" type="text" id="zongshu" value="<?=$ecmsfirstpost==1?"":ehtmlspecialchars(stripSlashes($r[zongshu]))?>" size=""><input type=button name=button value="重新获取总数" onclick="zongshu.value=(lbh.value.split('\n')).length">
已领字段(yiling):用户每领取一个,这个字段就加1;
功能实现思路
点击“领取卡号”按钮,利用JS查询“已领字段”来判断显示“卡号字段”第几行的内容,显示完成后,“已领字段”加1,方便下次领取查询,就这么简单。
代码示例
领取按钮
< a href = "javascript:void(0);" value = "11" uid = "1" class = "fhb_btn Th" id = "linghao" >领取</ a > |
领取按钮JS
1
2
3
4
5
6
7
|
$( '#linghao' ).click( function (){ var lingId =0 lingId = $( "#linghao" ).attr( "value" ) uid = $( "#linghao" ).attr( "uid" ) $.get( "/fahao/hao.php?id=" +lingId+ "&uid=" +uid, function (data){ $( '#card' ).html(data); }); |
hao.php代码
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
<?php $id = $_GET [ "id" ]; $uid = $_GET [ "uid" ]; require ( "../e/class/connect.php" ); if (!defined( 'InEmpireCMS' )) { exit (); } require ( "../e/class/db_sql.php" ); require ( "../e/class/q_functions.php" ); $link =db_connect(); $empire = new mysqlquery(); $query = ( "select * from www_11px_cn_ecms_ecms_libao where id='$id'" ) //执行SQL语句 or die ( "SQL语句执行失败" ); $yiling =mysql_result( $query , 0, 'yiling' ); //输出第0行的name列 $zongshu =mysql_result( $query , 0, 'zongshu' ); //输出第0行的name列 $lbh =mysql_result( $query , 0, 'lbh' ); //输出第0行的name列 $picr = explode (egetzy( 'rn' ), $lbh ); $haomai = $picr [ $yiling ]; echo $haomai ; if ( $yiling == $zongshu ){ echo $picr [rand(0, $zongshu -1)]; $haomai = $picr [rand(0, $zongshu -1)]; } else { $yiling2 = $yiling +1; $query = ( "update www_11px_cn_ecms_ecms_libao set yiling=$yiling2 where id=$id" ) //执行SQL语句 or die ( "01SQL语句执行失败" ); } ?> |