ethar

i create new route file admin.php

Route::group(['prefix' => 'admin', 'middleware' => 'auth:admin', 'namespace' => 'Admin'], function () {
    Route::get('/dashboard', '[email protected]');
});

in route service provider i activate $namespace and add route file to middleware, and activate namespace

    protected $namespace = 'App\Http\Controllers';
    public function boot()
    {
        $ this->configureRateLimiting();
            Route::middleware('admin')
                ->namespace($this->namespace)
                ->group(base_path('routes/admin.php'));
        });
    }

but when visit /admin/dashboard i got this error

include(/Library/WebServer/Documents/pos/vendor/composer/../../app/Http/Admin/DashboardController.php): failed to open stream: No such file or directory

Note: DashboardController.php inside app/Http/Controllers/Admin/DashboardController.php

i have chapters table, student take exams ,

in student_exams i store ('id','chapter_id','mark','user_id')

I want to list all chapters and marks of last taken exam related to chapter.

i try this code

            $chapter = Chapter::select('id', 'title_ar')
                ->with(['studentExams' => function ($q) {
                    $q->select('chapter_id', 'mark')
                        ->where('student_id', Auth::user()->id)
                        ->orderby('id', 'DESC')
                        ->first();
                }])->get();

but it returns the last exam is taken, not the last exam in the selected chapter.

after uploading the database to the server, all relations have been removed,

in localhost its exist, how to solve this problem, I cant run migrate:fresh because the site owner already has insert data to the database to I cant rerun migration.

any idea to solve this problem

i have this values come from form

"explainanswer": {
"53": "yes php framework ",
"54": "not javascript ",
"55": "not security",
"56": "not forensics "
},
"answer": {
"53": "php framework",
"54": "javascript",
"55": "security",
"56": "forensics"
},

i have table answers with this fields

`id`,`answer`, `explain_answer`,

how can update this fields depend on id , id come from table as above 53,54,55,56

i try this code but not work

        foreach ($request->answer as $key=>$val){
            $answer=Answer::findOrFail($key);
            $answer->answer = $request->answer[$key];
            $answer->explain_answer = $request->explainanswer[$key];
            $answer->save();
        }

<input  type="text" name="question[1]" />
	<textarea name="answer[1]"></textarea>
	<textarea name="answer[1]"></textarea>

<input  type="text" name="question[2]" />
	<textarea name="answer[2]"></textarea>
	<textarea name="answer[2]"></textarea>

in controller when print request->answer

the result is

{
	"1": "aaaa",
	"2": "bbbbb"
}

its give me last value of answer[1] and last value of answer[2],

how can get all value related to answer[$i]

i try to use

        foreach ($request->answer as $v){
            echo $v;
        }

but also not working

how can hilight code in website,

how laracasts use github-flavored code blocks,

how can add this feature in my website

in mcamara documentation use this code to show all active language

@foreach(LaravelLocalization::getSupportedLocales() as $localeCode => $properties)
    <li>
        <a rel="alternate" hreflang="{{ $localeCode }}"
            href="{{ LaravelLocalization::getLocalizedURL($localeCode, null, [], true) }}">
            {{ $properties['native'] }}
        </a>
    </li>
@endforeach

but its show all website language,

I want to show only not an active language, active language must not be shown

ex if site language (en, sp, fr)

and the user now in en lang must show just(sp,fr)

@siangboon i remove all pervious steps, and add prefix, but not working,

i moved public file inside demo folder, but also not working

i want to move laravel project from

www.abc.com

to

www.abc.com/demo/

i changed baseurl tag

   <base href="https://abc.com/demo/" />

i changed

APP_URL=https://abc.ps/demo/

i changed index.php pathes

require __DIR__.'../../../lcode/vendor/autoload.php';
$app = require_once __DIR__.'../../../lcode/bootstrap/app.php';
$app->bind('path.public', function() {
    return __DIR__;
});

index open successfully

but

images,css,js not working

links not working,

plz how do that

@ismaile let me explain

I used the admin route for the control panel /admin/dashboard /admin/login

I create an admin.php file inside the routes folder used for the admin panel route, all admin route(admin panel) not in web.php but in admin.php I created.

I used a dedicated table for admins, not a user's table.

admins have a login page,different from users page users have a specific login page. admins have a specific login page.

now the problem solved after your help and after the change

   public function handle($request, Closure $next,$guards=null)
    {
        if (Auth::guard($guards)->check()) {
            if($guards == 'admin')
                return redirect(RouteServiceProvider::ADMIN);
            else
                return redirect(RouteServiceProvider::HOME);
        }
        return $next($request);
    }

@ismaile after change

    public function handle($request, Closure $next, ...$guards)
    {
        $guards = empty($guards) ? [null] : $guards;
        if (Auth::guard($guards)->check()) {
            if($guards == 'admin')
                return redirect(RouteServiceProvider::ADMIN);
            else
                return redirect(RouteServiceProvider::HOME);
        }
        return $next($request);
    }

to

    public function handle($request, Closure $next,$guards=null)
    {
        if (Auth::guard($guards)->check()) {
            if($guards == 'admin')
                return redirect(RouteServiceProvider::ADMIN);
            else
                return redirect(RouteServiceProvider::HOME);
        }
        return $next($request);
    }

problem solved

but i dont think this is best idea

thanks @ismaile im sorry for late

my auth.php // i add admin guards and providers
    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],

        'api' => [
            'driver' => 'token',
            'provider' => 'users',
            'hash' => false,
        ],

        'admin' => [
            'driver' => 'session',
            'provider' => 'admin',
        ],

    ],

    'providers' => [
        'users' => [
            'driver' => 'eloquent',
            'model' => App\Models\User::class,
        ],

        'admin' => [
            'driver' => 'eloquent',
            'model' => App\Models\Admins::class,
        ],

in redirectifauthenticated.php

    public function handle($request, Closure $next, ...$guards)
    {
        $guards = empty($guards) ? [null] : $guards;
        if (Auth::guard($guards)->check()) {
            if($guards == 'admin')
                return redirect(RouteServiceProvider::ADMIN);
            else
                return redirect(RouteServiceProvider::HOME);
        }
        return $next($request);
    }

in routeserviceprovider.php

    public const HOME = '/home';
    public const ADMIN = '/admin/dashboard';
    protected $namespace='App\Http\Controllers';

    public function boot()
    {
        $this->configureRateLimiting();

        $this->routes(function () {
            Route::middleware('web')
                ->namespace($this->namespace)
                ->group(base_path('routes/web.php'));

            Route::middleware('admin')
                ->namespace($this->namespace)
                ->group(base_path('routes/admin.php'));

            Route::prefix('api')
                ->namespace($this->namespace)
                ->middleware('api')
                ->group(base_path('routes/api.php'));
        });
    }

admin.php //new route file

Route::group(['prefix'=>'admin','middleware'=>'guest:admin','namespace'=>'Admin'],function(){
    Route::get('/login','[email protected]')->name('admin.login');
    Route::post('/login','[email protected]')->name('admin.login');
});

new error ErrorException Illegal offset type

thanxs @ismaile

But i got this error

InvalidArgumentException Auth driver [eloquent] for guard [admin] is not defined.

I want to create a new route file for admins.

in routeServiceProvider.php file

i create this new route inside boot function

    public function boot()
    {
        $this->configureRateLimiting();

        $this->routes(function () {
            Route::middleware('web')
                ->namespace($this->namespace)
                ->group(base_path('routes/web.php'));

            Route::middleware('admin')
                ->namespace($this->namespace)
                ->group(base_path('routes/admin.php'));

            Route::prefix('api')
                ->namespace($this->namespace)
                ->middleware('api')
                ->group(base_path('routes/api.php'));
        });
    }

this code i add

            Route::middleware('admin')
                ->namespace($this->namespace)
                ->group(base_path('routes/admin.php'));

in routes folder i create admin.php for routing

but i got this error

Illuminate\Contracts\Container\BindingResolutionException Target class [admin] does not exist.

not see new route file admin.php

im working on an e-learning website. I want to ask if can protect videos from downloading by the student,

how can protect videos from download

@automica thanks for your idea, some modification in code

i add in return

$value->is_correct === 1
$value->is_correct === 2
$value->is_correct === 3

full code

            $numCorrect = $answeredQuestion->filter(function ($value) {
                return $value->is_correct === 1;
            })->count();

i have this data in answers table

is_marked	is_correct 
	
0 	                2

0 	                2

1 			1

1			1

0			0

1			1

I want to calculate the sum of is marked must return 3.

I want to calculate the sum of is_correct if value =1 //must return 3

I want to calculate the sum of is_correct if value =0 // must return 1

I want to calculate the sum of is_correct if value =2 // must return 2

plz what is the best way without making 4 select statement

@michaloravec but user may can mark questions, to back to it later, so i must save it to db

i have 2 table

1- answers (`id`, `answer`)

2- student_answers (`id`, `student_id`, `answer_id`)

answer_id in table student_answers is forign_key on id in answers table

when the user select answer, I store answer id in student_answer, but some time user skip question so I sent 0 to answers_id in student_answer, so because 0 does not exist in answers, I got this error

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails

how can solve this problem

@rmcleod79

when the user log in another time to question, it must begin from the last solved question.

what the best query, get all solved( which (is_correct,is_marked)) from student_question

then all unsolved question from the question table

not stored, aha i will store it

@automica what if user skip some question (answer 1, answer 1, skip 3, answer 4)

@automica thx

but not this what i want,

I want from student_question table get all solved question and determine if is_correct, is_marked,

then from questionTable get all unsolved question

i have 2 table

questions('id','question_txt','correct_answer');
student_question('id','question_id','student_id','answer_id','is_marked','is_correct')

a student may solve all question or not,

when the user log in another time to question, it must begin from the last solved question.

what the best query, get all solved( which (is_correct,is_marked)) from student_question

then all unsolved question from the question table

@s4muel my character set is utf8mb4_unicode_ci

i have this insert statement

        try {
            $units = [];
            foreach ($request->title_ar as $key => $title_ar) {
                $units[] = [
                    'course_id' => $request->course,
                    'title_ar' => $request->title_ar[$key],
                    'title_en' => $request->title_en[$key],
                    'about_ar' => $request->about_ar[$key],
                    'about_en' => $request->about_en[$key],
                    'active' => $request->active,
                    'admin_id' => Auth::id()
                ];
            }

            if (! empty($units)) {
                DB::table('units')->insert($units);
                return redirect('/admin/units')->with('success','تم إضافة الوحدات بنجاح');
            }
        }catch (\Exception $e){
            return $e;
        }

but when insert arabic text in field about_ar[$key] i got this error

error :PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xD8' for column 'about_ar'

i have this values 3,4,5,6

to get numbers i used explode
@foreach(explode(',',session()->get('question')['flag_question']) as $flag)
	{{$flag}}
@endforeach

but how can i get count in blade

@automica it's not working its add id twice for example, if id = 4, will add 44 if the next id is 7 will replace 44 by 77

I want 4,7

hi, I have RadioButton with class .answer_question, i want when click on this radio to append value to input hidden with id #correct_question like value="1,2,3,4"

<input type="text" id="correct_question" value="">

var vl = $(this).val();//radio value

correctAnswersArray = correctAnswersArray.includes(vl) ? correctAnswersArray.filter(id => id != vl) : [...correctAnswersArray, vl];

$('#correct_question').val(correctAnswersArray.join(','));

but what happens now. is replace new id not append .

@automica thanks

i have many div with class .questionFollow , i want if .questionFollow Class == id as bellow to addClass text-danger to this class

 $(document).delegate('#MarkQuestion', 'click', function () {
        var id = $(this).attr('data-id');
        var element = $('.questionFollow');
	var classId = element.attr('id');

// if classId equal id ADD .text-danger to thie element

    });

any help

in StudentCourse Model table (Pivot Table) i store('active_courses_id','student_id'),

In ActiveCourse i store (id,course_id)

in below query, I want to get all courses not registred to the user ($id),

I use two query, first to get activeCourse that user enrolls on it, then other query go get courses user did not enroll on it depend on the first query.

$userCourse=StudentCourseModel::select('active_courses_id')
   ->where('student_id',$id)
   ->get();
$courses = ActiveCourse::select('id', 'course_id')
   ->with('course:id,title_ar')
   ->where('active', 1)
   ->whereNotIn('id',$userCourse)
   ->get();

i want to ask if any way to use one query instead of two query

yes i have this relatio

public function studentCourse(){
        return $this->belongsTo('App\ActiveCourse','active_courses_id','id');
    }

returned data from eloquent

        $studentCourse = StudentCourseModel::select('active_courses_id')
            ->with(['studentCourse' => function ($q) {
                return $q->select('id','course_id')->with('course:id,title_ar,img');
            }])
            ->where('student_id', $id)
            ->get();

@snapey this is returned data

[
  {
    "active_courses_id": 3,
    "student_course": [
      {
        "id": 3,
        "course_id": 4,
        "course": {
          "id": 4,
          "title_ar": "PHP"
        }
      }
    ]
  },
  {
    "active_courses_id": 4,
    "student_course": [
      {
        "id": 4,
        "course_id": 5,
        "course": {
          "id": 5,
          "title_ar": "e-commerce"
        }
      }
    ]
  }
]

@marianomoreyra 1- first way give me this error

Call to a member function first() on null (View:

2- second way give me this error

Trying to get property 'course' of non-object (View:

thanks, @tykus course have data, as you see in first screen above,

but when print it in blade i got error,

when use

{{ optional($courses->student_course)->course ? $courses->student_course->course->title_ar : '' }}

there is no error, but also no data printed in blade

i try to print this result in blade using foreach

[
    {
        "active_courses_id": 3,
        "student_course": [
            {
                "id": 3,
                "course_id": 4,
                "course": {
                    "id": 4,
                    "title_ar": "Flutter Course",
                    "img": "[email protected]_7.png"
                }
            }
        ]
    },
    {
        "active_courses_id": 4,
        "student_course": [
            {
                "id": 4,
                "course_id": 5,
                "course": {
                    "id": 5,
                    "title_ar": "E-Commerce Course",
                    "img": "[email protected]_4.png"
                }
            }
        ]
    }
]

in blade

@foreach($studentCourse as $courses)
       <h6>{{ $courses->student_course->course->title_ar }}</h6>
@endforeach

but i got an error

ErrorException

Trying to get property 'course' of non-object (View:

This is my final code its works fine.

but I'm not sure if its good or need improve

    public function store(Request $request)
    {
        $question = new Question();
        $question->question=$request->input('question');
        $question->course_id=$request->input('course');
        $question->active=$request->input('active');
        $question->admin_id=Auth::user()->id;
        $question->save();
        $units = [];

        for ($i=0;$i<count($request->answer);$i++){
            $units[] = [
                'question_id' => $question->id,
                'answer' => $request->answer[$i],
            ];
        }

        if (! empty($units)) {

            for($i=0;$i<count($units);$i++){
                $lastId= DB::table('answers')->insertGetId($units[$i]);
            }
            $correct_answer = $lastId-count($units)+$request->correctanswer;
            $question->correct_answer=$correct_answer;
            $question->save();
            return redirect('/admin/question')->with('success','تم إضافة السؤال بنجاح');
        }
    }

in html

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="1">
	<textarea name="answer[]" required></textarea>
</div>

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="2">
	<textarea name="answer[]" required></textarea>
</div>

1- insert question.

2- insert answers and questionid.

3- calculate which answer is the correct answer

4-update question table to take best answer id

@sinnbeck thanks for your hints, really helpful.

@sinnbeck

            $student_course=new StudentCourseModel();
            $student_course->active_courses_id=$request->input('course_id');
            $student_course->student_id=$request->input('student_id');
            $student_course->save();

yes i have active_courses row with id 4

active_courses table

        Schema::create('active_courses', function (Blueprint $table) {
            $table->bigIncrements('id')->unsigned()->index();
            $table->integer('course_id')->unsigned()->index();
            $table->date('begin_date')->nullable();
            $table->date('end_date')->nullable();
            $table->foreign('course_id')->references('id')->on('courses');
        });

Student table

        Schema::create('students', function (Blueprint $table) {
            $table->bigIncrements('id')->unsigned()->index();
            $table->string("name",40);
            $table->string("email",40)->index()->unique();
        });

in student_course (pivot table) i want to store student with his courses. student_course

        Schema::create('student_course', function (Blueprint $table) {
            $table->bigInteger('active_courses_id')->unsigned();
            $table->bigInteger('student_id')->unsigned();
            $table->foreign('active_courses_id')->references('id')->on('active_courses')->onDelete('cascade');
            $table->foreign('student_id')->references('id')->on('students')->onDelete('cascade');
        });

migration is fine (No Problem on migration), but when inserting data to student_course I got this error

message: "SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (ikhlaif.student_course, CONSTRAINT student_course_active_course_id_foreign FOREIGN KEY (active_course_id) REFERENCES active_courses (id) ON DELETE CASCADE) (SQL: insert into student_course (active_course_id, student_id) values (4, 47))"

This is my final code its works fine.

but I'm not sure if its good or need improve

    public function store(Request $request)
    {
        $question = new Question();
        $question->question=$request->input('question');
        $question->course_id=$request->input('course');
        $question->active=$request->input('active');
        $question->admin_id=Auth::user()->id;
        $question->save();
        $units = [];

        for ($i=0;$i<count($request->answer);$i++){
            $units[] = [
                'question_id' => $question->id,
                'answer' => $request->answer[$i],
            ];
        }

        if (! empty($units)) {

            for($i=0;$i<count($units);$i++){
                $lastId= DB::table('answers')->insertGetId($units[$i]);
            }
            $correct_answer = $lastId-count($units)+$request->correctanswer;
            $question->correct_answer=$correct_answer;
            $question->save();
            return redirect('/admin/question')->with('success','تم إضافة السؤال بنجاح');
        }
    }

in html

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="1">
	<textarea name="answer[]" required></textarea>
</div>

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="2">
	<textarea name="answer[]" required></textarea>
</div>

1- insert question.

2- insert answers and questionid.

3- calculate which answer is the correct answer

4-update question table to take best answer id

i try to insert this form into db

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="0">
	<textarea name="answer[]" required></textarea>
</div>

<div>
	<input class="form-check-input" name="correctanswer" type="radio" value="0">
	<textarea name="answer[]" required></textarea>
</div>

eloquent

        $units = [];
        foreach ($request->answer as $key => $answer) {
            $units[] = [
                'question_id' => $question->id,
                'answer' => $request->answer[$key],
                'correct_answer' => $request->correctanswer[$key],
            ];
        }

        if (! empty($units)) {
            DB::table('answers')->insert($units);
            return redirect('/admin/question')->with('success','تم إضافة السؤال بنجاح');
        }

radio button checked must insert value 1, not checked insert zero. using jquery i changed radio button selected to 1;

but in Eloquent i got this error ErrorException Uninitialized string offset: 1

plz any help to insert (answers and correct answer insert value to 1)

@sinnbeck @michaloravec Thanks very much

@michaloravec worked but little modify cause $course not array

    public function store(request $request)
    {
        $units = [];

        foreach ($request->title_ar as $key => $title_ar) {
            $units[] = [
                'courses_id' => $request->course,
                'title_ar' => $request->title_ar[$key],
                'title_en' => $request->title_en[$key],
                'admins_id' => Auth::id()
            ];
        }

        if (! empty($units)) {
            DB::table('units')->insert($units);
            return redirect('/admin/units')->with('success','تم إضافة الوحدات بنجاح');
        }
    }

i try to insert array value to database , there is no error but data not inserted html

<tr>
    <td>Units Name Fr<span class="required text-danger">*</span></td>
    <td><input type="text" name="title_fr[]" required class="form-control"/></td>
</tr>
<tr>
    <td>Units Name En<span class="required text-danger">*</span></td>
    <td class="entd"><input type="text" name="title_en[]" required class="form-control"/></td>
</tr>

Controller

    public function store(Request $request)
    {
        try {
            $unit=new Units();
            $units = [];
            for ($i = 1; $i < count($request->title_fr); $i++) {
                $units[] = [
                    'courses_id' => $request->course[$i],
                    'title_ar' => $request->title_fr[$i],
                    'title_en' => $request->title_en[$i],
                    'admins_id' => Auth::user()->id,
                ];
            }
            $unit->insert($units);
            return redirect('/admin/units')->with('success','Unit Add Successfully');
        }catch (\Exception $e){
            return $e;
        }
    }

to getTopOs For Example

    public function fetchTopOs(Period $period, int $maxResults = 10): Collection
    {
        $response = $this->performQuery(
            $period,
            'ga:sessions',
            [
                'dimensions' => 'ga:operatingSystem',
                'sort' => '-ga:sessions',
            ]
        );

        $topOs = collect($response['rows'] ?? [])->map(function (array $osRow) {
            return [
                'operatingSystem' => $osRow[0],
                'sessions' => (int) $osRow[1],
            ];
        });

        if ($topOs->count() <= $maxResults) {
            return $topOs;
        }

        return $this->summarizeTopOS($topOs, $maxResults);
    }

@sinnbeck TypeError Argument 1 passed to Symfony\Component\HttpFoundation\Response::setContent() must be of the type string or null, object given, called in /home4/panorax1/lcode/vendor/laravel/framework/src/Illuminate/Http/Response.php on line 65

@sinnbeck for example

        $analyticsData = Analytics::performQuery(
            Period::years(1),
            'ga:sessions',
            [
                'metrics' => 'ga:sessions, ga:pageviews',
                'dimensions' => 'ga:yearMonth'
            ]
        );
        return $analyticsData;

but i got error

this is the first time I used spatie/google analytics packages to get website visitors

https://github.com/spatie/laravel-analytics

its provide some function, but I want more than that like: 1- total active now and visited pages. 2- country and number of user fore each country.

any help

thanks @sinnbeck