SQL – How to convert line separated text to comma separated
This T-SQL code demonstrates how to convert line separated text in a SQL Server table into comma separated text using multiple nested REPLACE functions.
REPLACE
Excel 2016 – How to exclude (blank) values from pivot table
Learn how to exclude blank values from an Excel 2016 pivot table using a simple step-by-step method. Apply a filter on the labels to exclude blank values and make your…
SQL -Find and replace text in string
This T-SQL code demonstrates how to use the REPLACE function in Microsoft SQL Server to replace "PO Box" with "P.O. Box" in a string while using a WHERE clause to…
PHP script to test HTTPS secure connection through proxy server
This PHP script tests whether a web server can establish an HTTPS connection via a proxy server by sending a request to a specified URL. Useful for testing payment gateways…
WordPress – How to automatically redirect users after password reset
This code redirects users to the home page after they've reset their password in WordPress, using the `wp_redirect` function and adding it to the `after_password_reset` action hook. It is recommended…
WordPress – How to disable comments for new/existing posts and pages
Learn how to disable comments for new and existing posts and pages in WordPress using four different methods. From disabling comments for all posts and pages using PHP code, to…
WordPress – How to add custom column to Custom Post Type posts list
Add a "Usefulness" column to your Custom Post Type posts list in WordPress using the provided code snippet. Populate the column with data from post meta and make it sortable…
WordPress – How to add “Last Modified” column to page and post lists
Add "Last Modified" Column to Page & Post Lists in WordPress with Sortable Data - Code Included | WP ExpertAdd the "Last Modified" column to page and post lists in…
How to add custom column to WordPress posts list
Add a "Last Modified" column to WordPress posts and pages list with this code snippet. Sortable and customizable, place it in a plugin for easy management.