How to Redirect from HTTP to HTTPS

by

 Set up your redirects in your .htaccess file: <IfModule mod_rewrite.c>RewriteEngine OnRewriteCond %{HTTPS} offRewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI}[L,R=301]</IfModule> Look confusing? Here’s the breakdown:  You can also solve this from within PHP in case your provider has disabled .htaccess (which is unlikely since you asked for it, but anyway)

An Overview of the Medallion Pipeline

by

Data pipeline name: Medallion to Bronze ETL Pipeline Owner: Data Engineering Team Used since: July 2023 Purpose: The Medallion pipeline is an automated process that handles the extraction, loading, and processing of CSV data from SATUK or GMISUK systems into bronze storage as parquet files. Overview The Medallion pipeline begins by setting source variables based … Read more

A Quick and Easy Guide To Creating WordPress Admin Pages

by

https://wpmudev.com/blog/creating-wordpress-admin-pages/ Creating a Top-Level Admin Page The first step is to create a menu entry with the add_menu_page() function. Here’s a full example, explanation ensues: add_action( ‘admin_menu’, ‘my_admin_menu’ ); function my_admin_menu() { add_menu_page( ‘My Top Level Menu Example’, ‘Top Level Menu’, ‘manage_options’, ‘myplugin/myplugin-admin-page.php’, ‘myplguin_admin_page’, ‘dashicons-tickets’, 6 ); } view rawtop level hosted with ❤ by GitHub The function takes seven arguments. … Read more

Install via Composer

by

Create a file named composer.json in the root of your project and add the following code to it: { “require”: { “microsoft/windowsazure”: “^0.5” } } Download composer.phar in your project root. Open a command prompt and execute this in your project root php composer.phar install If you are using the PHP version 8, some of … Read more

Find Database User and Role

by

SELECT RoleP.name AS DatabaseRoleName ,ISNULL(UserP.name, ‘No members’) AS DatabaseUserName ,UserP.principal_id ,UserP.create_date FROM sys.database_role_members AS DRM RIGHT OUTER JOIN sys.database_principals AS RoleP ON DRM.role_principal_id = RoleP.principal_id LEFT OUTER JOIN sys.database_principals AS UserP ON DRM.member_principal_id = UserP.principal_id WHERE RoleP.type = ‘R’ and UserP.name = ‘my-name’ ORDER BY RoleP.name, ISNULL(UserP.name, ‘No members’);

Decode URL

by

CREATE FUNCTION dbo.UrlDecode(@url varchar(3072)) RETURNS varchar(3072) AS BEGIN DECLARE @count int, @c char(1), @cenc char(2), @i int, @urlReturn varchar(3072) SET @count = Len(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = substring(@url, @i, 1) IF @c LIKE ‘[!%]’ ESCAPE ‘!’ BEGIN SET @cenc = substring(@url, @i + … Read more

Encode URL

by

Version 2 CREATE FUNCTION dbo.UrlEncode(@url NVARCHAR(1024)) RETURNS NVARCHAR(3072)ASBEGIN DECLARE @count INT, @c NCHAR(1), @i INT, @urlReturn NVARCHAR(3072) SET @count = LEN(@url) SET @i = 1 SET @urlReturn = ” WHILE (@i <= @count) BEGIN SET @c = SUBSTRING(@url, @i, 1) IF @c LIKE N'[A-Za-z0-9()”*\-._!~]’ COLLATE Latin1_General_BIN ESCAPE N’\’ COLLATE Latin1_General_BIN BEGIN SET @urlReturn = @urlReturn … Read more