我在尝试从JSON文件获取数据时遇到了麻烦。我的JAVA端正在工作,但是在组装JSON的PHP中进行了更改,因为我无法执行解析器,因此我不知道在PHP中知道我正在获取的JSON格式,但是我可以访问代码。JSON挂载的页面是这样的:
<?php
$startTime = microtime(true);
include_once("../utils/config.php");
include_once("../utils/utils.php");
include_once("../services/rest.utils.php");
header("Content-Type: application/json",true);
$from = getADate('from', true);
$to = getADate('to', false);
$fromDate = '';
$toDate = '';
if ($from <> '') { $fromDate = $from; }
if ($to <> 'NULL') { $toDate = $to; }
$body = file_get_contents('php://input');
if (signatureCheck($body)) {
$cta = 0;
$database = conectaDatabase();
$script = '';
$pfx = Config::getPrefixo();
$sql = "SELECT RelatorioID, ProfessorID, AlunoID, TurmaID,
Bimestre, Data, TipoRelatorio, Conteudo, Situacao FROM {$pfx}Relatorios
WHERE Data >= $fromDate";
if ($toDate <> '') {
$sql .= " AND Data < $toDate";
}
$qry = $database->query($sql);
$lista = array();
$cta = 0;
while ($row = $qry->fetchObject()) {
$row->TipoRelatorio = utf8_encode($row->TipoRelatorio);
$row->Conteudo = utf8_encode($row->Conteudo);
$lista[] = $row;
$cta++;
}
@$output->response = new StdClass(); // Anonymous object, remove the warning
$output->response->descricao = "$cta relatórios importados";
$output->response->status = 200;
$output->relatorios = $lista;
$endTime = microtime(true);
$timeSpent = $endTime - $startTime;
$output->response->timeSpent = $timeSpent;
$saida = json_encode($output, JSON_UNESCAPED_UNICODE);
echo $saida;
desconectaDB($database);
}
HUWWW