Javascript | Trigger Change event on select
var mySelect = document.querySelector(“#mySelect”); mySelect.value = “newvalue”; mySelect.dispatchEvent(new Event(‘change’, { ‘bubbles’: true }));
Find Most executed queries in SQL Server
SELECT TOP 100 QueryState.execution_count, OBJECT_NAME(objectid), query_text = SUBSTRING( qt.text, QueryState.statement_start_offset / 2, ( CASE WHEN QueryState.statement_end_offset = -1 THEN len(convert(nvarchar(max), qt.text)) * 2 ELSE QueryState.statement_end_offset END – QueryState.statement_start_offset ) / 2 ), qt.dbid, dbname =…
The Importance of Having a CDN Service for Your Website
Introduction: In today’s digital age, having a fast and reliable website is crucial for businesses and individuals alike. One of the key factors that contribute to a website’s performance is the use of a Content…
Format dates in PHP
Formatting dates in PHP is an essential task for any web developer. It is important to display dates in a format that is easy to read and understand for users. In this article, we will…
jQuery to pure Javascript examples – 6
Check if HTML element exists // jQuery if($(“#myElm”).length > 0) { console.log(“Element exists”); } // Pure javascript var my_elm = document.getElementById(“myElm”); if(typeof(my_elm) != ‘undefined’ && my_elm != null){ console.log(“Element exists”); }
Easily convert UNIX timestamp to datetime in SQL Server
Simple copy-and-paste example: DECLARE @timestamp BIGINT = 1661881445; SELECT DATEADD(S, @timestamp, ‘1970-01-01’) Or for values greater than 2147483647 DECLARE @t AS BIGINT = 4956739375 DECLARE @oneyear AS INT = 31622400 SELECT DATEADD(SECOND, @t % @oneyear,…
Remove substring from string in PHP
/** * Remove substring from string * * Here is an inline example: * <code> * <?php * echo rmv(‘mxaxuxix’, ‘x’); // return ‘maui’; * * ?> * </code> * @param string $subject * @param…
PHP | Convert an array to an html table
function att($arr, $class = null) { $return = “<table” . (!is_null($class) ? ‘ class = “‘ . $class . ‘”‘ : null) . “>”; foreach ($arr as $key => $value) { $return .= “<tr>”; foreach…
The free version without registration of the sitemap generator service will be discontinued.
We regret to announce that the sitemap generator service in the free version without registration will be ineterrupted from 08/08/2022. It will remain available only to registered users. We had to make this decision due…
What’s New for January 2022
We haven’t heard from you in a long time, but we haven’t abandoned the project. We are going back to work more motivated than before thanks to your support. Here’s what’s new this month: The…