The POST request was successful, but the data was saved in the wrong way

I tried sending a POST request to the endpoint and received a 200 response, but the data I sent was incorrectly saved in the database;

I would like to know if the problem is with my post request or with the backend code that handles the request.

More specifically: I'm sending a POST request to the Laravel MariaDB backend. I didn't write the backend code, all the "details" I got were:

The post request has 3 fields:

user_id: patient ID

Password: patient password (same for all patients)

payload: A json payload with the following structure:

'epoch_start' => 'Required|Number',

'epoch_end' => 'required|numeric|gte:epoch_start',

'Size' => 'Required|Number|gt:0',

'Temperature' => 'Required|Array|Minimum: size',

'Pressure' => 'Required|Array|Minimum: size',

'Move' => 'Required|Array|Minimum: size',

This is the controller that handles the request:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Validator;
use Response;
use App\Models\User;
use App\Models\Sensor;
use Carbon\Carbon;

class SensorController extends Controller
{
    public function storeData(Request $request) {
        if ($request->has(['user_id', 'password', 'payload'])) {
            $password = $request->get('password');
            $user_id = $request->get('user_id');

            $user = User::where('id', $user_id)->firstOrFail();
            if($user->role != "patient") return new Response('Forbidden', 403);
            if($password != "HIDDENPASS") return new Response('Forbidden', 403);


            $payload = $request->get('payload');
            $data = json_decode($payload, true);

            $rules = [
                'epoch_start' => 'required|numeric',
                'epoch_end' => 'required|numeric|gte:epoch_start',
                'size' => 'required|numeric|gt:0',
                'temperature' => 'required|array|min:size',
                'pressure' => 'required|array|min:size',
                'movement' => 'required|array|min:size',
                'temperature.*' => 'numeric',
                'pressure.*' => 'numeric',
                'movement.*' => 'numeric',
            ];

            $validator = Validator::make($data, $rules);

            if ($validator->passes()) {
                $s = new Sensor;
                $s->user_id = $user->id;
                $s->epoch_start = Carbon::parse($data["epoch_start"]);
                $s->epoch_end = Carbon::parse($data["epoch_end"]);
                $s->size = $data["size"];
                $s->temperature = json_encode($data["temperature"]);
                $s->pressure = json_encode($data["pressure"]);
                $s->movement = json_encode($data["movement"]);
                $s->save();
                response()->json(['success' => 'success'], 200);
            } else {
                dd($validator->errors());
            }

        } else {
            return new Response('Forbidden', 403);
        }  
    }
}

如果我使用 Postman 尝试此 Post 请求（我也尝试使用curl 和 python 的请求模块），我会收到 200 响应，并且数据以这种方式保存到数据库中。

问题出在“温度”、“压力”和“运动”字段上，更具体地说，是数组周围的双引号：由网络应用程序进行的涉及此数据的计算都是错误的，但是，如果我手动删除双引号（来自 PhpMyAdmin）计算是正确的。

为了完整起见，这里是表结构。

有没有办法避免这些字段周围出现双引号？

我的 POST 请求是否有问题，或者是后端相关的问题？

我不熟悉 PHP，但如果我没有记错的话，这些数据的处理应该由这些行管理：

$s->temperature = json_encode($data["temperature"]);
$s->pressure = json_encode($data["pressure"]);
$s->movement = json_encode($data["movement"]);

And json_encode returns a string, so I'm starting to think there's something wrong with the backend code here, but I'd like a second opinion.

Thanks in advance

Edit: Ok, thanks to @samuel-olufemi's answer and @sumit's comment, I can conclude that json_encode combined with the long text data type used by MariaDB is the main problem. So I tried to store the array values without encoding them, changed these 3 lines to:

$s->temperature = $data["temperature"];
$s->pressure = $data["pressure"];
$s->movement = $data["movement"];

And according to my wish, the data is stored without double quotes. Thanks for everyone's help and time.

P粉317679342261 days ago361

The POST request was successful, but the data was saved in the wrong way

reply all(1)I'll reply