elargento23

Did you make this work? I just resolved this yesterday and upload image is working fine on Froala

Solved. The return view was missing compact(): return view ('2ndscreen', compact('question');

Solved. The return view was missing compact(): return view ('2ndscreen', compact('question');

I have the following code:

public function selected_degree ($degree_id) {
    session(['degree_id' => $degree_id]);

    $question = DB::table('questions')
        ->select('questions.question_text','questions.answer_time_minutes','questions.answer_time_seconds', 'question_id')
        ->where('degree_id', session('degree_id'))
        ->orderByRaw('RAND()')
        ->take(1)->first();

    // save the question id returned in an array in session
    Session::push('questions', $question->question_id);
    // save the position as 0 because is the first time the query is run
    Session::put('array_position', 0);

    return view('2ndscreen', 'question');
}

I don't understand why I am getting this error: array_merge(): Expected parameter 1 to be an array, string given.

There are no more details about this error.

I was wondering to know which ways I have to go through an array through previos/next buttons, starting from the latest position of an array.

Finally I was able to resolve this. Laravel was showing $degree_id value as '?' when I was using dd(DB::getQueryLog());

However, this value was passed but not displayed using this function. I thought the query was wrong (displaying ? instead of a number) but it worked anyway.

I'm passing the degree_id through the URL but the query doesn't insert the value. Instead, it returns ?

dd($degree_id') returns 1 The query should return where questions.degree_id = 1 ->where('questions.degree_id', $degree_id)

However, the complete query using dd(DB::getQueryLog()); returns: select questions.question_text, questions.answer_time_minutes, questions.answer_time_seconds from questions inner join universities on universities.university_id = questions.university_id where questions.degree_id = ? order by RAND() limit 1

As you can see, the query returns = ? but it should return = 1

Good suggestion. It has value 1 so it's working but

->where('questions.degree_id', $degree_id)

is returning where questions.degree_id = ?

I'm not sure why

Route::get('/questions/{category}', '[email protected]')->name('welcomesecond');

executes the following:

public function second($degree_id) {
    $question = DB::table('questions')
        ->select('questions.question_text','questions.answer_time_minutes','questions.answer_time_seconds')
        ->join('universities', 'universities.university_id', 'questions.university_id')
        ->orderByRaw('RAND()')
        ->where('questions.degree_id', $degree_id)
        ->take(1)->first();

    return view('2ndscreen', compact('question'));
}

However, even when I pass the value through the URL, $degree_id has no value assigned: URL: questions/1

Any ideas what I am doing wrong?

The 2nd returns Trying to get property 'question_text' of non-object

The 1st one returns the query :)

the query logs returns an empty array:

[]

    $question = DB::table('questions')
        ->select('questions.question_text','questions.answer_time_minutes','questions.answer_time_seconds')
        ->join('universities', 'universities.university_id', 'questions.university_id')
        ->orderByRaw('RAND()')
        ->where('questions.degree_id', $degree_id)
        ->take(1)->first();

    DB::enableQueryLog();
    dd(DB::getQueryLog());

I just inserted it at the end:

    $question = DB::table('questions')
        ->select('questions.question_text','questions.answer_time_minutes','questions.answer_time_seconds')
        ->join('universities', 'universities.university_id', 'questions.university_id')
        ->orderByRaw('RAND()')
        ->where('questions.degree_id', $degree_id)
        ->take(1)->first()
        ->toSql ();

->toSql (); returns Call to a member function toSql() on null

I have the following function: public function second($degree_id) {

    $question = DB::table('questions')
        ->select('questions.question_text','questions.answer_time_minutes','questions.answer_time_seconds')
        ->join('universities', 'universities.university_id', 'questions.university_id')
        ->orderByRaw('RAND()')
        ->where('questions.degree_id', $degree_id)
        ->take(1)->first();

    return view('2ndscreen', compact('question'));
}

This query it is supposed to:

• Get some columns from question table (question_text, questions.answer_time_minutes and questions.answer_time_seconds)
• Match university_id columns from questions and universities tables
• Random order
• Show the questions whose questions.degree_id is equal to the value passed through the function.

Is there any way to see this query in raw format so I can find out what's wrong?

Thank you

but a new random question must be loaded from the database so I must load the index function again. Javascript and AJAX won't be able to send and receive data from the controller

I have a controller which loads a random question:

public function index () {
    $question = Question::orderByRaw('RAND()')->take(1)->get();

    return view('welcome', compact('question'));
}

Inside the view, there is a foreach which displays the random question:

                                    <div class="block-content">
                                        @foreach($question as $q)
                                        <h2 class="font-w400">{{$q->question_text}}</h2>@endforeach</div>

So, I want to insert a button on the view to get a new random question without having to reload the page (because in the future I want to add some filters through Radiobuttons and such so send certain parameters to the controller and get random questions based on certain criteria).

Now you know the situation, which is the best approach? Should I create a secondary view to load the foreach as a section and then reload the section only?

Where do you change varchar to 150? I can't find the type of column on migrations folder