itrabbi24

itrabbi24

Software Engineer at SCS

Member Since 1 Month Ago

Experience Points
420
Total
Experience

4,580 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
0
Lessons
Completed
Best Reply Awards
0
Best Reply
Awards
  • start your 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-in-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 Created with Sketch.

    Subscriber

    Earned if you are a paying Laracasts subscriber.

  • lifer Created with Sketch.

    Lifer

    Earned if you have a lifetime subscription to Laracasts.

  • evangelist 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 1
420 XP
May
28
1 day ago
Activity icon

Replied to Laravel Database Connection

@flor this is 5 year old.

Activity icon

Started a new Conversation Laravel Database Connection

How to laravel database connection on Microsoft SQL Server please tell me.

May
24
5 days ago
Activity icon

Replied to Get Total Number Of Row In Table

@michaloravec Done Working............. Thank you

Activity icon

Replied to Get Total Number Of Row In Table

@michaloravec

error message show

SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause (SQL: SELECT *,count(*) as count FROM `tms_tables` WHERE `outgoing_date` = '2020-05-24' )

Activity icon

Replied to Get Total Number Of Row In Table

@michaloravec

I use that qurey builder whear i use ? please tell me

controller

$date_piker = $data['date_piker'] = $request->date_piker;

$userDetalis = DB::select(DB::raw("SELECT * FROM `tms_tables WHERE `outgoing_date` = '$date_piker' "));

return view('tms-report.local_dally_outgoing', compact('userDetalis'));

blade.php files are hear

            @foreach($userDetalis as $row)

            @php $number++; @endphp
            <tr>  
              <th scope="row">{{ $number }}</th>
              
              <td>{{$row->tmsid}}</td>
              <td>{{$row->dest_1}}</td>
              <td>{{$row->vehicle_number}}</td>
              <td>{{$row->driver_name}}</td>
              <td>{{$row->helper_name}}</td>
              <td>{{$row->driver_number}}</td>
              <td>{{$row->loading_spv_name}}</td>
            </tr>```
Activity icon

Replied to Get Total Number Of Row In Table

@michaloravec

I have a table and I want to show after search total table row

Activity icon

Started a new Conversation Get Total Number Of Row In Table

How to get from the table of the total number of rows in laravel?

in raw PHP we are using

mysqli_num_rows

but in laravel please tell me what I use?

May
23
6 days ago
Activity icon

Started a new Conversation Search With Date Picker And Show Result

How I create a simple data search page with a date picker in laravel, I found some package but I cannot use those packages please help me. Database MYSQL From QureyBuilder

Activity icon

Replied to Laravel LIKE Qurey Dynamic Variable Problem

yes... thank you so much

Activity icon

Started a new Conversation Laravel Qurey Dynamic Variable Problem

I get some value from my database.

$auth_dept_code = Auth::user()->dept_code; // 1 $auth_branch_code = Auth::user()->branch_code; //0001 $auth_code = $auth_dept_code.$auth_branch_code ; // 1001

//auth_code is 1001

Now

when I am search

tmsid LIKE '%$auth_code%'

LIKE '%{$auth_code}%'

LIKE '%?%' )", [$auth_code]

this variable auth_code that is not working...... but when I am declared variable is

$auth_code = 1001;

and Query is executed at that time is working... but I need a dynamic variable to search.

why dynamic variables are not working?? Please give me a solution.

please give me a solution.

Here is some screenshot

Not Working

https://imgur.com/a/GRyZHfm

Working type of static value

https://imgur.com/a/iIcV8al

Not Working...

https://imgur.com/a/AhA4GXU

OR

https://imgur.com/a/8g79AYp

same problem

the dynamic variable is not working

$auth_dept_code = Auth::user()->dept_code; 		// 1
$auth_branch_code = Auth::user()->branch_code;	// 0001
$auth_code = intval($auth_dept_code.$auth_branch_code); //1001 




error_reporting( ~E_NOTICE );

$submenus =DB::select(DB::raw("SELECT tmsid, RIGHT(tmsid,6) 
	as max_number FROM tms_tables WHERE tmsid=(SELECT MAX(tmsid) 
	FROM tms_tables where tmsid LIKE '%auth_code%' )"));

@endphp

@foreach($submenus as $row)
@endforeach
@php
  $num = $row->max_number;
    ++$num;
      $len = strlen($num);
          for($i=$len; $i< 6; ++$i) {
        $num = '0'.$num;
      }
@endphp


@php
echo $auth_code; echo '-'; echo $num;
@endphp
Activity icon

Replied to Laravel LIKE Qurey Dynamic Variable Problem

Sir, @michaloravec I also try to echo auth_code value that is ok. but when I pub this variable in my query that time are not working.

Activity icon

Replied to Laravel LIKE Qurey Dynamic Variable Problem

@michaloravec same problem please view my screenshot.

https://imgur.com/a/AhA4GXU

OR

https://imgur.com/a/8g79AYp

same problem

the dynamic variable is not working

Activity icon

Replied to Laravel LIKE Qurey Dynamic Variable Problem

two variables are joined and show result but the dynamic variable value in like a query that is not working Please see this screenshot

Not Working

https://imgur.com/a/GRyZHfm

Working type of static value

https://imgur.com/a/iIcV8al

Activity icon

Started a new Conversation Laravel LIKE Qurey Dynamic Variable Problem

I get some value from my database.

$auth_dept_code = Auth::user()->dept_code; $auth_branch_code = Auth::user()->branch_code; $auth_code = $auth_dept_code.$auth_branch_code ;

//auth_code is 1001

Now

when I am search tmsid LIKE '%$auth_code%'

this variable auth_code that is not working...... but when I am declared variable is

$auth_code = 1001;

and Query is executed at that time is working... but I need a dynamic variable to search.

why dynamic variables are not working?? Please give me a solution.

$submenus =DB::select(DB::raw("SELECT tmsid, RIGHT(tmsid,6) as max_number FROM tms_tables WHERE tmsid=(SELECT MAX(tmsid) FROM tms_tables where tmsid LIKE '%$auth_code%' )"));

please give me a solution.

Activity icon

Replied to Mysql Qurey To Laravel Qurey Like %% Problem

Really Thanks Brother

Activity icon

Started a new Conversation Mysql Qurey To Laravel Qurey Like %% Problem

SELECT tmsid, RIGHT(tmsid,6) as max_number FROM tms_tables WHERE tmsid=(SELECT MAX(tmsid) FROM tms_tables where tmsid LIKE '%1001%' )

How To Convert This to laravel?

if I do like that give me error "A non-numeric value encountered"

DB::select(DB::raw('SELECT tmsid, RIGHT(tmsid,6) as max_number FROM tms_tables WHERE tmsid=(SELECT MAX(tmsid) FROM tms_tables where tmsid LIKE '%1001%' )'));

May
02
3 weeks ago
Activity icon

Replied to Multi Auth With Roles And Permissions

Hello Sir, Can I used the 1st package which is 'laratrust' in laravel 5.8?