コード例 #1
0
<?php

header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Headers: X-Requested-With, Content-Type');
require_once 'config.inc.php';
include 'TokenArray.php';
$con = new PDO($CONFIG['dbConn'], $CONFIG['dbUser'], $CONFIG['dbPasswd']);
$con->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$userid = filter_input(INPUT_SERVER, $CONFIG['userid']);
$pagesize = filter_input(INPUT_GET, '_pagesize');
$offset = filter_input(INPUT_GET, '_offset');
$documentid = filter_input(INPUT_GET, '_docid');
$tokenid = filter_input(INPUT_GET, 'token_id');
$tokenF = filter_input(INPUT_GET, 'token');
$ta = new TokenArray($con);
if ($tokenid) {
    $ta->setTokenIdFilter($tokenid);
}
if ($tokenF) {
    $ta->setTokenValueFilter($tokenF);
}
$propQuery = $con->prepare('SELECT name FROM properties WHERE document_id = ?');
$propQuery->execute(array($documentid));
while ($prop = $propQuery->fetch(PDO::FETCH_COLUMN)) {
    $value = (string) filter_input(INPUT_GET, str_replace(' ', '_', $prop));
    if ($value !== '') {
        $ta->addFilter($prop, $value);
    }
}
$json = $ta->generateJSON($documentid, $userid, $pagesize, $offset);
header('Content-Type: application/json');
コード例 #2
0
ファイル: interface.php プロジェクト: acdh-oeaw/tokeneditor
require_once 'src/utils/ClassLoader.php';
new utils\ClassLoader();
require_once 'config.inc.php';
$PDO = new \PDO($CONFIG['dbConn'], $CONFIG['dbUser'], $CONFIG['dbPasswd']);
$PDO->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
// dirty hack for local testing
if (filter_input(INPUT_SERVER, $CONFIG['userid']) === null) {
    $_SERVER[$CONFIG['userid']] = '*****@*****.**';
}
if (filter_input(INPUT_SERVER, 'REQUEST_METHOD') === 'GET') {
    $docId = filter_input(INPUT_GET, 'document_id');
    $tokenId = filter_input(INPUT_GET, 'token_id');
    if ($docId != '' && $tokenId !== null) {
        // GET TOKENS LIST
        include 'TokenArray.php';
        $tokenArray = new TokenArray($PDO);
        $userId = filter_input(INPUT_SERVER, $CONFIG['userid']);
        $pagesize = filter_input(INPUT_GET, '_pagesize');
        $offset = filter_input(INPUT_GET, '_offset');
        $tokenId = filter_input(INPUT_GET, 'token_id');
        $tokenF = filter_input(INPUT_GET, 'token');
        if ($tokenId) {
            $tokenArray->setTokenIdFilter($tokenId);
        }
        if ($tokenF) {
            $tokenArray->setTokenValueFilter($tokenF);
        }
        $propQuery = $PDO->prepare('SELECT name FROM properties WHERE document_id = ?');
        $propQuery->execute(array($docId));
        while ($prop = $propQuery->fetch(PDO::FETCH_COLUMN)) {
            $value = (string) filter_input(INPUT_GET, str_replace(' ', '_', $prop));