コード例 #1
0
function passes_filters($keys, $row, $filters)
{
    $passes = true;
    if (trim($filters['category'])) {
        if (!in_array($filters['category'], encode_row($keys, $row)['Career_Category'])) {
            $passes = false;
        }
    }
    if (trim($filters['major'])) {
        if (!in_array($filters['major'], encode_row($keys, $row)['Majors_Of_Study'])) {
            $passes = false;
        }
    }
    if (trim($filters['county'])) {
        if (!in_array($filters['county'], encode_row($keys, $row)['County'])) {
            $passes = false;
        }
    }
    if (trim($filters['college'])) {
        if (!in_array($filters['college'], encode_row($keys, $row)['School_Name'])) {
            $passes = false;
        }
    }
    if (trim($filters['school'])) {
        if (!in_array($filters['school'], encode_row($keys, $row)['School_Name'])) {
            $passes = false;
        }
    }
    if (trim($filters['degree'])) {
        if (!in_array($filters['degree'], encode_row($keys, $row)['Degree'])) {
            $passes = false;
        }
    }
    return $passes;
}
コード例 #2
0
<?php

include 'functions.php';
$reader = get_sheet_reader('.');
$output = [];
$first = 1;
foreach ($reader as $row) {
    if ($first) {
        $keys = $row;
        $first = 0;
    } else {
        if (passes_filters($keys, $row, $_GET)) {
            array_push($output, encode_row($keys, $row));
        }
    }
}
echo json_encode($output);