MySQL

Mysql: compare subquery to multiple values in where statement

5 Dec, 2023
If you need to compare multiple columns in your subquery, you can use logical operators within the subquery to combine multiple conditions. Be careful and make sure that the number and data types of...
MySQL

MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery

5 Dec, 2023
While doing a subquery I got this error: "error: SQLSTATE[42000]: Syntax error or access violation: 1235 This version of MySQL doesn't yet support 'LIMIT...
Drupal

Render html of a view in Drupal 7

23 Nov, 2023
Programmatically rendering a view in Drupal involves a structured series of steps. Initially, the target view is loaded using the views_get_view() function, specifying its machine name and the...
JavaScript

Count object keys in javascript

23 Nov, 2023
In JavaScript, you can count the number of keys in an object using the Object.keys() method and then .length is used to get the number of keys in the object.
Drupal

Delete view programmatically in Drupal 7

18 Nov, 2023
There is a function called views_delete_view, that does just that. The only thing is that views_delete_view() function in Drupal 7 takes a view object as its argument, not a machine name.
PHP

PHP: Get last quarter start and end timestamps

14 Nov, 2023
PHP
The code snippet use the DateTime class to calculate the start and end timestamps for the previous quarter. The calculations take into account the current month and adjust it to correctly identify...
PHP

Start and end days of week based on the first day of the week

13 Nov, 2023
PHP
PHP inherently supports ISO date format. With slight modifications we can still detect the start and end days of the week.

Error: "Reason: tried: '/opt/homebrew/opt/libtiff/lib/libtiff.5.dylib' (no such file)"

12 Nov, 2023
Fix for the next error: "Reason: tried: '/opt/homebrew/opt/libtiff/lib/libtiff.5.dylib' (no such file)".. When software is updated, sometimes the updates include changes to dependencies or libraries...
JavaScript

JavaScript event when pressing escape key

7 Nov, 2023
Capturing the "Escape" key press with an event listener is a common practice in web development, especially for modals or dialogs. Example useful cases of using the event: It provides a better user...
Drupal

Drupal 7: Add a filter programmatically to view

27 Oct, 2023
How to add a filter programmatically to a view in Drupal 7 using the hook_views_pre_view alter hook. This is useful when you want to modify the behaviour of a view by adding a filter condition...