Codebase
Last updated:
Asynchronous PHP calls with XMLHttpRequest
Async PHP calls with XMLHttpRequest
Codebase
The Codebase category is a curated repository of scripts, snippets, and programming insights designed to automate the mundane and solve the complex. Rather than generic examples, these posts focus on functional logic in PowerShell, PHP, Python, and Batch-tailored for system administrators and DevOps engineers who need code that works in production environments.
From deep-dives into regular expressions and API integrations to optimizing legacy scripts for modern kernels, this section serves as a technical reference for building more efficient workflows. Whether you are refactoring a deployment script or debugging a niche environment variable, you’ll find the practical code blocks and logic needed to bridge the gap between development and operations.
Codebase
Last updated:
Optimize all MySQL tables with MySQLi multi_query
PHP MySQLi extension supports multiple queries which are concatenated by a semicolon. We can use this to optimize all MySQL tables in one single multi_query statement.
Codebase
Last updated:
Add websites and application pools to IIS with PowerShell, in a for loop
How to use PowerShell to add websites and application pools in IIS
Codebase
Last updated:
Connect to MS SQL Server with PHP 5.3+
As of PHP 5.3.2 you have to use the SQLSRV API functions to connect to an Microsoft SQL Server database from PHP. For example, use sqlsrv_connect() to create a connection resource and open a connection. Learn how to connect to a Microsoft SQL Server database using PHP 5.3+ and SQLSRV.