Possible Duplicate:
How do i edit php.ini file in xampp server
I ran phpinfo and it said it was in C:Windows but it's not there. It's not in the php folder. I did a system search and it wasn't found.
Where is it hiding?
windows
php
Answers
4
I ended up with this solution: you simply start several php-cgi processes and bind them to different ports, and you need to update nginx config:
http {
upstream php_farm {
server 127.0.0.1:9000 weight=1;
server 127.0.0.1:9001 weight=1;
server 127.0.0.1:9002 weight=1;
server 127.0.0.1:9003 weight=1;
}
...
server {
...
fastcgi_pass php_farm;
}
}
For the sake of convenience, I created simple batch files.
start_sandbox.bat:
@ECHO OFF
ECHO Starting sandbox...
RunHiddenConsole.exe phpphp-cgi.exe -b 127.0.0.1:9000 -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b 127.0.0.1:9001 -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b 127.0.0.1:9002 -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b 127.0.0.1:9003 -c phpphp.ini
RunHiddenConsole.exe mysqlbinmysqld --defaults-file=mysqlbinmy.ini --standalone --console
cd nginx && START /B nginx.exe && cd ..
and stop_sandbox.bat:
pstoolspskill php-cgi
pstoolspskill mysqld
pstoolspskill nginx
as you can see, there are 2 dependencies: pstools and runhiddenconsole.exe
Tuesday, November 8, 2022
3
Here is how you can solve this using a single WHERE clause:
WHERE (@myParm = value1 AND MyColumn IS NULL)
OR (@myParm = value2 AND MyColumn IS NOT NULL)
OR (@myParm = value3)
A naïve usage of the CASE statement does not work, by this I mean the following:
SELECT Field1, Field2 FROM MyTable
WHERE CASE @myParam
WHEN value1 THEN MyColumn IS NULL
WHEN value2 THEN MyColumn IS NOT NULL
WHEN value3 THEN TRUE
END
It is possible to solve this using a case statement, see onedaywhen's answer
Wednesday, August 24, 2022
4
The WHERE clause filters data from the source before aggregates, whereas HAVING clause filters data after the GROUP BY has been applied. Generally this means any non-aggregate filter can appear in either place, but if you have a column that is not referenced in your query, you can only filter it in a WHERE clause.
For example, if you have the following table:
| ID | VALUE |
--------------
| 1 | 15 |
| 2 | 15 |
| 3 | 20 |
| 4 | 20 |
| 5 | 25 |
| 6 | 30 |
| 7 | 40 |
Suppose you wanted to apply the following query:
select value, count(value)
from Table1
group by value
But you only wanted to include rows where ID > 2. If you put that in a HAVING clause, you will get an error, because the ID column is not available post aggregate as it is not in the SELECT clause. In that case, you would be required to use a WHERE clause instead:
select value, count(value)
from Table1
where id > 2
group by value
Demo: http://www.sqlfiddle.com/#!2/f6741/16
Friday, October 14, 2022
38
Update Windows8.1-KB2999226-x64.msu fails to install with the error 0x80240017 wich means the update doesn't apply to your system (wrong architecture, update already replaced by newer one with is installed):
//
// MessageId: WU_E_NOT_APPLICABLE
//
// MessageText:
//
// Operation was not performed because there are no applicable updates.
//
#define WU_E_NOT_APPLICABLE _HRESULT_TYPEDEF_(0x80240017L)
Microsoft deployed the a newer version of the Univeral C Runtime with KB3118401. Look if you have the Update KB3118401 installed and if yes, remove the update KB3118401, reboot and try again to install the Runtime.
Tuesday, August 30, 2022
Only authorized users can answer the search term. Please sign in first, or register a free account.
Not the answer you're looking for? Browse other questions tagged :
windows
php
Run this code (and I am assuming your php is running, you are not able to just locate the php.ini file)
And check the location of the config file: