VERIFY-php

<?php
require_once "medoo.php"; //we use this as the ORM tool to query databases

$db = new medoo(array(
    'database_type' => 'mysql',
    'database_name' => 'XXXXXX',
    'server' => 'XXXXXX',
    'username' => 'XXXXXX',
    'password' => 'XXXXXX',
    'charset' => 'utf8'
));
$memberID = isset($_POST['memberid']) ? $_POST['memberid'] : '';
//now lets query the database

$data = $db->select('membershipperson',[

        '[>]person' => ['PersonID' => 'PersonID'],
        '[>]users' => 'MembershipID'
    ],
    [
        'membershipperson.MembershipID',
        'membershipperson.PersonID',
        'users.IsApproved',
        'person.LastName'
    ],
    [
        'AND' => [
            'membershipperson.MembershipID' => $memberID,
            //'IsApproved' => "1" //this filter the result only if approved (1) /* WHY IS THIS BLOCKED? IsApproved' => "1" */
        ]
    ]);

//return the data as json encoded data
echo json_encode($data);

?>