PHP DBHandler::retrieveLeadByRaceBibNumber примеры использования

Пример #1

Файл: get-finisher-details.php Проект: somidex/tnf1002016

<?php

require_once '../../../src/Database/DBHandler.php';
if ($_POST) {
    $db = new DBHandler();
    $db->connect();
    $key = $db->retrieveLeadByRaceBibNumber($_POST['racebib']);
    if ($key) {
        if ($key['finish_time'] && $key['finish_time'] != 'DNF/R') {
            /*if ($key['race_category'] == '22KM') {
            			echo json_encode(-3);
            			exit;
            		} else {
            			$details = array(
            				'name' => $key['fname'].' '.$key['mi'].' '.$key['lname'],
            				'racebib' => $key['race_bib_number'],
            				'finish' => $key['finish_time'],
            				'raceCat' => $key['race_category']
            			);
            			echo json_encode($details);
            			exit;
            		}*/
            $details = array('name' => $key['fname'] . ' ' . $key['mi'] . ' ' . $key['lname'], 'racebib' => $key['race_bib_number'], 'finish' => $key['finish_time'], 'raceCat' => $key['race_category']);
            echo json_encode($details);
            exit;
        } else {
            /*$details = array(
            			'name' => $key['fname'].' '.$key['mi'].' '.$key['lname']
            		);*/
            echo json_encode(-1);
            exit;