【www.gdgbn.com--英文短信】

用户提交自己的信息后，保存在数据库教程中，程序每一次读取当前结果时都要判断一次，如用户可设置几秒钟时参加竞拍，竞拍多少次，并且可以设置前面有多少人竞拍后我才参加，都是一些人性化的功能//自动出价

function auto($second,$gid,$shutuid)
{
        global $table_prefix;
        //取出此商品已经竞拍次数
        $maxnumber=0;
        $unumber=array();
        $query=mysql教程_query("select id,uid from `".$table_prefix."buylog` where gid=".$gid);
        while($rows=mysql_fetch_assoc($query))
        {
                $maxnumber++;
                if(isset($unumber[$rows["uid"]]))
                {
                        $unumber[$rows["uid"]]++;
                }
                else
                {
                        $unumber[$rows["uid"]]=0;
                }
        }
       
        //取出自动竞拍的会员
        $sql="select uid,username,number,second,maxnumber,gid,ip from `".$table_prefix."autobuy` where gid=".$gid;
        $query=mysql_query($sql);
        $allow=array();
        $shutuid=explode(",",$shutuid);
        while($rows=mysql_fetch_assoc($query))
        {
                $seconds=explode(",",$rows["second"]);
                $unumber[$rows["uid"]]=isset($unumber[$rows["uid"]])?$unumber[$rows["uid"]]:0;
                if(in_array($second,$seconds) && !in_array($rows["uid"],$shutuid) && $rows["maxnumber"]<=$maxnumber && $rows["number"]>$unumber[$rows["uid"]]) //包含时刻,并且不在黑名单,符合此会员竞拍次数设置
                {
                        $allow[]=$rows["uid"];
                }
        }
        $allowuser=array();
        if($allow)
        {
                $query=mysql_query("select uid,username,money,ip from `".$table_prefix."user` where uid in (".implode(",",$allow).")");
                while($rows=mysql_fetch_assoc($query))
                {
                        $allowuser[]=$rows;
                }
        }
        unset($allow,$sql,$number,$maxnumber,$shutuid,$query,$u);
        return $allowuser;
}

本文来源：http://www.gdgbn.com/zhufuduanxin/27954/