1) To install dependency , run this command

    composer require doctrine/dbal

2) For &#39;git&#39; is not recognized error, either you don&#39;t have git installed or the PATH is not added in the environment variables.

[Install git for windows][1]. 




 
 


  [1]: https://git-scm.com/book/en/v2/Getting-Started-Installing-Git#Installing-on-Windows

To add this dependency open the composer.json at the root of your project (in the same level as app, public etc.) and in the require section add the doctrine/dbal package like:

    &quot;require&quot;: {
    	&quot;laravel/framework&quot;: &quot;4.1.*&quot;,
    	&quot;doctrine/dbal&quot;: &quot;v2.4.2&quot;
    },

Save the file and run `composer update`

**Edit** 

You probably installed git with the default settings and it&#39;s not in your PATH env.

Open Git Bash (it was installed with git - you will find it in your programs) and do `composer update`. By the way it&#39;s far better that windows command prompt.

If you are getting error while running migration try this

    composer require doctrine/dbal:2.*




I have run on my windows console:

    npm install -g yo grunt-cli bower
    
    npm install -g generator-angular
    
    yo angular

 

Then I started my project with webstorm and did right click on the karma.conf.js file in the project explorer where I have the menu item &#39;Run karma.conf.js&#39; and start the karma runner. Then I get his exception:

    ...\app\node_modules\karma\node_modules\di\lib\injector.js:9
          throw error(&#39;No provider for &quot;&#39; + name + &#39;&quot;!&#39;);
                ^
    Error: No provider for &quot;framework:jasmine&quot;! (Resolving: framework:jasmine)

Then in the console I read I can also use --force so I tried it: grunt --force

It took some time but there seemed to be no more errors. Heck why does --force install a provider ??? THIS was TESTED in the CMD.

grunt serve now worked and it started my browser with the starting app.

**So what was --force doing that the &#39;Error: No provider for &quot;framework:jasmine&quot;! (Resolving: framework:jasmine)&#39; is gone ?**

When I do grunt in the webstrom IDE I get again:

Warning: No provider for &quot;framework:jasmine&quot;! (Resolving: framework:jasmine) Use --force to continue.

So this problem is not solved.

Error: No provider for &quot;framework:jasmine&quot;! (Resolving: framework:jasmine)

At what point does a MySQL database start to lose performance?

  - Does physical database size matter?
  - Do number of records matter?
  - Is any performance degradation linear or exponential?

I have what I believe to be a large database, with roughly 15M records which take up almost 2GB. Based on these numbers, is there any incentive for me to clean the data out, or am I safe to allow it to continue scaling for a few more years?

How big can a MySQL database get before performance starts to degrade

I am trying to execute a migration to rename some columns and I got an exception. 

As I read on the documentation I have to add the doctrine/dbal dependency to my composer.json file. How do I do that? Which is the correct composer.json file. I have many in my application. Is the one that is on the same level as the folders app,bootstrap, public and vendor.

If so how do I add that dependency. Do I have to download anything?

By the way im using easyphp, not wamp!

## Edit 1 ##

After doing that the console throws this error

![cmd](https://s27.postimg.cc/71af111bn/Untitled.png)



Install dependency (doctrine/dbal) on composer laravel

I am trying to execute a migration to rename some columns and I got an exception.
As I read on the documentation I have to add the doctrine/dbal dependency to my composer.json file. How do I do that? Which is the correct composer.json file. I have many in my application. Is the one that is on the same level as the folders app,bootstrap, public and vendor.
If so how do I add that dependency. Do I have to download anything?
By the way im using easyphp, not wamp!
<h4 id="edit-1"><a aria-hidden="true" tabindex="-1" href="#edit-1"></a>Edit 1</h4>
After doing that the console throws this error
<img src="https://s27.postimg.cc/71af111bn/Untitled.png" alt="cmd">

Please correct me if I am wrong, but I think there is no such thing as mass update in an Eloquent model.

Is there a way to make a mass update on the DB table without issuing a query for every row?

For example, is there a static method, something like 


    User::updateWhere(
        array(&#39;age&#39;, &#39;&lt;&#39;, &#39;18&#39;),
        array(
            &#39;under_18&#39; =&gt; 1 
            [, ...]
        )
    );

(yes, it is a silly example but you get the picture...)

Why isn&#39;t there such a feature implemented? 
Am I the only one who would be very happy if something like this comes up?

I (the developers), wouldn&#39;t like to implement it like:

    DB::table(&#39;users&#39;)-&gt;where(&#39;age&#39;, &#39;&lt;&#39;, &#39;18&#39;)-&gt;update(array(&#39;under_18&#39; =&gt; 1));

because as the project grows, we may require the programmers to change the table name in the future and they cannot search and replace for the table name!

Is there such a static method to perform this operation? And if there is not, can we extend the `Illuminate\Database\Eloquent\Model` class to accomplish such a thing?



Eloquent model mass update

I have a bad experience while installing laravel. However, I was able to do so and move to the next level. I used generators and created my migrations. 
But when I type the last command 

    php artisan migrate
It&#39;s throwing a PDOException - could not find driver.

           &#39;mysql&#39; =&gt; array(
    	        &#39;driver&#39;    =&gt; &#39;mysql&#39;,
    	        &#39;host&#39;      =&gt; &#39;localhost&#39;,
    	        &#39;unix_socket&#39;   =&gt; &#39;/Applications/MAMP/tmp/mysql/mysql.sock&#39;,
    	        &#39;database&#39;  =&gt; &#39;database&#39;,
    	        &#39;username&#39;  =&gt; &#39;root&#39;,
    	        &#39;password&#39;  =&gt; &#39;&#39;,
    	        &#39;charset&#39;   =&gt; &#39;utf8&#39;,
    	        &#39;collation&#39; =&gt; &#39;utf8_unicode_ci&#39;,
    	        &#39;prefix&#39;    =&gt; &#39;&#39;,
    	    ),

That&#39;s my configuration in config/database.php.

I tried searching on stackoverflow and laravel forums and people suggest that it&#39;s PDO problem and not artisan&#39;s or php&#39;s - I followed those suggestions like adding 

    extension=pgsql.so
    extension=pdo_pgsql.so
in php.ini 

No positive result. It always says `[PDOException]could not find driver.`

Can someone please help resolving this.

Environment that I am using: Mac, laravel 4, MAMP PRO with php 5.4.4


php artisan migrate throwing [PDO Exception] Could not find driver - Using Laravel

I understand that you should NEVER trust user input from a form, mainly due to the chance of SQL injection. 

However, does this also apply to a form where the only input is from a dropdown(s) (see below)?

I&#39;m saving the `$_POST[&#39;size&#39;]` to a Session which is then used throughout the site to query the various databases (with a `mysqli` Select query) and any SQL injection would definitely harm (possibly drop) them. 

There is no area for typed user input to query the databases, only dropdown(s).  

    &lt;form action=&quot;welcome.php&quot; method=&quot;post&quot;&gt;
    &lt;select name=&quot;size&quot;&gt;
      &lt;option value=&quot;All&quot;&gt;Select Size&lt;/option&gt; 
      &lt;option value=&quot;Large&quot;&gt;Large&lt;/option&gt;
      &lt;option value=&quot;Medium&quot;&gt;Medium&lt;/option&gt;
      &lt;option value=&quot;Small&quot;&gt;Small&lt;/option&gt;
    &lt;/select&gt;
    &lt;input type=&quot;submit&quot;&gt;
    &lt;/form&gt;
  

Do I have to guard against SQL injection if I used a dropdown?

I&#39;m just finished installing Ubuntu 13.10. 

I want try Phalcon, and when I build the source (phalcon.so), I have this error : 
            

         from /home/fabrice/Downloads/cphalcon/build/32bits/phalcon.c:204:
    /usr/include/php5/ext/pcre/php_pcre.h:29:18: fatal error: pcre.h: No such file or directory
     #include &quot;pcre.h&quot;
                      ^
    compilation terminated.
    make: *** [phalcon.lo] Erreur 1

My installation of lamp is : 

&gt; sudo apt-get install -y apache2 php5 mysql-server libapache2-mod-php5
&gt; php5-mysql  php5-curl php5-imagick  php5-mcrypt php5-memcache 
&gt; php5-sqlite php5-xdebug php-apc php5-intl  php-mongo php5-dev gcc


Can anybody help me ?

Error building : fatal error: pcre.h: No such file or directory

How to get email id of the user who accepted my Twitter application?

I have gone through lot of forums. But they have mentioned, it is not possible. Also those posts are older than a year. May I know whether it is possible to get the user email id through twitter API using PHP?

I am getting Twitter user details using the following URL:

https://api.twitter.com/1.1/account/verify_credentials.json


  [1]: https://api.twitter.com/1.1/account/verify_credentials.json


Can we get email ID from Twitter oauth API?

I&#39;m trying to create foreign keys in Laravel however when I migrate my table using `artisan` i am thrown the following error:

    [Illuminate\Database\QueryException]
    SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL
    : alter table `priorities` add constraint priorities_user_id_foreign foreign 
    key (`user_id`) references `users` (`id`))     

My migration code is as so:    
    
priorities migration file

    public function up()
	{
		//
		Schema::create(&#39;priorities&#39;, function($table) {
			$table-&gt;increments(&#39;id&#39;, true);
        	$table-&gt;integer(&#39;user_id&#39;);
			$table-&gt;foreign(&#39;user_id&#39;)-&gt;references(&#39;id&#39;)-&gt;on(&#39;users&#39;);
			$table-&gt;string(&#39;priority_name&#39;);
			$table-&gt;smallInteger(&#39;rank&#39;);
			$table-&gt;text(&#39;class&#39;);
			$table-&gt;timestamps(&#39;timecreated&#39;);
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		//
		Schema::drop(&#39;priorities&#39;);
	}

users migration file 

    public function up()
	{
		//
		Schema::table(&#39;users&#39;, function($table)
		{
		$table-&gt;create();
		$table-&gt;increments(&#39;id&#39;);
		$table-&gt;string(&#39;email&#39;);
		$table-&gt;string(&#39;first_name&#39;);
		$table-&gt;string(&#39;password&#39;);
		$table-&gt;string(&#39;email_code&#39;);
		$table-&gt;string(&#39;time_created&#39;);
		$table-&gt;string(&#39;ip&#39;);
		$table-&gt;string(&#39;confirmed&#39;);
		$table-&gt;string(&#39;user_role&#39;);
		$table-&gt;string(&#39;salt&#39;);
		$table-&gt;string(&#39;last_login&#39;);
		
		$table-&gt;timestamps();
		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		//
			Schemea::drop(&#39;users&#39;);
	}

Any ideas as to what I&#39;ve done wrong, I want to get this right now, as I&#39;ve got a lot of tables I need to create e.g. Users, Clients, Projects, Tasks, Statuses, Priorities, Types, Teams. Ideally I want to create tables which hold this data with the foreign keys, i..e `clients_project` and `project_tasks` etc. 

Hope someone can help me to get started. 

Migration: Cannot add foreign key constraint

Am quite new to Laravel and I have to create a form for create and a form for edit. In my form I have quite some jquery ajax posts. Am wondering whether Laravel does provide for an easy way for me to use the same form for my edit and create without having to add tons of logic in my code. I don&#39;t want to check if am in edit or create mode every time when assigning values to fields when the form loads. Any ideas on how I can accomplish this with minimum coding?

Laravel use same form for create and edit

I am trying to create an hashed password for Laravel. Now someone told me to use Laravel hash helper but I can&#39;t seem to find it or I&#39;m looking in the wrong direction. 

How do I create a laravel hashed password? And where?

Edit:
I know what the code is but I don&#39;t know where and how to use it so it gives me back the hashed password. If I get the hashed password then I can manually insert it into the database

How to create a laravel hashed password

Wondering if its possible to change the size of checkbox as it&#39;s possible with buttons. I want it to be bigger, so it makes it easy to press. Right now its looking like this:

![enter image description here][1]


  [1]: http://i.stack.imgur.com/6ANsR.png

Code:

     &lt;div class=&quot;form-group&quot;&gt;
        &lt;label  class=&quot;col-md-7 control-label&quot;&gt;Kalsiumklorid: &lt;/label&gt;
        &lt;div class=&quot;col-md-5&quot; &gt;
          {{ Form::checkbox(&#39;O_Kals_Klor&#39;, 1 , array(&#39;class&#39; =&gt; &#39;form-control&#39; ))  }}  
        &lt;/div&gt;
      &lt;/div&gt;

How can I change the size of a Bootstrap checkbox?

In laravel, we can get the input value via `Input::get(&#39;inputname&#39;)`. I try to change the value by doing this `Input::get(&#39;inputname&#39;) = &quot;new value&quot;;`. But then, I get the error message saying `Can&#39;t use function return value in write context`.

Is it possible for us change the input value so that when later calling on `Input::get(&#39;inputname&#39;)` will get the new amended value?

Thanks.

Laravel change input value

I have a composer file for a laravel installation with the following composer.json file:

    {
        &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;require&quot;: {
            &quot;laravel/framework&quot;: &quot;4.1.*&quot;
        },
        &quot;autoload&quot;: {
            &quot;classmap&quot;: [
                &quot;app/commands&quot;,
                &quot;app/controllers&quot;,
                &quot;app/models&quot;,
                &quot;app/database/migrations&quot;,
                &quot;app/database/seeds&quot;,
                &quot;app/tests/TestCase.php&quot;
            ]
        },
        &quot;scripts&quot;: {
            &quot;post-install-cmd&quot;: [
                &quot;php artisan clear-compiled&quot;,
                &quot;php artisan optimize&quot;
            ],
            &quot;post-update-cmd&quot;: [
                &quot;php artisan clear-compiled&quot;,
                &quot;php artisan optimize&quot;
            ],
            &quot;post-create-project-cmd&quot;: [
                &quot;php artisan key:generate&quot;
            ]
        },
        &quot;config&quot;: {
            &quot;preferred-install&quot;: &quot;dist&quot;
        },
        &quot;minimum-stability&quot;: &quot;stable&quot;
    }
 
I&#39;m trying to add in the bundle for sentry. On sentry&#39;s website it says I can install it by adding the following to my composer.json file:

    {
        &quot;require&quot;: {
            &quot;cartalyst/sentry&quot;: &quot;2.0.*&quot;
        },
        &quot;minimum-stability&quot;: &quot;dev&quot;
    }

I tried adding the new json object at the end of the current laravel one like so:

    ...
    },
    {
        &quot;require&quot;: {
            &quot;cartalyst/sentry&quot;: &quot;2.0.*&quot;
        },
        &quot;minimum-stability&quot;: &quot;dev&quot;
    }

When I run the `composer update` command to load the new package I get an error saying that the new object addition is not valid json.

If I add the `cartalyst/sentry` to the existing `require` object it cannot find the sentry package because the existing requires have a minimum-stability value of `stable`.

Is there a way of specifying the sentry package in a separate require object that has the minimum-stability setting of `dev`?

Composer: required packages with differing levels of minimum-stability

i ran in a problem using composer for installing/uninstalling some dependencies in laravel which coming back after deleting them from ```composer.json``` and deleting their vendor folder, i initially used dflydev&#39;s markdown package but now i wanted to change it to michelf&#39;s php-markdown, but i cant uninstall the old one since it comes back loaded from cache, which i checked at ```AppData\Roaming\Composer``` and is empty, any clue on to why this is happening?

      - Installing dflydev/markdown (dev-master dee1f7a)
        Loading from cache

Composer loading from cache

Can someone explain to me the difference between `NPM`, `Bower` and `Composer`.

They are all package managers - correct?

But when should each one be used?

Also, each one appears to have a json file that accompanies it, does this store all the packages you require so they can be installed by cmd line? Why do you need this file?

NPM/Bower/Composer - differences?

What is the correct way to remove a package from Laravel using PHP Composer?

So far I&#39;ve tried:

1. Remove declaration from file *composer.json* (in the &quot;require&quot; section)
2. Remove any *class aliases* from file *app.php*
3. Remove any references to the package from my code :-)
4. Run `composer update`
5. Run `composer dump-autoload`

None of these options are working! What am I missing?



How can I remove a package from Laravel using PHP Composer?

The fastest and simplest way of installing Laravel is via composer command. From the laravel docs (http://laravel.com/docs/quick), it shows that we can install it with this:

    composer create-project laravel/laravel your-project-name --prefer-dist

But, when you run the above command, it will grab the latest version of Laravel. How can I control it if I want to install latest version of 4.0.x? Or, 4.1.x when 4.2 is out?



Content Type	Original Author	Original Content on Stackoverflow
Question	elvainch	View Question on Stackoverflow
Solution 1 - Php	Yogesh Yadav	View Answer on Stackoverflow
Solution 2 - Php	tliokos	View Answer on Stackoverflow
Solution 3 - Php	Jay Momaya	View Answer on Stackoverflow

Install dependency (doctrine/dbal) on composer laravel

Php Problem Overview

Edit 1

Php Solutions

Solution 1 - Php

Solution 2 - Php

Solution 3 - Php

How big can a MySQL database get before performance starts to degrade

Error: No provider for "framework:jasmine"! (Resolving: framework:jasmine)

Attributions