dongzai5181 2018-03-22 14:08
浏览 318
已采纳

可能编码错误,格式错误的UTF-8字符

I am trying to fetch the records in laravel then it will give me following error.

Malformed UTF-8 characters, possibly incorrectly encoded

This is my code

$Login = DB::table('usermaster')

        ->where('Email', $uname)

        ->where('Password', md5($password))

        ->get();

    return response()->json($Login);
  • 写回答

1条回答 默认 最新

  • doukesou4452 2018-03-23 13:35
    关注

    In my laravel query i am use a following code so it will give a this type of error...

    Malformed UTF-8 characters, possibly incorrectly encoded

    $BvoData = DB::table('test1')->select('test1.*')
            ->where("test1.Id", "".$id."")
            ->first();
    
    $BvoData->temp1 = DB::table('temp1')->where('tmpdata', $BvoData->tmpdata)->get(); 
    
    $BvoData->temp2 = DB::table('temp2')->where('Id', $id)->get();
    
    return response()->json($BvoData);
    

    but i will solve this error by doing following code...

    $BvoData = DB::table('test1')->select('test1.*')
            ->where("test1.Id", "".$id."")
            ->first();
    
    $BvoData = (array)  $BvoData;
    
    $BvoData->temp1 = DB::table('temp1')->where('tmpdata', $BvoData->tmpdata)->get(); 
    
    $BvoData["temp1"] = json_decode(json_encode($BvoData["temp1"]), True);
    
    
    $BvoData->temp2 = DB::table('temp2')->where('Id', $id)->get();
    
    $BvoData["temp2"] = json_decode(json_encode($BvoData["temp2"]), True);
    
    return response()->json($BvoData);
    

    by using json_decode and json_encode i solve my problem...

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 uniapp的websocket和c++的websocket服务器通讯 发送的数据和接受的数据表现形式不一样
  • ¥15 pyspark配置中的错误
  • ¥15 html word表格
  • ¥15 kali安装包如何解决,请给明确方案和步骤
  • ¥15 DEA软件进行企业创新效率的计算
  • ¥15 树莓派驱动42步进电机
  • ¥20 bevfusion mit可视化遇到的问题
  • ¥15 如何获得《人工智能工程技术人员》认证?
  • ¥100 悬赏破解EFS加密,速度
  • ¥30 用MATLAB画随t变化的函数图像,式中包含了累加求和,出现报错,不知道怎么办了,请解释一下