php convert integer primary key (id) to string

Question

i want to convert id to string in my sql query result.

i want to response json with string id ...

i tried convert(id, char) and cast(id as char) in select but problem remains ...

example:

{
  "status": 1,
  "message": "Success",
  "nexturl": "http://domain.dev/feed/298",
  "data": [
    {
      "id": 123456789,
      "userid": 12,
    }
  ]
}

i want to get this result:

{
  "status": 1,
  "message": "Success",
  "nexturl": "http://domain.dev/feed/298",
  "data": [
    {
      "id": "123456789",
      "userid": "12",
    }
  ]
}

Dont build your own JSON Strings. Use json_encode($an array or an object); to do it. Then it will be correct. Yours probably wont be most of the time. A few minutes now and again with the manual can save you hours of pain And here is the manual — RiggsFolly
– RiggsFolly, Commented Sep 29, 2016 at 14:49
Possible duplicate of stackoverflow.com/questions/35650306/… See Change the type of existing columns. — ndm
– ndm, Commented Sep 29, 2016 at 18:07

mostafaznv · Accepted Answer · 2016-10-01 12:44:07Z

0

i found the answer

we can convert columns in entity class...

so i created an entity for users table and i converted the primary key (id) in entity.

namespace App\Model\Entity;

use Cake\ORM\Entity;

class User extends Entity
{
    protected $_accessible = [
       '*' => true,
    ];

    protected function _getId($id){
        return (string) $this->_properties['id'];
    }
}

answered Oct 1, 2016 at 12:44

mostafaznv

99215 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A J · Accepted Answer · 2016-09-30 04:35:58Z

-2

CONVERT(id, CHAR(50)) as id is the correct syntax.

edited Sep 30, 2016 at 4:35

A J

4,01214 gold badges40 silver badges55 bronze badges

answered Sep 29, 2016 at 14:48

jimmy8ball

7566 silver badges16 bronze badges

1 Comment

tadman Over a year ago

This is better done within PHP. It's utterly pointless to do it in the query since there's an additional layer involved anyway.

Collectives™ on Stack Overflow

php convert integer primary key (id) to string

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related