如何在 Laravel 中获取字符串中的所有列值

Question

如何在 laravel 查询中获取字符串中的所有列值，我的查询是，

$profile = DB::table('app_user')->where([

      'email' => $request->email,

      'password' => md5($request->password),

      'app_id' => $request->app_id

  ])->select('id as app_user_id','id','name','email','user_image','activate')

    ->first();

这个返回对象

 "app_user_id": 2857687,

 "id": 2857687,

 "name": "zahid"

我想这样输出

"app_user_id": "2857687",

"id": "2857687",

"name": "zahid"

我正在使用 laravel 5.4

请帮助提前谢谢

Answer 1

你可以像这样转换 MySQL 数据。$profile = DB::table('app_user')->where([      'email' => $request->email,      'password' => md5($request->password),      'app_id' => $request->app_id  ])->select(DB::raw('CAST(id AS varchar) as app_user_id, CAST(id as varchar) as id, name, email, user_image, activate'))    ->first()

Answer 2

使用mysql CAST函数转换为无符号整数$profile = DB::table('app_user')->where([      'email' => $request->email,      'password' => md5($request->password),      'app_id' => $request->app_id  ])->select(\DB::raw('CAST(id AS UNSIGNED) as app_user_id'),\DB::raw('CAST(id AS UNSIGNED) as id'),'name','email','user_image','activate')    ->first();

Answer 3

您可以在 mysql 查询中将整数转换为字符串，如下所示：.. ->selectRaw('CAST(id as CHAR(50)) as app_user_id', 'name', ...) ->first();