예제 #1
0
 static function showerror($code, $message)
 {
     $result = array('result' => 'fail', 'data' => array());
     $result['error']['code'] = $code;
     $result['error']['message'] = 'Error ' . $code . ': ' . $message;
     APIHelpers::endpage($result);
     exit;
 }
예제 #2
0
파일: count.php 프로젝트: azizjonm/fhq
include_once $curdir_events_count . "/../../config/config.php";
$response = APIHelpers::startpage($config);
$conn = APIHelpers::createConnection($config);
if (!APIHelpers::issetParam('id')) {
    APIHelpers::showerror(1225, 'Not found parameter "id"');
}
$type = APIHelpers::getParam('type', '');
$id = APIHelpers::getParam('id', 0);
if (!is_numeric($id)) {
    APIHelpers::showerror(1226, 'id must be integer');
}
try {
    $params = array();
    $params[] = $id;
    $query = 'SELECT count(*) as cnt FROM public_events WHERE id > ?';
    if ($type != '') {
        $query .= ' AND type = ?';
        $params[] = $type;
    }
    $stmt = $conn->prepare($query);
    $stmt->execute($params);
    if ($row = $stmt->fetch()) {
        $count = $row['cnt'];
        $response['data']['count'] = $count;
        $response['result'] = 'ok';
    }
} catch (PDOException $e) {
    APIHelpers::showerror(1227, $e->getMessage());
}
APIHelpers::endpage($response);