我开始使用silex开发一个rest api。这是我的第一个api!
我所做的:
更新:代码随着费德里奇的提示而改进。添加Use Symfony JsonResponse。暂时不起作用。
<?php
require_once __DIR__.'/vendor/autoload.php';
use Symfony'Component'HttpFoundation'JsonResponse;
// init Silex app
$app = new Silex'Application();
$app['debug'] = true;
//configure database connection
$app->register(new Silex'Provider'DoctrineServiceProvider(), array(
'db.options' => array(
'driver' => 'pdo_mysql',
'host' => '127.0.0.1',
'dbname' => 'db',
'user' => 'root',
'password' => '',
'charset' => 'utf8',
),
));
$app->get('/apps', function () use ($app){
$sql = "select apps.id, apps.guid, apps.title, clients.client, countries.country, langs.lang, apps.active from apps
inner join countries on apps.id_country = countries.id
inner join clients on clients.id = apps.id_client
inner join langs on langs.id = apps.id_lang
order by apps.created_at desc";
$results = $app['db']->fetchAll($sql);
$response['status'] = array(
'code' => 200,
'message' => 'OK'
);
$response['data'] = $results;
//return $app->json($response);
$jsonResponse = new JsonResponse($response);
$jsonResponse->setEncodingOptions(JsonReponse::DEFAULT_ENCODING_OPTIONS | JSON_PRETTY_PRINT);
return $jsonResponse;
});
$app->run();
它的回报是什么?
{"status":{"code":200,"message":"OK"},"data":[{"id":"2","guid":"a8559e9b-d850-4964-b672-335a87fe9e8b","title":"Coverdine Plus Light","client":"Servier","country":"England","lang":"English","active":"1"},{"id":"1","guid":"4f242e9d-c041-4c79-bc82-b62604de403c","title":"Coverdine","client":"Servier","country":"England","lang":"English","active":"0"}]}
如何使用JSON_PRETTY_PRINT
来改进json对象的人工读取?
不要使用$app->json($response);
,而是使用JsonResponse
。您可以使用他的setEncodingOptions
方法设置JSON_PRETTY_PRINT
标志。
<?php
use Symfony'Component'HttpFoundation'JsonResponse;
// ...
$jsonResponse = new JsonResponse($response);
$jsonResponse->setEncodingOptions(JsonResponse::DEFAULT_ENCODING_OPTIONS | JSON_PRETTY_PRINT);
return $jsonResponse;
这对我有效:
...
require_once(__DIR__ .'/../vendor/autoload.php');
use Symfony'Component'HttpFoundation'Response;
...
$response = $sth->fetchALL(PDO::FETCH_ASSOC);
return $app->json($response, Response::HTTP_OK)->setEncodingOptions(JSON_PRETTY_PRINT);
我也遇到过这种困难,经过大量研究,我发现了函数do_dump,点击此处在github中查看它。
要使用它,只需这样做:
$var = json_decode('{"a":1,"b":2,"c":3,"d":4,"e":5}');
do_dump($var);