MySQL current date

 The following are just examples of the use date offsets;

SET @timeframe=now()-interval 2 year; 

SELECT ...
WHERE o.doe >= @timeframe

SET @timeframe = DATE_SUB(CURDATE(), interval 1 day);
SELECT ...
WHERE o.doe >= @timeframe and o.doe <= @timeframe

The former will deal with the full date/time stamp, while the latter will consider only the date and is good for when we need to find results for a particular day for example.

xfce Desktop and icons dissapear

 Running xfdesktop in the terminal seems to resolve.

MySQL error when trying to create a function

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Power Over Ethernet - PoE

 A point on PoE

Tensorflow Machine Learning models

 PLACEHOLDER

Unable to open or incompatable vdproj solution

When using Visual Studio (recent versions), with vdproj files, you may get an error or warning that the file is incompatible or unable to open.

Bash comparisons

 

integer comparison

-eq

    is equal to

    if [ "$a" -eq "$b" ]

-ne

    is not equal to

    if [ "$a" -ne "$b" ]

-gt

    is greater than

    if [ "$a" -gt "$b" ]

-ge

    is greater than or equal to

    if [ "$a" -ge "$b" ]

-lt

    is less than

    if [ "$a" -lt "$b" ]

-le

    is less than or equal to

    if [ "$a" -le "$b" ]

string comparison

==

    is equal to

    if [ "$a" == "$b" ]

!=

    is not equal to

    if [ "$a" != "$b" ]

[source]

Detect screen size in php

Detecting the screen size in php, is not something that can be done with php alone but the following is what I use to kind of get around it.

Get next AUTO INCREMENT value from a mysql table

SELECT AUTO_INCREMENT as 'next_id' FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name';

 Restoring a fsarchiver file to a temporary block device.