On the relationships for both `User` and `Target`, tack on a `-&gt;withPivot(&#39;type&#39;)` which will instruct Laravel to include that column. Then once you have your result set, you can access the field with `$user-&gt;pivot-&gt;type`.

If you&#39;re not iterating over a collection, but have a user and one of their targets and want the `type` field, you could use `$target = $user-&gt;targets-&gt;find($targetId)` and access the type with `$target-&gt;pivot-&gt;type`.

More at http://laravel.com/docs/4.2/eloquent#working-with-pivot-tables

You can also limit columns by passing array as 2nd arg to simplePaginate

```
$query-&gt;users()-&gt;simplePaginate($per_page, [&#39;users.id&#39;, &#39;users.email&#39;]);
```

What is the difference between a shim an a sham?

Is it enough to include es5-shim.min.js and es6-shim.min.js or should I also include es5-sham.min.js and es6-sham.min.js?

Shim vs. Sham: What is the difference?

I can&#39;t seem to be able to create an Android Wear notification that updates with out blinking the app icon whereas the same code works fine on an Android phone.

Most referenced solutions talk about updating the same notification, use *setAlertOnlyOnce*, keeping the *ID* or *when* the same. However, whatever I do, every time the notification is updated it blinks (most noted by the App Icon).

As suggested here https://stackoverflow.com/questions/25499834/android-wear-timer-like-notification-card-on-wear-device you can use *setHintHideIcon(true)* to hide the app icon, which hides the blinking part, however in the limited world of Android Wear Notifications the app icon plays a large part in the branding of the application.

If you want a timer, you can use *.setUsesChronometer(true)* and let the system update the timer which works perfectly. Unfortunately if you want to update something else than time (like steps or messages received count) it seems to me you&#39;re out of luck.

Below you can find code that works fine when run as a phone app, but blinks when run as a wearable app.

Commented line below to demonstrate that the notification still blinks (when running on wear, not the phone) that the notification still blinks when posting an unchanged notification on the wearable. Uncomment to update the notification again.

    mNotification = buildNotification(WearMainActivity.this);


Therefore my question is if anyone has any further idea&#39;s we can explore to keep the notification from blinking or if we can write this down as an Android Wear bug?


    public class WearMainActivity extends Activity {

        public final int NOTIFICATION_ID= 1;
        public Notification mNotification;
        public int count;
        public long when;

        @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            count = 0;
            when = System.currentTimeMillis();
            mNotification = buildNotification(WearMainActivity.this);
            postDelayedHandler();
            finish();
        }

        private void postDelayedHandler(){

            new Handler().postDelayed(new Runnable() {
                public void run() {
                    count++;
                    mNotification = buildNotification(WearMainActivity.this);
                    NotificationManager notifyMgr = ((NotificationManager) getSystemService(NOTIFICATION_SERVICE));
                    notifyMgr.notify(NOTIFICATION_ID, mNotification);
                    postDelayedHandler();
                }
            }, 1000L);
        }

        private Notification buildNotification(Context context){
            return new Notification.Builder(context)
                    .setSmallIcon(R.drawable.ic_launcher)
                    .setContentTitle(context.getString(R.string.app_name))
                    .setContentText(&quot;Count: &quot;+count)
                    .setWhen(when)
    //                .setOngoing(true) //Don&#39;t do this, adds &quot;Mute app&quot; action
                    .setOnlyAlertOnce(true)
                    .setPriority(Notification.PRIORITY_MAX)
                    .extend(new Notification.WearableExtender()
    //                        .setHintHideIcon(true) //Hides the icon, so kinda hides the blink
                    )
                    .build();
        }
    }

Tested on:&lt;br/&gt;
Wearable: Moto 360 (4.4W2) Wear Emulator (5.0.1)&lt;br/&gt;
Phones: Galaxy Nexus (4.3) and Nexus 5 (5.0.0)

Occurs: When running as a Wearable app or as phone notification displayed on Wearable. Works perfect on phone.

Referenced questions:&lt;br/&gt;
https://stackoverflow.com/questions/19025056/how-can-i-avoid-blinking-notification-update-while-changing-button&lt;br/&gt;
https://stackoverflow.com/questions/6406730/updating-an-ongoing-notification-quietly&lt;br/&gt;
https://stackoverflow.com/questions/11512986/how-to-properly-update-a-notification-post-api-11

Android Wear notification prevent blinking icon when updating

My `User` model has many `Target` and vice versa.
Now I&#39;ve got a given `User` and given `Target` and I want to access pivot data from their relation. The pivot column is called `type`

How can I achieve this?

Laravel: Get pivot data for specific many to many relation

<p>My <code>User</code> model has many <code>Target</code> and vice versa.
Now I've got a given <code>User</code> and given <code>Target</code> and I want to access pivot data from their relation. The pivot column is called <code>type</code></p>
<p>How can I achieve this?</p>


I am adding a field to a table in a migration that I wish to allow to be NULL but also I wish for it to default to NULL. What do I place in the default method? I fear that putting `&quot;NULL&quot;` in will attempt to place a string of `NULL`in which I obviously don&#39;t want. Please help :)

    Schema::table(&#39;item_categories&#39;, function(Blueprint $table)
	{
		$table-&gt;integer(&#39;parent_item_category_id&#39;)-&gt;unsigned()-&gt;nullable()-&gt;default($what_to_put here);
	});

Set default to NULL with laravel migration

I am trying to learn how to test with phpunit and laravel. When start the test using `phpunit` command, I am getting a warning :

    There was 1 failure:
    
    1) Warning
    No tests found in class &quot;PostsTest&quot;.
                                         
    FAILURES!                            
    Tests: 2, Assertions: 1, Failures: 

My test classname and filename matches. I have read other problems about unmatching names. my filename is `PostsTest.php` and my test file :


    class PostsTest extends ApiTester {
    
    	
    	public function it_fetches_posts()
    
    	{
    		$this-&gt;times(5)-&gt;makePost();
    
    		$this-&gt;getJson(&#39;api/v1/posts&#39;);
    
    		$this-&gt;assertResponseOk();
    
    	}
    
    	private function makePost($postFields=[])
    	{
    		$post = array_merge([
    			&#39;title&#39; =&gt; $this-&gt;fake-&gt;sentence,
    			&#39;content&#39; =&gt; $this-&gt;fake-&gt;paragragraph
    		], $postFields);
    
    		while($this-&gt;times --)Post::create($post);
    	}
    }
if necessary my ApiTester :

    use Faker\Factory as Faker;
    
    class ApiTester extends TestCase {
    	protected $fake;
    	protected $times = 1;
    	function __construct($faker)
    	{
    		$this-&gt;fake = Faker::create();
    	}
    }

I dont have any clue where the error is. Laravel or my local phpunit settings or anything else. Any helps is appreciated.

Thanks.

Phpunit tests gives warning no tests found in class

I have the following Rule : 



    &#39;Fno&#39; =&gt; &#39;digits:10&#39;
    &#39;Lno&#39; =&gt; &#39;min:2|max5&#39;  // this seems invalid



But How to have the Rule that 

Fno Should be a Digit with Minimum 2 Digit to Maximum 5 Digit and

Lno Should be a Digit only with Min 2 Digit

Laravel Rule Validation for Numbers

I&#39;m trying to view the log for a query, but `DB::getQueryLog()` is just returning an empty array:
     
    $user = User::find(5);
    print_r(DB::getQueryLog());

**Result**

    Array
    (
    )

How can I view the log for this query?

How to Get the Query Executed in Laravel 5? DB::getQueryLog() Returning Empty Array

I&#39;m rendering a page that is primarily a form with `view::make` in Laravel and it is crashing, causing ERR_CONNECTION_RESET. After a long investigation and many red herrings, I started erasing (not commenting) random sections out of the blade file for the view and realized that if I 

a) erase 2 of the `{{Form}}` calls inside this section of the form 

b) remove the `{{-- and --}}` from around this section of the form

        {{--
        &lt;div class=&quot;form-row&quot;&gt;
          {{ Form::label(&#39;foo&#39;, &#39;foo:&#39;) }}
          {{ Form::text(&#39;foo&#39;) }}
        &lt;/div&gt;
        &lt;div class=&quot;form-row&quot;&gt;
          {{ Form::label(&#39;foo&#39;, &#39;foo:&#39;) }}
          {{ Form::text(&#39;foo&#39;) }}
        &lt;/div&gt;
        &lt;div class=&quot;form-row&quot;&gt;
          {{ Form::label(&#39;foo&#39;, &#39;foo&#39;) }}
          {{ Form::text(&#39;foo&#39;) }}
        &lt;/div&gt;
        --}}

the page will render. I am not sure what exactly the cause here is. There are other blocks above and below, although this is a 3-div commented out section which none of the others are.

Anyone have a clue what is causing this? Running on WAMP if that matters.

Laravel - Blade comments , blade rendering causing page to crash

I&#39;m developing a web API with Laravel 5.0 but I&#39;m not sure about a specific query I&#39;m trying to build.

My classes are as follows:

    
    class Event extends Model {
    
    	protected $table = &#39;events&#39;;
    	public $timestamps = false;
    
    	public function participants()
        {
            return $this-&gt;hasMany(&#39;App\Participant&#39;, &#39;IDEvent&#39;, &#39;ID&#39;);
        }
        
    	public function owner()
    	{
    		return $this-&gt;hasOne(&#39;App\User&#39;, &#39;ID&#39;, &#39;IDOwner&#39;);
    	}
    }

and


    class Participant extends Model {
    
    	protected $table = &#39;participants&#39;;
    	public $timestamps = false;
    
    	public function user()
        {
            return $this-&gt;belongTo(&#39;App\User&#39;, &#39;IDUser&#39;, &#39;ID&#39;);
        }
        
        public function event()
        {
        	return $this-&gt;belongTo(&#39;App\Event&#39;, &#39;IDEvent&#39;, &#39;ID&#39;);
        }
    }


Now, I want to get all the events with a specific participant.
I tried with:

    Event::with(&#39;participants&#39;)-&gt;where(&#39;IDUser&#39;, 1)-&gt;get();

but the `where` condition is applied on the `Event` and not on its `Participants`. The following gives me an exception:

    Participant::where(&#39;IDUser&#39;, 1)-&gt;event()-&gt;get();

I know that I can write this:

    $list = Participant::where(&#39;IDUser&#39;, 1)-&gt;get();
    for($item in $list) {
       $event = $item-&gt;event;
       // ... other code ...
    }

but it doesn&#39;t seem very efficient to send so many queries to the server.

What is the best way to perform a `where` through a model relationship using Laravel 5 and Eloquent?

Laravel where on relationship object

I&#39;ve found the concept and meaning behind these methods to be a little confusing, is it possible for somebody to explain to me what the difference between `has` and `with` is, in the context of an example (if possible)?

Content Type	Original Author	Original Content on Stackoverflow
Question	Bernd Strehl	View Question on Stackoverflow
Solution 1 - Laravel	maknz	View Answer on Stackoverflow
Solution 2 - Laravel	Dazzle	View Answer on Stackoverflow

Laravel: Get pivot data for specific many to many relation

Laravel Problem Overview

Laravel Solutions

Solution 1 - Laravel

Solution 2 - Laravel

Android Wear notification prevent blinking icon when updating

Shim vs. Sham: What is the difference?

Attributions