`php artisan key:generate` is a command that sets the `APP_KEY` value in your `.env` file. By default, this command is run following a `composer create-project laravel/laravel` command. If you use a version control system like `git` to manage your project for development, calling `git push ...` will push a copy of your Laravel project to wherever it is going, but will not include your `.env` file. Therefore, if someone clones your project using `git clone ...` they will have to manually enter `php artisan key:generate` for their app to function correctly.

So, TL:DR the only time you *need* to call `php artisan key:generate` is following a `clone` of a pre-created Laravel project.

Side note: If you try to run a Laravel project with your `APP_KEY` set to `SomeRandomString` (which is the default in your `.env.example` file, you will actually get an error: 

&gt;No supported encrypter found. The cipher and / or key length are invalid.


The most important thing to do when cloning a laravel project is to first run `composer update` then `composer install`. The `composer install` command installs any required dependencies for that laravel app.

The steps I took to clone a laravel project required the `php artisan key:generate` command. I can see in my `.env` file that there is an updated `APP_KEY=base64:xxxxxxxxxxxxxxxxxxxx` after running this command.

I am trying to save a date from my Angular ui-Datepicker to my SQL database.  The date is in the format (10-27-2015 12:00 AM) but it will not save.  I tried using the following to convert it to SQL DateTime format:

        DateTime? myDate = form.dteStartDate;
        string sqlFormattedDate = myDate.ToString(&quot;yyyy-MM-dd HH:mm:ss&quot;);

But I receive the error &quot;No overload for method &#39;ToString&#39; takes 1 arguments.  The field in SQL is type &#39;datetime&#39;.

Any assistance is greatly appreciated.

No overload for method &#39;ToString&quot; takes 1 arguments when casting date

What is the difference between
 

    float f = (float) 99.32 ;

and 

    float f = 99.32f ;


Both of them compiled and ran successfully.

What is the difference between casting to `float` and adding `f` as a suffix when initializing a `float`?

Since it automatically sets it for me in my `.env` file when I create the app, I&#39;m not sure when I should run it.

In addition to that, if a second developer comes in, and **clones** the app, does he/she need to run `php artisan key:generate` ? 

How do we know exactly when to run `php artisan key:generate` ?






When to generate a new Application Key in Laravel?

Since it automatically sets it for me in my <code>.env</code> file when I create the app, I'm not sure when I should run it.
In addition to that, if a second developer comes in, and clones the app, does he/she need to run <code>php artisan key:generate</code> ?
How do we know exactly when to run <code>php artisan key:generate</code> ?

I just wiped my Mac and did a fresh install of El Capitan. I&#39;m struggling to connect to Mysql now. Having gone through a web server setup process, I&#39;ve created a simple PHP test file:

    &lt;?php
      $conn = new mysqli(&quot;127.0.0.1&quot;, &quot;root&quot;, &quot;xxxxxxxx&quot;);
      if ($conn-&gt;connect_error) echo &quot;Connection failed: &quot; . $conn-&gt;connect_error; 
      else echo &quot;Connected successfully&quot;;
      phpinfo();
    ?&gt;

When I run it, I get this error:

    Warning: mysqli::mysqli(): (HY000/1862): Your password has expired. To log in you must change it using a client that supports expired passwords. in /Users/rich/Documents/DESIGN/test/index.php on line 3
    Connection failed: Your password has expired. To log in you must change it using a client that supports expired passwords.

I&#39;ve never seen that response from a connection before. How do I fix it if I can&#39;t connect?


**EDIT**

In terminal I entered the command:

`mysql -u root -p`

This asked me for my password (current one) which I put in. I now have access to mysql commands but anything I try results in this error:

    ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

How do I reset the password using `ALTER USER`?

Mysql password expired. Can&#39;t connect

I have an array that returns the following date time:

    $item[&#39;created_at&#39;] =&gt; &quot;2015-10-28 19:18:44&quot;

How do I change the date to `M d Y` format in Laravel using Carbon?

Currently it returns with an error

    $suborder[&#39;payment_date&#39;] = $item[&#39;created_at&#39;]-&gt;format(&#39;M d Y&#39;);




Formatting a Carbon date instance

I am trying to check if a database is connected in Laravel.

I&#39;ve looked around the documentation and can&#39;t find anything. The closest thing I&#39;ve found is [this](http://laravel.com/docs/5.1/database#accessing-connections), but this doesn&#39;t solve my problem.

I have three instances of MySQL that are set up on different machines. Below is a simplified version of what I am trying to achieve.

1. If database 1 is connected, save data to it
2. If database 1 is not connected, check if database 2 is connected
3. If database 2 is connected save data to it
3. If database 2 is not connected, check if database 3 is connected
4. If database 3 is connected, save data to it

To be clear, is there a way to check that a database is connected in Laravel 5.1?

Laravel 5.1 - Checking a Database Connection

How to make something like this? (all methods collapsed by default without any hotkeys)

[![collapsed methods][1]][1]


  [1]: http://i.stack.imgur.com/FBVrj.jpg

How to make PHPStorm collapsing all methods/functions on file open?

Example:

    $a[] = &#39;56&#39;;
    $a[] = &#39;66&#39;;
    $a[] = &#39;&#39;;
    $a[] = &#39;58&#39;;
    $a[] = &#39;85&#39;;
    $a[] = &#39;&#39;;
    $a[] = &#39;&#39;;
    $a[] = &#39;76&#39;;
    $a[] = &#39;&#39;;
    $a[] = &#39;57&#39;;

Actually how to find average value from this array excluding empty. please help to resolve this problem.

How to find average from array in php?

I&#39;m trying to figure out how I can take two date time strings that are stored in our database and convert it to a difference in time format of hh:mm:ss.

I looked at `diffForHumans`, but that does give the format I&#39;d like and returns things like `after`, `ago`, etc; which is useful, but not for what I&#39;m trying to do.

The duration will never span days, only a max of a couple hours.

    $startTime = Carbon::parse($this-&gt;start_time);
    $finishTime = Carbon::parse($this-&gt;finish_time);

    $totalDuration = $finishTime-&gt;diffForHumans($startTime);
    dd($totalDuration);

    // Have: &quot;21 seconds after&quot;
    // Want: 00:00:21


Carbon Difference in Time between two Dates in hh:mm:ss format

I&#39;m having a lot of trouble figuring out how to use this collection to count rows. 

    $wordlist = \DB::table(&#39;wordlist&#39;)-&gt;where(&#39;id&#39;, &#39;&lt;=&#39;, $correctedComparisons)
                    -&gt;get();

I have tried `adding-&gt;count()` but didn&#39;t work. I have tried doing `count($wordlist)`. I&#39;m not really sure what to do without needing a second request as `a-&gt;count()` method. 

eloquent laravel: How to get a row count from a -&gt;get()

I am new to Laravel. I just started it tonight. Actually, I have the following code: 

    &#39;key&#39; =&gt; env(&#39;APP_KEY&#39;, &#39;SomeRandomString&#39;),

In *xampp/htdocs/laravel/blog/config/app.php*.  
I want to change this key to 32-bit by cmd as:

    xampp\htdocs\laravel/blog&gt;php artisan key:generate 

It generates the key but could not replace/update in *xampp/htdocs/laravel/blog/config/app.php*.



Laravel 5 Application Key

When trying to run a migration I get the error Artisan migration 

&gt; error:`Class &#39;Doctrine\\DBAL\\Driver\\PDOMySql\\Driver&#39; not found`

I have read the questions here and also see the notes to add:

`doctrine/dbal&quot;: &quot;~2.3` in the requires section of composer.json

[Github Bug Report][1]

However, I don&#39;t understand what has happened. I created table a few days ago with no issue.

I can&#39;t figure out what to do after adding that dependency in composer.son.

I don&#39;t want to accidentally update any other packages.


  [1]: https://github.com/laravel/framework/issues/3116

artisan migration error &quot;Class &#39;Doctrine\\DBAL\\Driver\\PDOMySql\\Driver&#39; not found&quot;,

I want to add new element in `$items` array, I don&#39;t want to use joins for certain reasons.
    
    $items = DB::select(DB::raw(&#39;SELECT * FROM items WHERE items.id = &#39;.$id.&#39;  ;&#39;));
            foreach($items as $item){
                $product = DB::select(DB::raw(&#39; select * from product
                       where product_id = &#39;. $id.&#39;;&#39; ));

                $item-&gt;push($product);
            }
What should I do?

add new element in laravel collection object

I want to change my two table name in the Laravel, so do I have to manually change the table name or it can be possible through migration.

Laravel Migration to change table name

I have built some migration classes in my application to create the tables I need, but I keep getting errors. I need to run this command:

 `composer dump-autoload` 

Only then it works again as expected. Am I doing something wrong that generates this error or this is a normal behaviour with migrations?

Below is the error that I get when running the migration process:

      [Symfony\Component\Debug\Exception\FatalErrorException]  
      Class &#39;CreateVideoStatusTable&#39; not found  

   

Why do I have to run &quot;composer dump-autoload&quot; command to make migrations work in laravel?

I have a console application that manages images. Now i need something like a preview of the Images within the console application. Is there a way to display them in the console?



Here is a comparison of the current character based answers:

Input:

[![enter image description here][1]][1]

Output:

[![enter image description here][2]][2]

[![enter image description here][3]][3]

[![enter image description here][4]][4]

[![enter image description here][5]][5]


  [1]: http://i.stack.imgur.com/teq9P.jpg
  [2]: http://i.stack.imgur.com/hLdnj.png
  [3]: http://i.stack.imgur.com/JmIGw.png
  [4]: http://i.stack.imgur.com/YrbAn.png
  [5]: http://i.stack.imgur.com/Z4DWa.png

Display a Image in a console application

I am new to C# and downloaded the free version of Microsoft Visual Studio 2015. To write a first program, I created a Windows Forms Application. Now I use     `Console.Out.WriteLine()` to print some test data. But where can I read the console?

Where can I read the Console output in Visual Studio 2015

Function `foo` prints to console. I want to test the console print. How can I achieve this in python?

Need to test this function, has NO return statement : 

    def foo(inStr):
       print &quot;hi&quot;+inStr

My test : 
    
    def test_foo():
        cmdProcess = subprocess.Popen(foo(&quot;test&quot;), stdout=subprocess.PIPE)
        cmdOut = cmdProcess.communicate()[0]
        self.assertEquals(&quot;hitest&quot;, cmdOut)




Python: Write unittest for console print

I&#39;m running MySql Server 5.7.11 and this sentence:

    updated datetime NOT NULL DEFAULT &#39;0000-00-00 00:00:00&#39;

is **not** working. Giving the error:

    ERROR 1067 (42000): Invalid default value for &#39;updated&#39;

But the following: 

    updated datetime NOT NULL DEFAULT &#39;1000-01-01 00:00:00&#39;

**just works**.  

The same case for DATE.

As a *sidenote*, it is mentioned in the [MySQL docs][1]:  

&gt; The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in &#39;YYYY-MM-DD&#39; format. The supported range is &#39;1000-01-01&#39; to &#39;9999-12-31&#39;.  

even if they also say:

&gt; Invalid DATE, DATETIME, or TIMESTAMP values are converted to the “zero” value of the appropriate type (&#39;0000-00-00&#39; or &#39;0000-00-00 00:00:00&#39;).
  
Having also into account the second quote from MySQL documentation, could anyone let me know why it is giving that error?  




  [1]: http://dev.mysql.com/doc/refman/5.7/en/datetime.html   





Error in MySQL when setting default value for DATE or DATETIME

How can I get the console to show in a fiddle on JSfiddle.com?

I recently saw a fiddle that had the console embedded in the fiddle, anyone know how this can be done?

How to get console inside jsfiddle

In Laravel 5.1 is there a nice way to check if an eloquent model object has been soft-deleted? I&#39;m not talking about selecting data but once I have the object e.g. `Thing::withTrashed()-&gt;find($id)`

So far the only way I can see is

    if ($thing-&gt;deleted_at !== null) { ... }

I do not see any relevant method [in the API][1] that would allow for example

    if ($thing-&gt;isDeleted()) { ... }


  [1]: http://laravel.com/api/5.1/Illuminate/Database/Eloquent/Model.html

How to check if row is soft-deleted in Eloquent?

I&#39;m following the official **[upgrade guide][1]** from 5.1 to 5.2. First sub-section says:

&gt; If you are installing a beta release of Laravel 5.2, add
&gt; `&quot;minimum-stability&quot;: &quot;beta&quot;` to your composer.json file.
&gt; 
&gt; Update your composer.json file to point to `laravel/framework 5.2.*`.
&gt; 
&gt; Add `symfony/dom-crawler ~3.0` and `symfony/css-selector ~3.0` to the
&gt; require-dev section of your composer.json file.

Now, after I introduce the above changes and run `composer update`, I get the following error(s):

    PHP Fatal error:  Class &#39;Illuminate\Routing\ControllerServiceProvider&#39; not found 
    in /home/vagrant/Code/myproject/vendor/laravel/framework/src/Illuminate/Foundation/ProviderRepository.php on line 146

and

    [Symfony\Component\Debug\Exception\FatalErrorException]
    Class &#39;Illuminate\Routing\ControllerServiceProvider&#39; not found

and

    [RuntimeException]
    Error Output: PHP Fatal error:  Class &#39;Illuminate\Routing\ControllerServiceProvider&#39; not found in /home/vagrant/Code/myproject/vendor/laravel/framework/src/Illuminate/Foundation/ProviderRepository.php on line 146

The errors are thrown **after** the update is done, and &quot;Generating autoload files&quot; takes place.

**What might be wrong?**

It does not look like a custom package issue, but a core one. Should I continue with the upgrade guide and run `composer update` AFTER all has been adjusted to suit the new framework version?

**UPDATE**

Running `composer dump-autoload` afterwards **doesn&#39;t throw the errors** described above. Still confusing, though.

  [1]: http://laravel.com/docs/5.2/upgrade#upgrade-5.2.0

Fatal error while upgrading Laravel 5.1 to 5.2

I have a project in Laravel-5.1 and I have changed my platform from win10 to Ubuntu.

Showing error:
&gt;Loading composer repositories with package information
&gt;
&gt;Updating dependencies (including require-dev)
&gt;
&gt;Your requirements could not be resolved to an installable set of packages.

      Problem 1
    - laravel/framework v5.2.9 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.8 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.7 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.6 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.5 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.4 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.31 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.30 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.3 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.29 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.28 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.27 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.26 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.25 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.24 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.23 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.22 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.21 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.20 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.2 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.19 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.18 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.17 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.16 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.15 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.14 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.13 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.12 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.11 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.10 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.1 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.0 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - laravel/framework v5.2.30 requires ext-mbstring * -&gt; the requested PHP extension mbstring is missing from your system.
    - Installation request for laravel/framework 5.2.* -&gt; satisfiable by laravel/framework[v5.2.0, v5.2.1, v5.2.10, v5.2.11, v5.2.12, v5.2.13, v5.2.14, v5.2.15, v5.2.16, v5.2.17, v5.2.18, v5.2.19, v5.2.2, v5.2.20, v5.2.21, v5.2.22, v5.2.23, v5.2.24, v5.2.25, v5.2.26, v5.2.27, v5.2.28, v5.2.29, v5.2.3, v5.2.30, v5.2.31, v5.2.4, v5.2.5, v5.2.6, v5.2.7, v5.2.8, v5.2.9].

    To enable extensions, verify that they are enabled in those .ini files:
    - /etc/php/7.0/cli/php.ini
    - /etc/php/7.0/cli/conf.d/10-mysqlnd.ini
    - /etc/php/7.0/cli/conf.d/10-opcache.ini
    - /etc/php/7.0/cli/conf.d/10-pdo.ini
    - /etc/php/7.0/cli/conf.d/20-calendar.ini
    - /etc/php/7.0/cli/conf.d/20-ctype.ini
    - /etc/php/7.0/cli/conf.d/20-exif.ini
    - /etc/php/7.0/cli/conf.d/20-fileinfo.ini
    - /etc/php/7.0/cli/conf.d/20-ftp.ini
    - /etc/php/7.0/cli/conf.d/20-gettext.ini
    - /etc/php/7.0/cli/conf.d/20-iconv.ini
    - /etc/php/7.0/cli/conf.d/20-json.ini
    - /etc/php/7.0/cli/conf.d/20-mysqli.ini
    - /etc/php/7.0/cli/conf.d/20-pdo_mysql.ini
    - /etc/php/7.0/cli/conf.d/20-phar.ini
    - /etc/php/7.0/cli/conf.d/20-posix.ini
    - /etc/php/7.0/cli/conf.d/20-readline.ini
    - /etc/php/7.0/cli/conf.d/20-shmop.ini
    - /etc/php/7.0/cli/conf.d/20-sockets.ini
    - /etc/php/7.0/cli/conf.d/20-sysvmsg.ini
    - /etc/php/7.0/cli/conf.d/20-sysvsem.ini
    - /etc/php/7.0/cli/conf.d/20-sysvshm.ini
    - /etc/php/7.0/cli/conf.d/20-tokenizer.ini
    You can also run `php --ini` inside terminal to see which files are used by PHP in CLI mode.
Composer/json.

    {
    &quot;name&quot;: &quot;laravel/laravel&quot;,
    &quot;description&quot;: &quot;The Laravel Framework.&quot;,
    &quot;keywords&quot;: [&quot;framework&quot;, &quot;laravel&quot;],
    &quot;license&quot;: &quot;MIT&quot;,
    &quot;type&quot;: &quot;project&quot;,
    &quot;require&quot;: {
      &quot;php&quot;: &quot;&gt;=5.5.9&quot;,
      &quot;laravel/framework&quot;: &quot;5.2.*&quot;,
      &quot;infyomlabs/laravel-generator&quot;: &quot;dev-master&quot;,
      &quot;laravelcollective/html&quot;: &quot;5.2.*&quot;,
      &quot;infyomlabs/core-templates&quot;: &quot;dev-master&quot;,
      &quot;infyomlabs/swagger-generator&quot;: &quot;dev-master&quot;,
      &quot;jlapp/swaggervel&quot;: &quot;dev-master&quot;,
      &quot;doctrine/dbal&quot;: &quot;~2.3&quot;,
      &quot;infyomlabs/generator-builder&quot;: &quot;dev-master&quot;,
      &quot;yajra/laravel-datatables-oracle&quot;: &quot;~6.0&quot;,
      &quot;barryvdh/laravel-ide-helper&quot;: &quot;^2.1&quot;,
      &quot;infyomlabs/adminlte-templates&quot;: &quot;dev-master&quot;
    },
    &quot;require-dev&quot;: {
        &quot;fzaninotto/faker&quot;: &quot;~1.4&quot;,
        &quot;mockery/mockery&quot;: &quot;0.9.*&quot;,
        &quot;phpunit/phpunit&quot;: &quot;~4.0&quot;,
        &quot;symfony/css-selector&quot;: &quot;2.8.*|3.0.*&quot;,
        &quot;symfony/dom-crawler&quot;: &quot;2.8.*|3.0.*&quot;
    },
    &quot;autoload&quot;: {
        &quot;classmap&quot;: [
            &quot;database&quot;
        ],
        &quot;psr-4&quot;: {
            &quot;App\\&quot;: &quot;app/&quot;
        }
    },
    &quot;autoload-dev&quot;: {
        &quot;classmap&quot;: [
            &quot;tests/TestCase.php&quot;
        ]
    },
    &quot;scripts&quot;: {
        &quot;post-root-package-install&quot;: [
            &quot;php -r \&quot;copy(&#39;.env.example&#39;, &#39;.env&#39;);\&quot;&quot;
        ],
        &quot;post-create-project-cmd&quot;: [
            &quot;php artisan key:generate&quot;
        ],
        &quot;post-install-cmd&quot;: [
            &quot;Illuminate\\Foundation\\ComposerScripts::postInstall&quot;,
            &quot;php artisan optimize&quot;
        ],
        &quot;post-update-cmd&quot;: [
            &quot;Illuminate\\Foundation\\ComposerScripts::postUpdate&quot;,
            &quot;php artisan optimize&quot;
        ]
    },
    &quot;config&quot;: {
        &quot;preferred-install&quot;: &quot;dist&quot;
    }
}




Content Type	Original Author	Original Content on Stackoverflow
Question	code-8	View Question on Stackoverflow
Solution 1 - Php	Tim Lewis	View Answer on Stackoverflow
Solution 2 - Php	Erich Meissner	View Answer on Stackoverflow

When to generate a new Application Key in Laravel?

Php Problem Overview

Php Solutions

Solution 1 - Php

Solution 2 - Php

What is the difference between casting to `float` and adding `f` as a suffix when initializing a `float`?

No overload for method 'ToString" takes 1 arguments when casting date

Attributions