Viewed   53 times

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?



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:

Wednesday, August 24, 2022

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 weight=1;
        server weight=1;
        server weight=1;
        server weight=1;


    server {
      fastcgi_pass   php_farm;


For the sake of convenience, I created simple batch files.


ECHO Starting sandbox...

RunHiddenConsole.exe phpphp-cgi.exe -b -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b -c phpphp.ini
RunHiddenConsole.exe phpphp-cgi.exe -b -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

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
    WHEN value1 THEN MyColumn IS NULL
    WHEN value2 THEN MyColumn IS NOT NULL
    WHEN value3 THEN TRUE

It is possible to solve this using a case statement, see onedaywhen's answer

Wednesday, August 24, 2022

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


Friday, October 14, 2022

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):

// 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 :