php - 对结果集中的每 5 条记录调用一个函数

Question

我想使用自适应支付 API，据我所知，我只能将其用于 5 或​​ 6 条记录。有没有办法自动化获取例如 6 条记录的过程，在结果上调用函数然后从 6 条记录再次开始该过程？

我无法使用任何 php 数据库类，因为我在 WordPress 插件中使用它。仅供引用:https://codex.wordpress.org/Class_Reference/wpdb#SELECT_Generic_Results

示例结果:

    Array
(
    [0] => Array
        (
            [seller_paypal1] => yehuda@site.com
            [commission1] => 16.5
        )

    [1] => Array
        (
            [seller_paypal2] => yehuda@site.com
            [commission2] => 16.5
        )

    [2] => Array
        (
            [seller_paypal3] => yehuda@site.com
            [commission3] => 16.5
        )

    [3] => Array
        (
            [seller_paypal4] => yehuda@site.com
            [commission4] => 16.5
        )

    [4] => Array
        (
            [seller_paypal5] => yehuda@site.com
            [commission5] => 16.5
        )

    [5] => Array
        (
            [seller_paypal6] => yehuda@site.com
            [commission6] => 16.5
        )
    [6] => Array
        (
            [seller_paypal7] => yehuda@site.com
            [commission7] => 16.5
        )

)


<?php
// just a fiction way for example
foreach ($records /5 as record) {
  start record 0-5
  adaptive($record['seller_paypal'], $record['commission']);
  //5 records finished start from the 6-11
}

function adaptive($seller_email,$commission) {
// stuff here
}

Answer 1

PDOStatement::fetchAll — 返回一个包含所有结果集行或您想要的数组