chamilo-lms2/main/reports/multiquery.lib.php

<?php

// get fields informations
function multiquery_query($array)
{
    $result = array();
    $field = 0;
    for ($i = 0; $i < sizeof($array); $i++) {
        // mysql handler
        $result[$i]['mysql'] = mysql_query($array[$i]);

        if (!$result[$i]['mysql']) {
            die("error in query $i : ".$array[$i]);
        }

        // fields
        $result[$i]['num_fields'] = mysql_num_fields($result[$i]['mysql']);
        for ($j = 0; $j < $result[$i]['num_fields']; $j++) {
            $name = mysql_field_name($result[$i]['mysql'], $j);
            $result['field'][$field]['query'] = $i;
            $result['field'][$field]['name'] = $name;
            $result['field'][$field]['id'] = $j;
            $result['field_assoc'][$name][$field];
            $field++;
        }
    }
    $result['num_queries'] = sizeof($array);
    // rows
    $numberOfResult = mysql_num_rows($result[0]['mysql']);
    for ($i = 1; $i < $result['num_queries']; $i++) {
        if ($numberOfResult != mysql_num_rows($result[$i]['mysql'])) {
            die("wrong number of row: $numberOfResult vs ".
                mysql_num_rows($result[$i]['mysql'])." on query $i");
        }
    }

    $result['num_rows'] = $numberOfResult;
    $result['num_fields'] = $field;

    return $result;
}

function multiquery_num_rows(&$mq_h)
{
    return $mq_h['num_rows'];
}

function multiquery_num_fields(&$mq_h)
{
    return $mq_h['num_fields'];
}

function multiquery_field_name(&$mq_h, $id)
{
    return $mq_h['field'][$id]['name'];
}

function multiquery_fetch_row(&$mq_h)
{
    $result = array();
    $pos = 0;
    for ($i = 0; $i < $mq_h['num_queries']; $i++) {
        $row = mysql_fetch_row($mq_h[$i]['mysql']);
        if (!$row) {
            return false;
        } // last line
        for ($j = 0; $j < sizeof($row); $j++) {
            $result[$pos] = $row[$j];
            $pos++;
        }
    }
    return $result;
}