How to store json data/result into mysql with laravel?

There is a json column type in migrations. You can use it for storing json data.

can you tell me how can i total the value? and pass it to table. Does it have to go through a controller? or there is any other way.

You might consider viewing some of Jefferies free video training.

depending on how you will retrieve them. if you want them totally you may store them in one column, but if you want them with some relational operations then you may store them in multiple columns.

yeah.. i understand that but i was asking how can i total the result?

@hafiz_r

Could not you give us more detailed description of what you want to get? Step by step? There are lots of ways to work with data. Each of them have pros and cons. And the best one can be chosen only by your goal.

as you can see from the code. 7 questions gives 7 result as number and 4 result depending on that number. So i want to store the sum of that 7 numeric result/any one of the 4 html result in one column of Authorised user. So how can i do it? or i can do it by passing the value to the controller of the mode that i want to store it to. Thanks

Do you want to process your questionnaire on frontend or backend?

Do you want to store only result (e.g. user have Answers array [0,0,1,0,3,0,2], Sum integer 6 and Result string "<h1>Mild Anxiety</h1>". You want to store just Sum and Result string, right?

yes. Martal . Exactly

It already shows the result in front end. I just want to store it in database of the user when it generates the result.

Thanks

@hafiz_r

So the simplest way is to add result_sum and result_text columns to User model, and make post request on finishing the questionnaire to store the data.

How good are you with Laravel and backend? Do you need detailed guide? Have you watched any Jeffrey's videos?

I understand a bit. As far i could do from documentation. Didn't face major problem in storing and retreiving yet. I just don't know which variable stores the result text and if i need to use form or button url to store it. Thanks.

@hafiz_r

Do you want to use JS post request or regular browser form?

anything suitable. As it will update each time the user take the questionnaire. Is js post request suitable?

So your questionnaire is available only for authenticated users, not for guests? And your user can pass this questionnaire many times, right? Do you want to store only one result per user or all of them to see statistics in time?

Available only to auth user. One result per user.

So a user can update questionnaire and you want to store only the last result?

yes @martal

Ok, give me half an hour I'll try to describe your controller and blades.

routes/web.php

Route::group(['middleware' => 'auth'], function () {
    Route::get('questionnaire', 'QuestionnaireController@show');
    Route::match(
        ['put',' patch'],
        'questionnaire',
        'QuestionnaireController@update'
    );
});

app/Http/Controllers/QuestionnaireController.php

<?php

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;

class QuestionnaireController extends Controller
{
    /**
     * Display the specified resource.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request)
    {
        $user = $request->user();

        return view('questionnaire', compact('user'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request)
    {
        $user = $request->user();

        $user->update($request->only([
            'quest_result_sum', 'quest_result_text'
        ]));

        return view('questionnaire', compact('user'));
    }
}

users migration schema

Schema::create('users', function (Blueprint $table) {
    $table->bigIncrements('id');
    $table->string('name');
    $table->string('email')->unique();
    $table->timestamp('email_verified_at')->nullable();
    $table->string('password');
    $table->rememberToken();
    $table->timestamps();

    $table->integer('quest_result_sum')->nullable();
    $table->string('quest_result_text')->nullable();
});

blades is on the way (=

resources/questionnaire.blade.php, patch request part

var xmlhttp = new XMLHttpRequest();
xmlhttp.open("PATCH", "/questionnaire");
xmlhttp.setRequestHeader("Content-Type", "application/json");
xmlhttp.send(JSON.stringify({quest_result_sum:3, quest_result_text:"<h1>SomeText</h1>"}));

I assume that you can make frontend of your questionnaire. (Actually I am rather bad in frontend. (= )

request part i didn't undersatnd. The variable you gave is predefined right? eg.quest_result_text

web.php

oute::group(['middleware' => 'auth:student'], function () {
    Route::view('/student', 'student');
    Route::get('student/profile', ['uses' => 'ProfilesController@indexStudent', 'as' => 'student.profile']);
    Route::post('student/profile/update', ['uses' => 'ProfilesController@updateStudent', 'as' => 'student.profile.update']);
    Route::resource('appointments', 'AppointmentsController');
    Route::get('/createAppointment', 'AppointmentsController@create');
    Route::get('/chat', 'ChatController@index')->name('chat');
    Route::post('pusher/auth', function () {
        return auth()->user();
    });
    Route::match(
        ['put', ' patch'],
        'student',
        'ProfilesController@updateD'
    );
});

ProfilesController.php

 public function updateD(Request $request, User $user)
    {
        $user = $request->user();

        $user->update($request->only([
            'quest_result_text'
        ]));

        return view('student', compact('user'));
    }

student.blade.php (survey included in modal)

 <div class="modal-body">
                @include('inc.anxietySurvey')
            </div>
            {{-- <div class="modal-footer" >
        <button type="button" class="btn btn-secondary" data-dismiss="modal" >Close</button>

Database

 $table->integer('contact')->nullable();
            $table->string('about')->nullable();
            $table->string('avatar')->default('default.jpg');
            $table->string('depression')->nullable();
            $table->string('anxiety')->nullable();

I assumed that you have you questionnaire made with js. User choses his answers, clicks button (e.g. "Finish"), after that you intercept an onclick button event and send data in handler.

@hafiz_r

Sorry, no User $user argument should be in your updateD controller function. I have made an error. Only Request $request argument should be there.

That's the problem @martal as i gave you the code of survey above. It's a js library called survey js. So i don't have an onclick in the code. I guess it's in the linked js file. This is the whole code of my survey file which is depressionSurvey.blade.php

<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="https://unpkg.com/jquery"></script>
<script src="https://surveyjs.azureedge.net/1.1.8/survey.jquery.js"></script>
<link href="https://surveyjs.azureedge.net/1.1.8/survey.css" type="text/css" rel="stylesheet" />



<div id="surveyElement"></div>
<div id="surveyResult"></div>

@hafiz_r

In step 5 there is a sendDataToServer callback. Send data in it.

function sendDataToServer(survey) {
  // var resultAsString = JSON.stringify(survey.data);
  var quest_result_sum =  3;//take data from survey var
  var quest_result_text = "<h1>SomeText</h1>";//take data from survey var
  var xmlhttp = new XMLHttpRequest();
  xmlhttp.open("PATCH", "/questionnaire");
  xmlhttp.setRequestHeader("Content-Type", "application/json");
  xmlhttp.send(JSON.stringify({quest_result_sum:quest_result_sum, quest_result_text:quest_result_text}));
}

hey @martal

window.survey = new Survey.Model(json);
    survey.onComplete.add(function (result) {
        document.querySelector('#surveyResult').textContent = "Result JSON:\n" + JSON.stringify(result.data,
            null, 3);
    });
    $("#surveyElement").Survey({
        model: survey,
        onComplete: sendDataToServer
    });

    function sendDataToServer(survey) {
        // var resultAsString = JSON.stringify(survey.data);
        var quest_result_sum = 3; //take data from survey var
        var quest_result_text = result.data; //take data from survey var
        var xmlhttp = new XMLHttpRequest();
        xmlhttp.open("PATCH", "/student");
        xmlhttp.setRequestHeader("Content-Type", "application/json");
        xmlhttp.send(JSON.stringify({
            quest_result_sum: quest_result_sum,
            quest_result_text: quest_result_text
        }));

i tired to store the the result.data in result_text. It's not working and how can i set the result_text to the html text below

var json = {
        "title": "Depression Questionnaire",
        "description": "Over the last 2 weeks, how often have you been bothered by any of the following problem?\n\n",
        "completedHtmlOnCondition": [{
            "expression": "({question1}+{question2}+{question3}+{question4}+{question5}+{question6}+{question7}+{question8}+{question9}<=4",
            "html": "<h1>Minimal Depression<h1> "

@hafiz_r

Please, show what is in survey.data in sendDataToServer function.

I have tried this :(

function sendDataToServer(survey) {
        // var resultAsString = JSON.stringify(survey.data);
        var quest_result_sum = 3; //take data from survey var
        var quest_result_text = JSON.stringify(survey.data) //take data from survey var
        var xmlhttp = new XMLHttpRequest();
        xmlhttp.open("PATCH", "/student");
        xmlhttp.setRequestHeader("Content-Type", "application/json");
        xmlhttp.send(JSON.stringify({
            quest_result_sum: quest_result_sum,
            quest_result_text: quest_result_text
        }));

@hafiz_r

I cannot see you monitor so I cannot know what is the error. Is it 404 error? Misprint in controller? Mysql error? What kind of error do you have? What works and what not?