Brief introduction to problem:
I need to load pdo_mysql to run command php app/console doctrine:database:create
and other commands for Symfony2.
I found a way to do this by running php -c "path/to/my/php.ini" app/console doctrine:database:create
Problem:
Since I don't want to add the path to my php.ini everytime I run commands in PHP CLI, where/how can I setup Windows, so that everytime I type php somecommand
in console it will load my desired php.ini file?
What if you add
path/to/your/php.ini
to the path environment variable and then just runphp -c "php.ini" app/console doctrine:database:create
Could you try that?
There are several ways to do it, but if you don't want to mess with an alias or making multiple copies of php.ini, you can also set the PHPRC environment variable. I would think this is the recommended method to set it more "permanently".
More info in PHP documentation: http://php.net/manual/en/configuration.file.php
In Windows, an easy way to do this is to go to the "System Properties" dialog; either right-click on "My Computer" and click "Properties", or use the "System" item in Control Panel, then go to "Advanced" settings, click "Environment Variables", and click "Add" for either the system or your user, call it "PHPRC" and copy the path to your .ini file in there ... for example, mine was in
C:\MAMP\conf\php5.6.28
.(this was on Win 7, they change some of the UI in different versions, but it's basically the same)
You can verify it's working by doing
php --ini
from the command line, output should be something like:Configuration File (php.ini) Path: C:\Windows Loaded Configuration File: C:\MAMP\conf\php5.6.28\php.ini Scan for additional .ini files in: (none) Additional .ini files parsed: (none)
you can also doecho %PHPRC%
from windows command prompt, orecho $PHPRC
from Cygwin/bash/MinGW, etc. You will have to restart any existing terminal sessions for this to take effect, but in my experience it works for all three, since the bash environments also inherit the Windows environment variables.Create a .CMD file which automatically runs PHP with the required options:
and call it something like
phpcli.cmd
. Make sure it's on your search path and off you go. The only change you need to make is to run phpcli rather than php.