Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Format model results before send to client

i am building project restful api with phalcon micro! So any way format result before send to client ?

Example My category table with column

    id => int (auto increment)
    name => varchar 256
    status => int 11
    sort_order => int 11

in my code

    $result = Model:findFirst(1);
    $response->json($result->toArray());

but in client id , status and sort_order is string type

i am ask for best way format in model after query .



2.3k
Accepted
answer
edited Oct '18

You have to enable following PDO options when connection to your database:

'options' => [
\PDO::ATTR_EMULATE_PREPARES => false,
\PDO::ATTR_STRINGIFY_FETCHES => false,
],

This allows Phalcon (i.e. PDO) to convert numeric values to INT