这是我现在正在使用的一个例子：

$stmt = $GLOBALS['link']->PRepare('SELECT * From tracking_redirect');
$stmt->execute();
$tracking = new tracking();
while($click = $stmt->fetch()){
    $tracking->checkClickIP($click['blogid'],$click['Campaignid'],$click['id'],$click['ipaddress']);
}

tracking_redirect是一个表,其中包含有关将哪些用户重定向到哪个站点的大量信息.我保存了诸如ipaddress,cookie-data,用户的日期和id之类的数据.该表目前有大约60,000行.

checkClickIP()是一个检查点击/重定向是合法还是有效的函数.确保同一用户未单击太多次的示例.

public function checkClickIP($userid,$campaignid,$clickid,$ipaddress = null) {
        if(!isset($ipaddress)){
            $ipaddress = $_SERVER['REMOTE_ADDR'];
        }

        $datestmt = $GLOBALS['link']->prepare('SELECT crdate From tracking_redirect WHERE id=:clickid');
        $datestmt->execute(array('clickid' => $clickid));
        $datestmt = $datestmt->fetch();

        $stmt = $GLOBALS['link']->prepare('SELECT COUNT(*) as total FROM tracking_redirect WHERE ipaddress=:ipaddress AND campaignid=:campaignid AND bLOGid=:userid AND crdate<:clickdate');
        $stmt->execute(array(
            'ipaddress' => $ipaddress,'campaignid' => $campaignid,'userid' => $userid,'clickdate' => $datestmt['crdate']
        ));
        $totalclicks = $stmt->fetch();

        //Same computer has clicked more than 5 times on the same campaign. ALERT WARNING!
        if($totalclicks['total'] >= 5){
            //Disable the click
            $disable = $GLOBALS['link']->prepare('UPDATE tracking_redirect SET disabled=:disabled WHERE id=:clickid');
            $disable->execute(array(
                'disabled' => 1,'clickid' => $clickid
            ));

            //Send a warning to the user if this PErson clicked 5 times on the same campaign.
            if($totalclicks['total'] == 5){
                $stmt = $GLOBALS['link']->prepare('SELECT * FROM user_login_history WHERE userid=:userid AND usertype=:usertype AND ipaddress=:ipaddress AND date(visITdate) BETWEEN :startdate AND :currentdate LIMIT 1');
                $stmt->execute(array(
                    'userid' => $userid,'usertype' => 1,'ipaddress' => $ipaddress,'startdate' => date('Y-m-d',strtotime('-3 months')),//If user logged in 3 months ago or closer from this IP
                    'currentdate' => date('Y-m-d')
                ));
                //The computer belongs to the blogger who published the ad. ALERT WARNING! USER CLICKING HIS OWN ADS
                if($loginhistory = $stmt->fetch()){
                    //Send warning to user.
                }
                //The computer does not belong to the blogger,but it's suspicIoUs behavior. ALERT WARNING! CHECK POST
                else{
                    //Send warning to user.
                }
            }
        }
    }

我知道在While循环之外准备语句会更好.但我仍然希望能够使用函数并拥有干净的代码.这段代码只是我无法运行while循环而没有服务器返回错误的一个例子,因为它超时等等.

因此,请不要在这种情况下过于依赖细节.但请提供可应用于其他代码的一般信息.我能做些什么来做这种循环~10,000或〜100,000次？