&gt; If you want your pivot table to have automatically maintained
&gt; created_at and updated_at timestamps, use the `withTimestamps()`
&gt; method on the relationship definition.

    return $this-&gt;belongsToMany(&#39;Role&#39;)-&gt;withTimestamps();

 * For Laravel 4.2: [Working With Pivot Tables][3]
 * Laravel 5.0: [Working With Pivot Tables][1]
 * Laravel 5.1: [Retrieving Intermediate Table Columns][2]
 * Laravel 5.2: [Filtering Relationships Via Intermediate Table Columns][4]
 * Laravel 5.3: [Filtering Relationships Via Intermediate Table Columns][5]
 * Laravel 5.4: [Retrieving Intermediate Table Columns][6]
 * Laravel 5.5: [Retrieving Intermediate Table Columns][7]
 * Laravel 5.6: [Retrieving Intermediate Table Columns][8]
 * Laravel 5.7: [Retrieving Intermediate Table Columns][9]
 * Laravel 5.8: [Retrieving Intermediate Table Columns][10]

 
  [1]: http://laravel.com/docs/5.0/eloquent#working-with-pivot-tables
  [2]: http://laravel.com/docs/5.1/eloquent-relationships#many-to-many
  [3]: http://laravel.com/docs/4.2/eloquent#working-with-pivot-tables
  [4]: https://laravel.com/docs/5.2/eloquent-relationships#many-to-many
  [5]: https://laravel.com/docs/5.3/eloquent-relationships#many-to-many
  [6]: https://laravel.com/docs/5.4/eloquent-relationships#many-to-many
  [7]: https://laravel.com/docs/5.5/eloquent-relationships#many-to-many
  [8]: https://laravel.com/docs/5.6/eloquent-relationships#many-to-many
  [9]: https://laravel.com/docs/5.7/eloquent-relationships#many-to-many
  [10]: https://laravel.com/docs/5.8/eloquent-relationships#many-to-many


I tried to use the [YouTube player demo][1] to generate the code necessary for my video to autoplay and loop itself.
But only the autoplay works, it doesn&#39;t loop, and the demo-video doesn&#39;t work either. Here is the code I&#39;ve used.

    &lt;iframe class=&quot;embed-responsive-item&quot; id=&quot;ytplayer&quot; type=&quot;text/html&quot; width=&quot;640&quot; height=&quot;360&quot; src=&quot;https://www.youtube.com/embed/M7lc1UVf-VE?&amp;autoplay=1&amp;loop=1&amp;rel=0&amp;showinfo=0&amp;color=white&amp;iv_load_policy=3&quot; frameborder=&quot;0&quot; allowfullscreen&gt;
    &lt;/iframe&gt;





  [1]: https://developers.google.com/youtube/youtube_player_demo?hl=zh-tw

Youtube iframe &quot;loop&quot; doesn&#39;t work

I&#39;m developing an enterprise application. When I was testing it in iOS8 beta I saw the following alert view:

    Untrusted App Developer
    Do you trust the developer &quot;iPhone Distribution: ---&quot; to run apps on you iPad?

It only appears the first time.
Can I avoid it somehow? And what is it related to?

![Screenshot][1]


  [1]: http://i.stack.imgur.com/WwF76.png

&quot;Untrusted App Developer&quot; message when installing enterprise iOS Application

I&#39;m creating a row in pivot table using the following attach statement. 

    $music = Music::find(1);
    $music-&gt;users()-&gt;attach(1);

This inserting a row in pivot table but, It is not updating the timestamp. The timestamp remains 0000-00-00 00:00:00

Is there any way to update the timestamps in pivot table. ?

Thanks in advance,

Timestamps are not updating while attaching data in pivot table

I'm creating a row in pivot table using the following attach statement.
<pre><code class="hljs language-scss">$music = Music::find(1);
$music->users()->attach(1);
</code></pre>
This inserting a row in pivot table but, It is not updating the timestamp. The timestamp remains 0000-00-00 00:00:00
Is there any way to update the timestamps in pivot table. ?
Thanks in advance,

When running the following command at the root of my Laravel 5 application, 

    php artisan migrate:make create_mytable

I get the following error:

    [InvalidArgumentException]              
    Command &quot;migrate:make&quot; is not defined.  
    Did you mean one of these?              
    migrate:reset                       
    migrate:refresh                     
    migrate:status                      
    migrate:rollback                    
    migrate:install                     
    migrate   

Is there a new way to start migrations in Laravel 5?      


php artisan migrate:make create_mytable fails: &quot;migrate:make&quot; is not defined

I&#39;m having trouble to write query in `laravel eloquent ORM`. 

my query is 

    SELECT book_name,dt_of_pub,pub_lang,no_page,book_price  
    FROM book_mast        
    WHERE book_price NOT IN (100,200);

Now I want to convert this query into laravel eloquent.

  


Laravel Eloquent &quot;WHERE NOT IN&quot;

I&#39;m on Laravel using `php artisan queue:listen` to run queued jobs. One of these jobs is fairly involved and takes a long time, and so I&#39;m getting the following error:

    [Symfony\Component\Process\Exception\ProcessTimedOutException]                                                                                                                                                                              
    The process &quot;&quot;/usr/local/Cellar/php55/5.5.14/bin/php&quot; artisan queue:work  
    --queue=&quot;QUEUE_URL&quot; --delay=0 --memory=128 --sleep=3 --tries=0&quot; 
    exceeded the timeout of 60 seconds.

I know that I could run `queue:listen` with an arbitrarily high timeout value, but that&#39;s not ideal, as I _do_ want it to time out in the event that some process is _actually_ unreseponsive. I tried regularly calling `set_time_limit(60)` within the function called by the job, but that did not solve my problem.

I found a thread online mentioning `Symfony\Component\Process\Process-&gt;setTimeout(null)`, but I don&#39;t know how to access that process object, or if that would even fix the issue.

Any help would be much appreciated.

Laravel queue process timeout error

I&#39;m trying get a single value from MySQL database using laravel but the problem I&#39;m getting an array . this is my query result in MySQL command line:

    select groupName from users;

---

    +-----------+
    | groupName |
    +-----------+
    | Admin     |
    +-----------+

my laravel function:

	public static function PermitAddNewUser(){
		$username=Session::get(&#39;key&#39;);
		$data=DB::select(&quot;select groupName from users where username=&#39;$username&#39;;&quot;);
		return $data; 
	}

expected $data value is a string with value= Admin

but what i get is : `[{&quot;groupName&quot;:&quot;Admin&quot;}]`

Laravel: getting a single value from a MySQL query

I have a PDF file stored in app/storage/, and I want authenticated users to be able to view this file. I know that I can make them download it using 

    return Response::download($path, $filename, $headers);

but I was wondering if there is a way to make them view the file directly in the browser, for example when they are using Google Chrome with the built-in PDF viewer. Any help will be appreciated!

Laravel - display a PDF file in storage without forcing download?

I really tried to understand the difference between the `with()` method and the `load()` method, but couldn&#39;t really understand.

As I see it, using the `with()` method is &quot;better&quot; since I eager load the relation. It seems that if I use `load()` I load the relation just as if I would use the `hasMany()` (or any other method that relates to the relation between objects). 

Do I get it wrong?  

laravel with() method versus load() method

I&#39;m building a small CMS in Laravel and I tried to show the content (which is stored in the DB). It is showing the HTML tags instead of executing them. Its like there is an auto html_entity_decode for all printed data.

&lt;!-- language: php --&gt;

    &lt;?php

    class CmsController extends BaseController
    {
        public function Content($name)
        {    
            $data = Pages::where(&#39;CID&#39;, &#39;=&#39;, Config::get(&#39;company.CID&#39;))
                -&gt;where(&#39;page_name&#39;, &#39;=&#39;, $name)
                -&gt;first();

            return View::make(&#39;cms.page&#39;)-&gt;with(&#39;content&#39;, $data);
        }
    }


I tried to print the content using the curly brace.

&lt;!-- language: php --&gt;

    {{ $content-&gt;page_desc }}

and triple curly brace.

&lt;!-- language: php --&gt;

    {{{ $content-&gt;page_desc }}}

And they give the same result. I need to execute those HTML tags instead of escaping them.

Laravel Escaping All HTML in Blade Template

I&#39;m settin up my offline job server. I&#39;ve read the documentation but I still don&#39;t really see the differences between the two commands: `artisan queue:work --daemon` and `artisan queue:listen`. Which command should I use for running my daemons?

What is the difference between queue:work --daemon and queue:listen

I want to send a confirmation e-mail using laravel.
The laravel Mail::send() function only seems to accept a path to a file on the system.
The problem is that my mailtemplates are stored in the database and not in a file on the system.

How can I pass plain content to the email?

Example:


    $content = &quot;Hi,welcome user!&quot;;

    Mail::send($content,$data,function(){});

Laravel mail: pass string instead of view

I have two related models: `Category` and `Post`.

The `Post` model has a `published` scope (method `scopePublished()`).

When I try to get all categories with that scope:

    $categories = Category::with(&#39;posts&#39;)-&gt;published()-&gt;get();

I get an error: 

&gt; Call to undefined method `published()`

**Category:**

    class Category extends \Eloquent
    {
        public function posts()
        {
            return $this-&gt;HasMany(&#39;Post&#39;);
        }
    }

**Post:**

    class Post extends \Eloquent
    {
       public function category()
       {
           return $this-&gt;belongsTo(&#39;Category&#39;);
       }


       public function scopePublished($query)
       {
           return $query-&gt;where(&#39;published&#39;, 1);
       }

    }



Laravel. Use scope() in models with relation

In my Laravel application I have an `Faq` model.  An `Faq` model can contain many `Product` models, so the `Faq` class contains the following function:

    class Faq extends Eloquent{ 
        public function products(){
            return $this-&gt;belongsToMany(&#39;Product&#39;);
        }
    }

In a controller, I would like to be able to retrieve the class name that defines the relationship.  For example, if I have an `Faq` object, like this:

    $faq = new Faq();

How can I determine the class name of the relationship, which in this case would be `Product`.  Currently I am able to do it like this:

    $className = get_class($faq-&gt;products()-&gt;get()-&gt;first());

However, I&#39;m wondering if there is a way to accomplish this same thing without having to actually run a query.

Laravel get class name of related model

I&#39;m working on a project in *Laravel*. I have an Account model that can have a parent or can have children, so I have my model set up like so:

    public function immediateChildAccounts()
	{
		return $this-&gt;hasMany(&#39;Account&#39;, &#39;act_parent&#39;, &#39;act_id&#39;);
	}

	public function parentAccount()
	{
		return $this-&gt;belongsTo(&#39;Account&#39;, &#39;act_parent&#39;, &#39;act_id&#39;);
	}

This works fine. What I want to do is get all children under a certain account. Currently, I&#39;m doing this:

	public function allChildAccounts()
	{
		$childAccounts = $this-&gt;immediateChildAccounts;
		if (empty($childAccounts))
			return $childAccounts;
		
		foreach ($childAccounts as $child)
		{
			$child-&gt;load(&#39;immediateChildAccounts&#39;);
			$childAccounts = $childAccounts-&gt;merge($child-&gt;allChildAccounts());
		}
		
		return $childAccounts;
	}

This also works, but I have to worry if it&#39;s slow. This project is the re-write of an old project we use at work. We will have several thousand accounts that we migrate over to this new project. For the few test accounts I have, this method poses no performance issues.

Is there a better solution? Should I just run a raw query? Does *Laravel* have something to handle this? 

**In summary**
What I want to do, for any given account, is get every single child account and every child of it&#39;s children and so on in a single list/collection. A diagram:

    A -&gt; B -&gt; D
    |--&gt; C -&gt; E
         |--&gt; F 
    G -&gt; H

If I run A-&gt;immediateChildAccounts(), I should get {B, C}  
If I run A-&gt;allChildAccounts(), I should get {B, D, C, E, F} (order doesn&#39;t matter)

Again, my method works, but it seems like I&#39;m doing way too many queries.



Also, I&#39;m not sure if it&#39;s okay to ask this here, but it is related. How can I get a list of all accounts that **don&#39;t** include the child accounts? So basically the inverse of that method above. This is so a user doesn&#39;t try to give an account a parent that&#39;s already it&#39;s child. Using the diagram from above, I want (in pseudocode):

Account::where(account_id not in (A-&gt;allChildAccounts())). So I would get {G, H}

Thanks for any insight.

Laravel Recursive Relationships

I am trying to find an elegant way in Eloquent and Laravel to say

    select * from UserTable where Age between X and Y

Is there a between operator in Eloquent (I can&#39;t find it).

The closest i have gotten so far is chainging my query like this

    $query-&gt;where(age, &#39;&gt;=&#39;, $ageFrom)
	      -&gt;where(age, &#39;&lt;=&#39;, $ageTo);

I also came across whereRaw that seems to work

    $query-&gt;whereRaw(&#39;age BETWEEN &#39; . $ageFrom . &#39; AND &#39; . $ageTo . &#39;&#39;);

Is there an actual Eloquent way (not raw) that deals with ranges?



Content Type	Original Author	Original Content on Stackoverflow
Question	Sriraman	View Question on Stackoverflow
Solution 1 - Laravel	marcanuy	View Answer on Stackoverflow

Timestamps are not updating while attaching data in pivot table

Laravel Problem Overview

Laravel Solutions

Solution 1 - Laravel

"Untrusted App Developer" message when installing enterprise iOS Application

Youtube iframe "loop" doesn't work

Attributions