jinsonjose

jinsonjose

Member Since 7 Months Ago

Experience Points
28,070
Total
Experience

1,930 experience to go until the next level!

In case you were wondering, you earn Laracasts experience when you:

  • Complete a lesson — 100pts
  • Create a forum thread — 50pts
  • Reply to a thread — 10pts
  • Leave a reply that is liked — 50pts
  • Receive a "Best Reply" award — 500pts
Lessons Completed
271
Lessons
Completed
Best Reply Awards
0
Best Reply
Awards
  • start-engines Created with Sketch.

    Start Your Engines

    Earned once you have completed your first Laracasts lesson.

  • first-thousand Created with Sketch.

    First Thousand

    Earned once you have earned your first 1000 experience points.

  • 1-year Created with Sketch.

    One Year Member

    Earned when you have been with Laracasts for 1 year.

  • 2-years Created with Sketch.

    Two Year Member

    Earned when you have been with Laracasts for 2 years.

  • 3-years Created with Sketch.

    Three Year Member

    Earned when you have been with Laracasts for 3 years.

  • 4-years Created with Sketch.

    Four Year Member

    Earned when you have been with Laracasts for 4 years.

  • 5-years Created with Sketch.

    Five Year Member

    Earned when you have been with Laracasts for 5 years.

  • school-session Created with Sketch.

    School In Session

    Earned when at least one Laracasts series has been fully completed.

  • welcome-newcomer Created with Sketch.

    Welcome To The Community

    Earned after your first post on the Laracasts forum.

  • full-time-student Created with Sketch.

    Full Time Learner

    Earned once 100 Laracasts lessons have been completed.

  • pay-it-forward Created with Sketch.

    Pay It Forward

    Earned once you receive your first "Best Reply" award on the Laracasts forum.

  • subscriber-token Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer-token Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • lara-evanghelist Created with Sketch.

    Laracasts Evangelist

    Earned if you share a link to Laracasts on social media. Please email [email protected] with your username and post URL to be awarded this badge.

  • chatty-cathy Created with Sketch.

    Chatty Cathy

    Earned once you have achieved 500 forum replies.

  • lara-veteran Created with Sketch.

    Laracasts Veteran

    Earned once your experience points passes 100,000.

  • 10k-strong Created with Sketch.

    Ten Thousand Strong

    Earned once your experience points hits 10,000.

  • lara-master Created with Sketch.

    Laracasts Master

    Earned once 1000 Laracasts lessons have been completed.

  • laracasts-tutor Created with Sketch.

    Laracasts Tutor

    Earned once your "Best Reply" award count is 100 or more.

  • laracasts-sensei Created with Sketch.

    Laracasts Sensei

    Earned once your experience points passes 1 million.

  • top-50 Created with Sketch.

    Top 50

    Earned once your experience points ranks in the top 50 of all Laracasts users.

Level 6
28,070 XP
Feb
17
2 days ago
Activity icon

Replied to FPDF Package For Laravel

@sinnbeck

  1. codedge/laravel-fpdf
  2. crabbly/fpdf-laravel
  3. anouar/fpdf

so that the reason why i ask here

Activity icon

Started a new Conversation FPDF Package For Laravel

in laravel i want to use FPDF i use laravel 6 which package can be used in FPDF

Feb
13
6 days ago
Activity icon

Started a new Conversation How To Get Latitude And Longitude Based On Address (without Using Googleapi)

i used nominatim but the problem is gives [] https://nominatim.openstreetmap.org/?format=json&addressdetails=1&q={Studio%20103,The%20Business%20Centre,61%20Wellfield%20Road,Roath,Cardiff,CF24%203DG}&format=json&limit=1

this will give lat and long

https://nominatim.openstreetmap.org/?format=json&addressdetails=1&q={Studio%20103,61%20Wellfield%20Road,Roath,Cardiff,CF24%203DG}&format=json&limit=1

the output: [ { "place_id": 182054265, "licence": "Data © OpenStreetMap contributors, ODbL 1.0. https://osm.org/copyright", "osm_type": "way", "osm_id": 419550100, "boundingbox": [ "51.493995", "51.4958426", "-3.1661591", "-3.1650575" ], "lat": "51.4948835", "lon": "-3.1656815", "display_name": "Wellfield Road, Roath, Cardiff, Wales, CF, United Kingdom", "class": "highway", "type": "tertiary", "importance": 0.5199999999999999, "address": { "road": "Wellfield Road", "suburb": "Roath", "city": "Cardiff", "county": "Cardiff", "state": "Wales", "postcode": "CF", "country": "United Kingdom", "country_code": "gb" } }

the problem is given address is not formatted how to resolve this issue?? can you help??

Feb
12
1 week ago
Activity icon

Started a new Conversation SQLSTATE[23000]: Integrity Constraint Violation: 1052 Column 'name' In Where Clause Is Ambiguous

how to solve this errror query below sort and search have this occure this error

public function index()
{
    $search  = request('search_text');
    if ($search != NULL ) {
        // check any search word match 
        $users = User::where('name', 'LIKE', '%' . $search . '%')
                    ->orWhere('user_name', 'LIKE', '%' . $search . '%')
                    ->orWhere('email', 'LIKE', '%' . $search . '%')
                    // check roles (belongs relation to roles table) name in roles table
                    ->orWhereHas('roles', function (Builder $query) use($search) {
                        $query->where('name', 'LIKE', '%' . $search . '%');
                    })
                    // check base_types (belongs relation to base_types table) name in base_types table
                    ->orWhereHas('base_types', function (Builder $query) use($search) {
                        $query->where('name', 'LIKE', '%' . $search . '%');
                    })
                    ->sortable('name')
                    ->paginate(15);
                    
    } else {
        $users = User::sortable('name')->paginate(15);
    }
    return view('admin.users.index',compact('users', 'search'));
}

error message

Illuminate\Database\QueryException SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'name' in where clause is ambiguous (SQL: select count(*) as aggregate from users left join base_types on users.base_type = base_types.id where (name LIKE %uk% or user_name LIKE %uk% or email LIKE %uk% or exists (select * from roles where users.role_id = roles.id and name LIKE %uk%) or exists (select * from base_types where users.base_type = base_types.id and name LIKE %uk%)) and users.deleted_at is null)

                                <th>@sortablelink('name', 'Name')</th>
                                <th>@sortablelink('user_name', 'User Name')</th>
                                <th>@sortablelink('email', 'Email')</th>
                                <th>@sortablelink('roles.name', 'Role')</th>
                                <th>@sortablelink('base_types.name', 'Base Type')</th>
                                <th>@sortablelink('status', 'Status')</th>
                                <th>@sortablelink('updated_at', 'Modified')</th>
                                <th>@sortablelink('', 'Actions')</th>

in model relation

/**
 * get role name from Role Table
 * based on role_id
 */
public function roles()
{
    return $this->belongsTo('App\Role','role_id');
}

/**
 * get base type name from BaseType Table
 * based on base_type
 */
public function base_types()
{
    return $this->belongsTo('App\BaseType','base_type');
}
Feb
10
1 week ago
Activity icon

Started a new Conversation Column Sorting In Laravel Paginate On Table

how to sort table column with the laravel paginate

in controller fetch data with paginate()

$council = Sector::where('sector_type',3)->orderBy('id', 'desc')->paginate(15);

in blade

                    <table  class="table table-bordered table-striped" style="border: 1px solid #dee2e6;">
                        <thead>
                            <tr>
                                <th>Name</th>
                                <th>Address</th>
                                <th>Town</th>
                                <th>Base Type</th>
                                <th>Status</th>
                                <th style="width:13%;">Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            @if(!$council->isEmpty())
                            @foreach($council as $councils)
                            <tr>
                                <td> {{ $councils->name }} </td>
                                <td>
                                    {{ $councils->address1 }}
                                </td>
                                <td>{{ $councils->town }}</td>
                                <td>{{ $councils->baseType->name }}  </td>
                                <td> 
                                </td>
                                <td>
                                </td>
                            </tr>
                            @endforeach
                            @else
                            <td colspan="6"> No data available in table</td>
                            @endif
                        </tbody>
                    </table>

{!! $council->appends(\Request::except('page'))->render() !!}

how to apply sort on this table in laravel 6 nb : please avoid datatable technique i want to use normal table

Feb
05
2 weeks ago
Activity icon

Replied to Search With In A Where Condition On Laravel

thanks for your quick replay

little updation

passing also use($search) in function

        $search  = request('search_text');
        $council = Sector::where('sector_type', 3)
                         ->where(function($query) use($search) {
                            $query->where('name', 'LIKE', '%' . $search . '%')
                                ->orWhere('address1', 'LIKE', '%' . $search . '%')
                                ->orWhere('address2', 'LIKE', '%' . $search . '%')
                                ->orWhere('address3', 'LIKE', '%' . $search . '%')
                                ->orWhere('job_title', 'LIKE', '%' . $search . '%')
                                ->orWhere('town', 'LIKE', '%' . $search . '%');
                        })
                        ->paginate(15);
Activity icon

Started a new Conversation Search With In A Where Condition On Laravel

in my table "sector" , one filed name is sector_type its values are1,2,3,4, etc....... i want to search string where sector_type=3 only how to write query in laravel search on fields name,address1,address2,address3,jobtitle,town

purpose : serach the text only in sector_type = 3 but below query return all results where sector_type = 3 how to solve this issue? can you help?

    $search  = request('search_text');
        $council = Sector::where('sector_type', 3)
                        ->orWhere('name', 'LIKE', '%' . $search . '%')
                        ->orWhere('address1', 'LIKE', '%' . $search . '%')
                        ->orWhere('address2', 'LIKE', '%' . $search . '%')
                        ->orWhere('address3', 'LIKE', '%' . $search . '%')
                        ->orWhere('job_title', 'LIKE', '%' . $search . '%')
                        ->orWhere('town', 'LIKE', '%' . $search . '%')
                        ->paginate(15);
Dec
30
1 month ago
Activity icon

Replied to Laravel Roles And Permission

thanks dude for the replay,

actually first time i using spatie that why i take an opinion about to use the package actually i didnt find any disadvantages! i know in this community , so many using this so that reason i ask an opinion about spatie

thanks for your replay

Activity icon

Started a new Conversation Laravel Roles And Permission

in laravel 6 which one is the best way for managing roles and permission can you suggest me the best way? in my search i found that spatie if i use this package any dis advantages can you suggest me the better way for doing this?