SQL query to list Users in MySQL Database

>SELECT CONCAT(QUOTE(user),'@',QUOTE(host)) UserAccount FROM mysql.user ORDER BY user ASC;

Setting up Apache Virtual Hosts on XAMPP

C:\xampp\apache\conf\extra\httpd-vhosts.conf

# NameVirtualHost *:80 # deprecated
# NameVirtualHost *:443 # deprecated

<VirtualHost *:80>
        DocumentRoot "C:/XAMPP/htdocs"
        ServerName localhost
    </VirtualHost>
    <VirtualHost *:443>
        DocumentRoot "C:/XAMPP\htdocs"
        ServerName localhost
        SSLEngine on
        SSLCertificateFile "conf/ssl.crt/server.crt"
        SSLCertificateKeyFile "conf/ssl.key/server.key"
    </VirtualHost>

    <VirtualHost *:80>
        DocumentRoot "C:/xampp/htdocs/someSite"
        ServerName [dns]
        ServerAlias [fqdns]
        <Directory "C:/xampp/htdocs/someSite">
            Options Indexes FollowSymLinks Includes ExecCGI
            AllowOverride All
            Order allow,deny
            Allow from all
        </Directory>
    </VirtualHost>
    <VirtualHost *:443>
        DocumentRoot "C:/xampp/htdocs/someSite"
        ServerName [dns]
        ServerAlias [fqdns]
        SSLEngine on
        SSLCertificateFile "conf/ssl.crt/server.crt"
        SSLCertificateKeyFile "conf/ssl.key/server.key"
        <Directory "C:/xampp/htdocs/someSite">
            AllowOverride All
            Order allow,deny
            Allow from all
        </Directory>
</VirtualHost>

Create ImDisk image from command line tool

>rawcopy -mld \\.\Y: "C:\RAM disks\Y.img"

Source: http://forums.guru3d.com/showthread.php?t=356046

XAMPP set root password

$mysqladmin.exe -u root password secret

Source: https://www.apachefriends.org/faq_windows.html

PHP prefered modules

PHP 5.6

• php_bz2.dll
• php_curl.dll
• php_mbstring.dll
• php_exif.dll
• php_gd2.dll
• php_gettext.dll
• php_mysql.dll
• php_mysqli.dll
• php_openssl.dll
• php_pdo_mysql.dll
• php_pdo_sqlite.dll
• php_soap.dll
• php_sockets.dll
• php_sqlite3.dll
• php_xmlrpc.dll
• php_xsl.dll

PHP 7

• php_bz2.dll
• php_curl.dll
• php_mbstring.dll
• php_exif.dll
• php_gd2.dll
• php_gettext.dll
• php_mysqli.dll
• php_openssl.dll
• php_pdo_mysql.dll
• php_pdo_sqlite.dll
• php_soap.dll
• php_sockets.dll
• php_sqlite3.dll
• php_xmlrpc.dll
• php_xsl.dll

Activating XDebug on PHP

• Download and adequate XDebug DLL from XDebug download site section
• Place the DLL into your PHP ext folder, mine is C:\xampp\php\ext
• Edit your php.ini files and add this lines:

zend_extension = [pathToYouDLLinsideExtFolder]
;mine was: zend_extension =  C:\xampp\php\ext\php_xdebug-2.4.0-5.6-vc11.dll

[xdebug]
xdebug.remote_enable=1
xdebug.remote_host=localhost
xdebug.remote_port=9000

If you are using a Web Server to execute your scripts, restart it.

If you got some problem, use XDebug Wizard

Aptana Studio 3 Tweaks

Menu Bar > Window > Preferences > General > Appearance > Theme: Dark Studio;

Menu Bar > Window > Preferences > General > Workspace > New Text Files Line Delimiter: Unix;

Menu Bar > Window > Preferences > General > Workspace > Text File encoding: utf-8;

Menu Bar > Window > Preferences > Aptana Studio > Themes > Editor Theme: Monokai;

Menu Bar > Window > Preferences > Aptana Studio > Themes > Editor Theme > Selection: 222222;

Menu Bar > Window > Preferences > Aptana Studio > Editors > Enable Word Wrap: checked;

Menu Bar > Window > Customize Perspective > Command Groups Availabilty > Available Command Groups > External Tools: checked;