使用Silex框架开发一个rest api


Develop a rest api using Silex framework

我开始使用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);